nowfound

Dev tools · July 2, 2024

SE

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://demo.sqlexplorer.io/ 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,…

In plain words

SQL Explorer is an open-source Django-based tool for writing SQL queries, sharing results, and performing data analysis. Built over nearly a decade, it is designed for data analysts and developers who need straightforward reporting without complexity. The interface is minimal and intuitive to learn, yet offers substantial functionality including AI integration for query assistance. A live demo is available without login required.

written from the facts on this page · September 2026

From the sources

In the maker’s words, at launch

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://demo.sqlexplorer.io/ 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!

Does the same job

all alternatives →
  • 1Y
    10 Years to Build a Free SQL Editor2024 · timestored.com · ▲355

    I have spent large parts of the last 10+ years building an SQL Editor. The tool is targeted at data analysts, a lot of effort has gone into charting, visualizing and excel export. If this sounds useful to you, it's Free, please give it a try and let me know any feedback.

  • SD
    SQLite Database Explorer2024 · github.com · ▲188

    SQLite database explorer

  • VS
    Visual SQL2020 · chartio.com · ▲512
  • Evidence2021 · ▲113

    Beautiful reports with just SQL and markdown

  • DB ExplorerApr 2026 · sourceforge.net · ▲66

    Modern AI‑first database client

  • Learn SQL with Codecademy and Periscope2015 · ▲249

    Learn SQL - the preferred tool of data analysts everywhere …

More dev tools this month

the category →
  • Dograh592

    The open source VAPI alternative

    Dev tools · 25d ago · dograh.com

  • Meridian530

    Don't let your work go unnoticed. Get promoted!

    Dev tools · 20d ago · meridiona.com

  • x1516

    Lovable for iPhone apps go from idea to App Store

    Dev tools · 11d ago · x1.new

  • The first open-source price index for GPU compute

    Dev tools · 10d ago · getcomputable.com

  • OpenTrailPaper is open-source bike computer firmware for the LilyGO T5S3 4.7" E-Paper PRO. It supports offline maps, GPX routes, FIT recording and Bluetooth sensors.

    Dev tools · 2d ago · opentrailpaper.com

  • Open-source GTM skills for technical founders

    Dev tools · 29d ago · gtmcofounder.com

Launched alongside, July 2024

the whole month →
  • Sugar detox app

    AI · 2024 · apps.apple.com

  • Mobbin 2.01,657

    Discover real-world design inspiration

    Work · 2024 · mobbin.com

  • folk 3.01,591

    The CRM for companies who care about people

    Dev tools · 2024 · folk.app

  • SuperGPT1,206

    Use ChatGPT on Google Sheets

    AI · 2024 · superjoin.ai

  • IC

    Many years ago, I made VJ softwares (to mix live visuals in clubs) for unexpected platforms like the Game Boy Advance, the Playstation 2 and the Raspberry Pi. This year, I’m back with a new web-app: Pikimov. Inspired by Photopea (a free Photoshop clone), I created this web-based motion design & video editor as an alternative to After Effects, to fill empty void. It's free, without signup, without cloud uploads (your files stay on your machine), and your projects are not used for AI models training.

    AI · 2024 · pikimov.com

  • Motiff1,150

    AI powered professional UI design tool

    AI · 2024 · motiff.com