Show HN: SQL Explorer – Open-source reporting tool that Just Works https://ift.tt/0pvEtdw

Show HN: SQL Explorer – Open-source reporting tool that Just Works 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): https://ift.tt/Ka4QWOr And here's a fairly unprofessional, but very enthusiastic, video tour: https://ift.tt/8QEubPM 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! https://ift.tt/8KhLRgp July 2, 2024 at 05:26AM