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.<p>A live demo instance is here (no login or anything required):<p><a href="https://demo.sqlexplorer.io/" rel="nofollow">https://demo.sqlexplorer.io/</a><p>And here's a fairly unprofessional, but very enthusiastic, video tour:<p><a href="https://sql-explorer.s3.amazonaws.com/Sql+Explorer+5.mp4" rel="nofollow">https://sql-explorer.s3.amazonaws.com/Sql+Explorer+5.mp4</a><p>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.<p>Some of the stuff I'm excited about in the latest version:<p>- 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.<p>- 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.<p>Some of the old stuff that is still great:<p>- Pivot tables in-browser, so you don't have to open results in Excel for basic analysis. Unique URLs make everything shareable.<p>- Expose queries (optionally) as JSON endpoints. Great for prototyping APIs and scripts.<p>- All of the stuff you'd expect in a reporting tool (email reports, logging, favorites, exporting, etc.)<p>Hope you enjoy!
Nice tool! I built <a href="https://sql-workbench.com/" rel="nofollow">https://sql-workbench.com/</a> which runs completely in-browser via DuckDB WASM, and enables querying of remote CSV, JSON, Parquet and Arrow data sources, as well as uploaded local files. Charts are supported as well, see the accompanying blog post <a href="https://tobilg.com/using-duckdb-wasm-for-in-browser-data-engineering" rel="nofollow">https://tobilg.com/using-duckdb-wasm-for-in-browser-data-eng...</a>
Just wanted to say thank you for all your effort on SQLExplorer, I incorporated it into our open source radiotherapy quality assurance project (<a href="https://qatrackplus.com" rel="nofollow">https://qatrackplus.com</a>) years ago and it's been a great addition and is used in hospitals around the world :)
I spent 10 mins on your docs, website.<p>Excellent effort overall.<p>But I didn't know until I read your comment here about the uploading CSV, instant parsing that non technical people may find very interesting. This is something pgweb for example doesn't have.<p>Your docs are also missing a complete sample env.<p>See that you've integrated pivottable. Nice touch!<p>If you can figure out minimal barcharts , you may even have an opensearch/log community interested.<p>Another killer idea is uploading CSV/json and getting faceted search.
No one does this! But maybe distracting to your roadmap.<p>Keep up the excellent work!<p>Good luck!
I've been self-hosting this <a href="https://github.com/dbgate/dbgate">https://github.com/dbgate/dbgate</a> for a few years.<p>But I like some of the features in SQL Explorer interesting - like Pivot tables and exposing queries as JSON endpoints.
> * All content that resides under the "explorer/ee/" directory of this repository is licensed under the license defined
in "explorer/ee/LICENSE".<p>Not really open source. If you care about that.
Just discovered this and got the test project up and running... but wondering how to enable CSV import?<p>The "upload csv file" box does not show up in the test project.
Awesome project. But a somewhat irrelevant suggestion. OP could have shared the video via YouTube for better user experience (adaptive bitrate streaming) and also not had to worry about paying for S3.
Thanks for open sourcing, I’ll definitely give this a try!<p>Any reporting tool is only as good as the data available to it.<p>I built Multiwoven, a Reverse ETL with SQL capabilities, to sync data from any data warehouse to destinations like this one.<p><a href="https://github.com/Multiwoven/multiwoven">https://github.com/Multiwoven/multiwoven</a>
Great job! And congrats on actually getting something out there. I can really see this being useful for some organizations.<p>I also envisioned this same type of tool around 10 years ago and it is still on my ever growing list of ideas to implement. I took the idea further to support not only SQL but other languages such as HTML, JavaScript, Python, C#, etc. You could then support returning different types of media based on the URL extension such as .html to return a webpage, .json to return a JSON API, .csv to return a CSV file, etc. As time marched on, many of these same ideas came to fruition in things like AWS Lambda, Jupiter Notebooks, Microsoft Monaco Editor, etc.
This is awesome, I hope I get a chance to use it once.<p>One thought: I think the effort should be put into the UI for the non-technical end users, instead of query builders/developer experience. I would be even fine with a tool doesn't even have a query tool and just executes SQL files from a folder/git repo. The important part would be for me to provide a perfect experience for the end users. Developers usually have a lot of tools at hand to create queries, no need for another one.
nice work, it would be better to add graphic walker for interactive data visualization (also include pivot table): <a href="https://github.com/Kanaries/graphic-walker">https://github.com/Kanaries/graphic-walker</a>
I like the simplicity, and yet there is a lot of stuff to do.<p>I know there are bunch of tools that do this (superset, redash, dbeaver web etc.) but there is a great value in the feature and UX choices of any particular tool.<p>Keep it up m8.
Great effort! Feels like you should be charging for this, maybe a Pro Plan with SSO (user edits integrated into your history logs) and 1 year support for SMEs to self-host.