jupysql0.11.1
jupysql0.11.1
Published
Better SQL in Jupyter
pip install jupysql
Package Downloads
Authors
Requires Python
Dependencies
- prettytable
>=3.12.0 - ipython
<=8.12.0; python_version <= "3.8" - sqlalchemy
- sqlparse
- ipython-genutils
>=0.1.0 - jinja2
- sqlglot
>=11.3.7 - importlib-metadata
; python_version < "3.8" - jupysql-plugin
>=0.4.2 - ploomber-core
>=0.2.7 - flake8
; extra == "dev" - pytest
; extra == "dev" - pandas
<2.2.0; extra == "dev" - polars
==0.17.2; extra == "dev" - pyarrow
; extra == "dev" - invoke
; extra == "dev" - pkgmt
; extra == "dev" - twine
; extra == "dev" - duckdb
<1.1.0; extra == "dev" - duckdb-engine
; extra == "dev" - pyodbc
; extra == "dev" - matplotlib
==3.7.2; extra == "dev" - black
; extra == "dev" - ipywidgets
; extra == "dev" - js2py
; extra == "dev" - psutil
; extra == "dev" - jupyter-server
; extra == "dev" - flake8
; extra == "integration" - pytest
; extra == "integration" - pandas
<2.2.0; extra == "integration" - polars
==0.17.2; extra == "integration" - pyarrow
; extra == "integration" - invoke
; extra == "integration" - pkgmt
; extra == "integration" - twine
; extra == "integration" - duckdb
<1.1.0; extra == "integration" - duckdb-engine
; extra == "integration" - pyodbc
; extra == "integration" - matplotlib
==3.7.2; extra == "integration" - black
; extra == "integration" - ipywidgets
; extra == "integration" - js2py
; extra == "integration" - psutil
; extra == "integration" - jupyter-server
; extra == "integration" - dockerctx
; extra == "integration" - pyarrow
; extra == "integration" - psycopg2-binary
; extra == "integration" - pymysql
; extra == "integration" - pgspecial
==2.0.1; extra == "integration" - pyodbc
; extra == "integration" - snowflake-sqlalchemy
; extra == "integration" - oracledb
; extra == "integration" - sqlalchemy-pytds
; extra == "integration" - python-tds
; extra == "integration" - redshift-connector
; extra == "integration" - sqlalchemy-redshift
; extra == "integration" - clickhouse-sqlalchemy
; extra == "integration" - pyspark
; extra == "integration" - grpcio-status
; extra == "integration"
JupySQL
Join our community | Newsletter | Contact us | Docs | Blog | Website | YouTube
[!TIP] Deploy Streamlit and Dash apps for free on Ploomber Cloud!
Run SQL in Jupyter/IPython via a %sql and %%sql magics.
Features
- Pandas integration
- SQL composition (no more hard-to-debug CTEs!)
- Plot massive datasets without blowing up memory
- DuckDB integration
Installation
pip install jupysql
or:
conda install jupysql -c conda-forge
Documentation
Click here to see the documentation.
Credits
This project is a fork of ipython-sql; the objective is to turn this project into a full-featured SQL client for Jupyter. We're looking for feedback and taking feature requests, so please join our community and enter the #jupysql channel.