I have been working on SQL Explorer, an open source, Django-based reporting and query tool for (gulp!) almost ten years. It's a tool that fits just right for me and many others, and I love and use almost every day. Write SQL, share results, do some analysis, get insight. No surprises.

A live demo instance is here (no login or anything required):

And here's a fairly unprofessional, but very enthusiastic, video tour:

https://sql-explorer.s3.amazonaws.com/Sql+Explorer+5.mp4

The UI is constrained enough that there's very little to learn, while there is still a surprising amount of functionality and flexibility to address a lot of use cases.

Some of the stuff I'm excited about in the latest version:

- Intuitive and obvious integration to ChatGPT / the AI API of your choice. Doesn't purport to be 'magic'. Good prompting + relevant table scheme & data automatically injected into the prompt.

- Create a new connection by uploading a CSV or SQLite DB as a new connection, and it's instantly queryable. CSVs are parsed, types inferred, and a SQLite DB gets created (persisted to s3). - New and improved SQL editor with strong autocomplete (based on your schema), and some fancy keyboard shortcuts.

Some of the old stuff that is still great:

- Pivot tables in-browser, so you don't have to open results in Excel for basic analysis. Unique URLs make everything shareable.

- Expose queries (optionally) as JSON endpoints. Great for prototyping APIs and scripts.

- All of the stuff you'd expect in a reporting tool (email reports, logging, favorites, exporting, etc.)

Hope you enjoy!

1.	ChatGPT as the AOL of AI(rebecca-powell.com) 5 points by maille 40 days ago \| 1 comment
2.	Ask HN: Read‑only LLM tool for email triage and knowledge extraction? 2 points by maille 115 days ago \| 4 comments
3.	OpenAI in talks to buy Windsurf for about $3B(reuters.com) 3 points by maille 1 year ago \| 1 comment

user:	maille
created:	November 11, 2020
karma:	42