TextQuery is an all-in-one desktop app to import, query, transform, and visualize your raw data (CSV, JSON, XLSX) using SQL.
Why TextQuery?
You can already do data analysis using Excel/Pandas/SQLite/CLI, so why use another tool? That's fair, but like that, chances are you also…
- Spend too much time in defining schemas or importing data.
- Switch between tools when you want to quickly visualize your results.
- Find yourself writing code or a bunch of commands when you should just writing SQL.
- Your tools give up if you throw a moderately large dataset.
TextQuery is a desktop-first tool designed to solve these problems. It's fast, clean, and engineered to handle large datasets.
If you love SQL, you'd love TextQuery.
Built for Productivity
TextQuery is designed to be get things done. Datasets can be imported, queried, and visualized within seconds.
- Import Anything: Import multiple data formats in seconds without writing code or creating schemas. TextQuery automatically parses your data and creates the schema.
- Designed for Large Workloads: Excel, Pandas might take forever to work with large files. TextQuery can import 1GB+ files under 5sec.
- Fast and Simple UI: We hate app bloat as much as you do. TextQuery's design is fast, smooth, and built to get the job done.
- Incredibly Fast Querying: TextQuery is designed to run analytical queries on large datasets with speed (no indexes required!).
Create Beautiful Charts
Replace your ugly charts with TextQuery's sleek, customizable ones. Every chart you see here was made with TextQuery.
Best bang for your buck!
TextQuery has host of other features to help you analyze your data.
- Import from Various Sources: Import data from a URL, clipboard, or file. Save time by skipping downloads or creating new files.
- Data Export: Export your SQL results as JSON, CSV, or Excel file with just a few clicks.
- Autocomplete SQL: Save time in writing queries by smart autocomplete that suggests table names, functions, and parameters.
- Table Browser: Browse through your data with ease. Even with gigabytes of data, TextQuery won’t break a sweat.