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!

user:	joelhaasnoot
created:	August 3, 2010
karma:	1.7k
about:	Head of Engineering at Apollo Agriculture - bringing financing to smallholder farmers in Africa.