Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes

[shubhamjain]

https://textquery.app/

Hiya HN!

TextQuery is my sabbatical project that I have been working on for the past six months.

It was born out of a personal pain point. Anytime I wanted to analyze raw CSV data, I had to create a schema first before I could import it for querying. And to create charts, I had to use yet another tool. I also disliked how bad charts from popular tools like Excel, Google Sheets looked like.

I wanted an easier way to do this and TextQuery was my solution: an all-in-one tool to query CSV files using SQL and create beautiful visualizations as well. Currently, it's a macOS app and focused on CSV files, but my larger vision is to make it multi-platform, and support a wide variety of raw data formats (xlsx, parquet, XML, json).

Happy to hear your thoughts and answer your questions!

[skeptrune]

My goto for a while has been - https://github.com/YS-L/csvlens

This seems quite good, but I'd rather a terminal app.

[skeptrune → skeptrune]

I realize it's not really that comparable since these tools don't support SQL, but a more fully functioned CLI tool is - https://github.com/BurntSushi/xsv

They are both fairly good

[mutant → skeptrune]

Have you tried Datasette? (Not terminal) https://github.com/simonw/datasette