ipython-sql
RDBMS access via IPython
Decision gist · record as of 2026-08-14
Yes, if you work regularly in Jupyter or IPython and need to query databases interactively. The low install friction and permissive license make it a low-risk addition. However, the dormant maintenance status (last release over a year ago, Alpha classification) means you should verify compatibility with your Python and IPython versions before relying on it for production workflows. No known security vulnerabilities.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires IPython or Jupyter to be installed and running; database driver for your target database (e.g., psycopg2 for PostgreSQL) must be installed separately.
- Low install friction with a pure-Python wheel and six runtime dependencies.
- Maintenance is dormant—last release was 2023-02-27, over a year ago, though the repository remains active with 1797 stars and no archived status.
License · maintenance · safety
MIT (permissive) — MIT license is permissive; you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
last release 2023-02-27 (1264 days) · last repo commit 2024-07-12 · 1,797 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 387,691 downloads/mo, #7,043 on PyPI
Alternatives
Verify before relying
pip install ipython-sql
In IPython or Jupyter:
%load_ext sql
%%sql postgresql://user:password@localhost/dbname
SELECT * FROM table LIMIT 5;- Whether the package works with modern Python versions (3.9+) given its Alpha status and dormant maintenance.
- Current compatibility with recent IPython and SQLAlchemy versions.
- Whether all six runtime dependencies are actively maintained and free of vulnerabilities.
What it is and what it does
ipython-sql is a magic command extension for IPython and Jupyter notebooks that lets you write and execute SQL queries directly in notebook cells. It connects to any database supported by SQLAlchemy—PostgreSQL, MySQL, SQLite, Oracle, and others—using standard SQLAlchemy connection strings. Once connected, you can issue queries with %sql (single-line) or %%sql (multi-line) magic, and results are returned as objects you can iterate over, access by column name, or convert to Pandas DataFrames.
The package handles multiple simultaneous database connections, supports variable substitution and bind parameters, and lets you capture query results into Python variables for further analysis. It's designed for exploratory data work and ad-hoc querying in notebooks, where switching between SQL and Python would otherwise require separate tools or boilerplate connection code.
Use it for
- Exploratory data analysis in Jupyter: query a database and immediately plot or analyze results in the same notebook.
- Prototyping SQL queries interactively without leaving the notebook environment.
- Teaching SQL or databases in a classroom setting where students can write and test queries live.
- Combining SQL queries with Python data processing: fetch data, transform it, and visualize it in one workflow.
- Quick ad-hoc reporting from a database without setting up a separate reporting tool.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you work regularly in Jupyter or IPython and need to query databases interactively.
The low install friction and permissive license make it a low-risk addition. However, the dormant maintenance status (last release over a year ago, Alpha classification) means you should verify compatibility with your Python and IPython versions before relying on it for production workflows. No known security vulnerabilities.
Install
ipython-sql on PyPI
Before you install
Low install friction with a pure-Python wheel and six runtime dependencies. Maintenance is dormant—last release was 2023-02-27, over a year ago, though the repository remains active with 1797 stars and no archived status.
Requires IPython or Jupyter to be installed and running; database driver for your target database (e.g., psycopg2 for PostgreSQL) must be installed separately.
License in practice
MIT license is permissive; you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
Quickstart
pip install ipython-sql
In IPython or Jupyter:
%load_ext sql
%%sql postgresql://user:password@localhost/dbname
SELECT * FROM table LIMIT 5;Verify before relying
- Whether the package works with modern Python versions (3.9+) given its Alpha status and dormant maintenance.
- Current compatibility with recent IPython and SQLAlchemy versions.
- Whether all six runtime dependencies are actively maintained and free of vulnerabilities.
Package facts
| License | MIT permissive |
| Python support | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 6 packagesprettytableipythonsqlalchemysqlparsesixipython-genutils |
| Maintenance | Dormant 1,264 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 387,691 / month, #7,043 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 3 - AlphaEnvironment :: ConsoleLicense :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Topic :: DatabaseTopic :: Database :: Front-Ends |
Evidence: ipython_sql-0.5.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “ipython database query”
- ipython-sqlAdds SQL magic commands to IPython and Jupyter notebooks, letting you…
- jupysqlAdds SQL execution to Jupyter and IPython notebooks via `%sql` and…
- django-read-onlyPrevents Django database write operations by intercepting and…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also jupysql · records · fastlite · pangres · pandasql · sqlalchemy-jdbcapi · databases · mssql · cloud-sql-python-connector · dsnparse