nowfound

Dev tools · alternatives · 2026

24 alternatives to Simple interactive SQL exploration with IPython/Pandas

Interactive SQL database exploration in Python. Contribute to boydgreenfield/query development by creating an account on GitHub.

Query is a Python development tool that enables interactive SQL database exploration within IPython and Pandas environments. It allows developers to write and execute SQL queries directly in Python notebooks while… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Simple interactive SQL exploration with IPython/Pandas launched in 2014; newer entries below may have overtaken it.

  1. 1

    🪄 Inline SQL in any Python program. Contribute to ekzhang/inline-sql development by creating an account on GitHub.

    2022 · github.com · its alternatives →

  2. 2QW
  3. 3

    I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

    2023 · github.com · its alternatives →

  4. 4

    SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…

    2022 · github.com · its alternatives →

  5. 5

    Lightspeed query generation for SQL and Pandas

    2023 · lifeontrack.co · its alternatives →

  6. 6

    Paste in my prompt to Claude Code with an embedded API key for accessing my public readonly SQL+vector database, and you have a state-of-the-art research tool over Hacker News, arXiv, LessWrong, and dozens of other high-quality public commons sites. Claude whips up the monster SQL queries that safely run on my machine, to answer your most nuanced questions. There's also an Alerts functionality, where you can just ask Claude to submit a SQL query as an alert, and you'll be emailed when the ultra nuanced criteria is met (and the output changes). Like I want to know when somebody posts about…

    Dec 2025 · exopriors.com · its alternatives →

  7. 7

    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 →

  8. 8

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

    2017 · github.com · its alternatives →

  9. 9

    Data notebook built for speed, visibility, and collaboration

    2023 · its alternatives →

  10. 10

    Contribute to akdor1154/python-csql development by creating an account on GitHub.

    2020 · github.com · its alternatives →

  11. 11DS

    2021 · django-sql-dashboard.datasette.io · its alternatives →

  12. 12

    PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!

    2024 · github.com · its alternatives →

  13. 13

    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 →

  14. 14HA

    Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…

    2024 · hashquery.dev · its alternatives →

  15. 15

    PugSQL is a Python library for interacting with your database the way the gods intended.

    2019 · pugsql.org · its alternatives →

  16. 16

    Generate arduous database queries in a snap

    2023 · its alternatives →

  17. 17

    Turn plain language into powerful database queries

    2025 · text2query.com · its alternatives →

  18. 18

    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 →

  19. 19
    Cogram▲132

    Query databases in plain English

    2022 · cogram.com · its alternatives →

  20. 20
    SQLPilot▲149

    AI First SQL Editor

    2024 · its alternatives →

  21. 21
    JupySQL▲115

    JupySQL is a SQL client for Jupyter

    2023 · its alternatives →

  22. 22
    PyQL▲15

    A tool to run SQL queries on Python files built using GitQL

    2024 · github.com · its alternatives →

  23. 23

    SQL micro-dialect implementation for querying JSON objects. Written purely in Scala. - mmalek06/JsonSql

    2020 · github.com · its alternatives →

  24. 24

    Last year, I wanted to learn a bit about how easy it would be to deploy a python app via web assembly to the browser and decided to make a wrapper around the amazing sqlglot by Toby Mao and the rest of the team. The tool lets you paste in Sql queries and translate them between the available sql dialects in sqlglot. It also gives you parse diagnostics and the ability to easily share queries via storing all the state in the url. The stack that was used is typescript for the UI and pyodide to integrate with Sqlglot, which does the heavy lifting. It's more of a toy app but I've found some use…

    2025 · sqlscope.netlify.app · 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 →