Show HN：TextQuery——使用SQL查询CSV、JSON、XLSX文件
Show HN: TextQuery – Query CSV, JSON, XLSX Files with SQL

原始链接: https://textquery.app/

TextQuery是一款桌面应用程序，旨在帮助用户本地分析数据，提供导入、查询、修改和使用SQL可视化数据的工具。它支持多种数据格式，包括.xlsx、.csv、.json和压缩文件。该应用程序具有强大的SQL编辑器，包含自动补全、查询历史记录和格式化选项。用户可以创建自定义图表，例如折线图、柱状图、饼图和散点图。 TextQuery强调易用性，具有内联编辑器、过滤器和基于选项卡的工作区等功能。数据可以导出为多种格式。该应用程序提供永久许可证和免费更新，并优先考虑用户隐私和安全，不记录或发送用户数据。键盘快捷键提高了效率，并且会根据用户反馈不断改进。在升级到专业版之前，可以免费试用限制版本。

TextQuery是一款使用SQL查询CSV、JSON和XLSX文件的新应用，正在Hacker News上引发讨论。它基于DuckDB构建，提供桌面UI以方便快速数据分析。一些人认为它用户友好的GUI以及可视化和并行处理等功能很有价值，但另一些人则质疑其市场竞争力，因为存在DuckDB（本身也带UI）、SQLite、Nushell和Clickhouse等免费的开源替代方案。主要担忧包括：吸引熟悉SQL但会选择免费选项的付费用户存在困难；缺乏Parquet支持；以及承诺“终身更新”的定价模式。一些用户建议增加一次导入多个文件和支持XML的功能。其他人则提到了SQL-Workbench、Steampipe和SpiceAI等竞争工具。一位用户赞赏其“一次性付费”的模式。然而，关于终身更新是否涵盖主要版本升级仍然存在疑问，这可能会导致未来承诺无法兑现。

Analyze Data Locally

TextQuery is an all-in-one desktop app to import, query, modify, and visualize your raw data with SQL.

Download TextQuery For Free

Available for macOS and Windows

Trusted by 1500+ individuals from organizations like these

Import Data in a Few Clicks

TextQuery lets you import multiple data files without needing to define schema, writing code, or commands.

Supported Formats

Data Files .xlsx, .xls, .csv, .tsv

Structured Data .json, .jsonld

Compressed Archives .zip, .gz, .tgz, .tar

Powerful SQL Editor

Our best-in-class SQL editor offers multiple features to help you write queries faster.

SQL Autocomplete

Query History and Favorites

Query Formatter

Multiple Selections

Create Beautiful Charts

Create clean, beautiful charts right within the app. Simple to use and easy to customize.

Supports Line, Bar, Area, Scatter, Pie Charts

Customize Title, Description, and Colors

Export to a file or share directly from clipboard

Thoughtful Features That Simplify Work

Inline Editor

Quickly edit values, collect your changes, and commit them in one go.
Filters

Quickly narrow down table's rows using filters. No need to write queries manually.
Tabs

Work on multiple queries and tables simultaneously using tabs.
Data Export

Export data in multiple formats (CSV, JSON, Excel, SQL) or create another table with the results.

This is a wonderful app! There's essentially no learning curve if you already know SQL, and the chart creation feature is fantastic.

Greg Williams

Gxwilso

First-class Desktop Experience

Pay Once, Use Forever

We hate needless subscriptions as much as you do. TextQuery comes with a perpetual license with free updates.

Built with Privacy & Security in Mind

TextQuery neither records nor sends anything related to your usage . You can query sensitive data with complete peace of mind.

Keyboard Shortcuts

Every frequently used function is accessible via a keyboard shortcut, making you fast and efficient.

Always improving

We are constantly improving the app from your feedback, and from own usage. In past few months, we have shipped hundreds of improvements .

Try TextQuery For Free

Evaluate our free version with certain limitations and upgrade to Pro when you feel like it.

Download TextQuery

Show HN：TextQuery——使用SQL查询CSV、JSON、XLSX文件 Show HN: TextQuery – Query CSV, JSON, XLSX Files with SQL