nowfound

Dev tools · alternatives · 2026

24 alternatives to A Web-Based Visual Query Designer for MySQL

I built this web-based developer utility few years ago when I couldn't find any opensource GUI-based query builder for mysql (similar to what MS Access had). This app can be run locally. The online demo uses static hardcoded values. Screencast's link is included in the README file.

This is a web-based visual query designer for MySQL that allows developers to build database queries using a graphical interface, similar to Microsoft Access. The tool runs locally and was created to fill the gap of… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. A Web-Based Visual Query Designer for MySQL launched in 2023; newer entries below may have overtaken it.

  1. 1

    Through months of design, prototypes, and user tests we made a visual version of SQL - which has proven to enable 80% of business users to write complex quer…

    2020 · chartio.com · its alternatives →

  2. 2

    Search for files using a fun query language. Contribute to kashav/fsql development by creating an account on GitHub.

    2017 · github.com · its alternatives →

  3. 3

    We just launched Outerbase Studio, the open-source version of our core database offering. It works in your browser or as a desktop app and supports MySQL, PostgreSQL, and SQLite. What it does: • Connects to MySQL, PostgreSQL, and SQLite databases. • Spin up local databases directly through the UI, even if you don’t have one running. • Manage and query your data in a lightweight, intuitive interface. • Completely open source. Why we built it: We wanted to share the core Outerbase experience with the developer community as a free, open-source tool. It’s simple, fast, and removes the barriers…

    2024 · github.com · its alternatives →

  4. 4

    Free browser-based SQL editor powered by DuckDB. Query and visualize CSV, JSON, Parquet and Arrow files locally or from remote URLs. No installation required.

    2024 · sql-workbench.com · its alternatives →

  5. 5

    My co-worker and I were debugging a SQL issue; having not seen SQL in two years, I embarrassed myself by confusing union vs. join. After this episode, I tried refreshing my SQL memory, but there are few websites that animate SQL for you. Most of them just have a series of images to help you visualize. There are a few tools that are quite good and robust (especially for large/complex use cases) but require installation and are too complex for my simple purpose. So, just created a small tool to help visualise SQL. Most of the animations are just my understanding of how SQL works. Would…

    2022 · animatesql.com · its alternatives →

  6. 6

    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.

    2024 · timestored.com · its alternatives →

  7. 7

    The text-based SQL learning game for data scientists and marketers

    2023 · lost-at-sql.therobinlord.com · its alternatives →

  8. 8DU

    I built Duck-UI, a web-based SQL editor that runs DuckDB entirely in your browser via WebAssembly. No backend required. The Problem: Every time I needed to query csv, parquet, or even to play with SQL, I had to either: (a) spin up a Jupyter notebook (b) use the CLI (c) upload to a hosted service. Friction at every step (TOO MUCH to load a csv or even to test some sql (study)... The Solution: DuckDB's WASM runtime lets us run SQL analysis client-side. Load CSV/JSON/Parquet files from disk or URL, write SQL, get results instantly. Data stays on your machine. What It Does: SQL editor…

    2025 · demo.duckui.com · its alternatives →

  9. 9
    Arctype▲492

    Supercharged SQL client for developers and teams

    2021 · clickhouse.com · its alternatives →

  10. 10

    If you have a cloud-hosted database, read on: Visual DB was designed for you. Visual DB is the fastest way to create data entry forms for your database: Starting with an Excel spreadsheet, you can import your data into the database and create a great-looking form in under 10 minutes. Watch this video: https://youtu.be/6rVD5rmrjN8 Visual DB is a comprehensive SaaS frontend for your database. In addition to data entry forms, Visual DB also has a spreadsheet-like interface for inserting and updating data in your database. You can also build interactive reports using Visual DB.…

    2024 · visualdb.com · its alternatives →

  11. 11

    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,…

    2024 · github.com · its alternatives →

  12. 12
    RelateDB▲140

    Offline-first database schema designer in your browser

    Jan 2026 · relatedb.com · its alternatives →

  13. 13

    Hey Hacker News! I wanted to share the open source project I have been working on during the last year: SQLPage, a tool to build small web applications entirely in SQL. Building web applications with just SQL isn't as crazy as it seems. Most simple applications can be expressed declaratively as just data queries that fill pre-defined web components. I'd love to hear your feedback and thoughts on it. Would you potentially use it? How can it be improved? Website: https://sql.ophir.dev/ Github: https://github.com/lovasoa/SQLpage Example app:…

    2023 · sql.ophir.dev · its alternatives →

  14. 14

    Learn MySQL with 64 videos for application developers

    2023 · planetscale.com · its alternatives →

  15. 15

    Powerful online SQL sandbox

    2024 · sqlplayground.app · its alternatives →

  16. 16

    In-browser SQL Workbench for data querying & visualization

    2024 · sql-workbench.com · its alternatives →

  17. 17

    Lightspeed query generation for SQL and Pandas

    2023 · lifeontrack.co · its alternatives →

  18. 18NC

    Hey everyone! I built a tool to help you visually build SQL queries - if you write a lot of SQL at work (or help people write it), check it out! You can try it out without needing to sign up, or integrate with any databases. Would love all your thoughts! Link: https://craftsql.com/

    2022 · craftsql.com · its alternatives →

  19. 19

    Query C++ codebases using SQLite. Contribute to frabert/ClangQL development by creating an account on GitHub.

    2021 · github.com · its alternatives →

  20. 20

    GHCJS front-end for queryparser. Contribute to dlthomas/sql-viewer development by creating an account on GitHub.

    2018 · github.com · its alternatives →

  21. 21

    A lightweight MySQL client for macOS

    Apr 2026 · sqlgnome.com · its alternatives →

  22. 22SA

    Hi HN, I’m Tullie, founder of Shaped. Previously, I was a researcher at Meta AI, worked on ranking for Instagram Reels, and was a contributor to PyTorch Lightning. We built ShapedQL because we noticed that while retrieval (finding 1,000 items) has been commoditized by vector DBs, ranking (finding the best 10 items) is still an infrastructure problem. To build a decent for you feed or a RAG system with long-term memory, you usually have to put together a vector DB (Pinecone/Milvus), a feature store (Redis), an inference service, and thousands of lines of Python to handle business logic…

    Jan 2026 · playground.shaped.ai · its alternatives →

  23. 23

    I was always confused when trying to optimize a slow MySQL query as the output of the EXPLAIN command is so cryptic and totally useless. And there wasn't any tool that could help visualize what a query does - compared to PostgreSQL which has multiple... So, I started developing such a tool for MySQL. But boy, I didn't expect how complicated this is in reality. There were so many things hiding in tiny information pieces that I had to understand. But it also confirmed me in that a tool should try to understand the EXPLAIN output and not a human as it is too easy to oversee something. After…

    2024 · mysqlexplain.com · its alternatives →

  24. 24

    Hey there! I’ve been working on DB Pilot for the last couple of months, and I recently added an AI assistant powered by GPT 3.5 to help you write SQL queries tailored to your DB schema. Simply ask what data you are looking for - GPT will figure out which tables to use, how to join them, and then write a query for you. The AI assistant knows which tables and columns exist in your database, meaning it can write queries specific to your schema. Besides that, it doesn't have access to any actual data from your database though, meaning your data doesn't get exposed to OpenAI.

    2023 · dbpilot.io · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →