Skip to main content

Ctrl+K

Quick Start

User Guide

Introduction
Connecting to a database
Plotting
Organizing Large Queries
List tables and columns
ggplot
Parameterizing SQL queries
Parameterizing arguments
Using a connection file
Table Explorer
Data profiling

JupyterLab integration

SQL syntax highlighting
SQL formatting
SQL keywords autocompletion

Integrations

DuckDB
Pandas
Polars
Snowflake
Redshift
PostgreSQL
MySQL
Microsoft SQL Server
MariaDB
Clickhouse
Mindsdb
QuestDB
Oracle Database
Trino
DuckDB (Native)
Compatibility
chDB
Spark

API Reference

%sql/%%sql
%sqlplot
%sqlcmd snippets
%sql Configuration
Python API
%sqlcmd tables/%sqlcmd columns
%sqlcmd profile
%sqlcmd connect
Plotting (legacy API)

How-To

How-To
Install PostgreSQL client
Run SQL on JSON files
Export to CSV
Interactive ggplot
Benchmarking runtime
Use JupySQL in .py scripts
Interactive SQL Queries
Testing with sqlcmd
Install database drivers

Tutorials

Analyzing Github Data with JupySQL + DuckDB
Schedule ETLs with Jupysql and GitHub actions
Loading and Querying Excel Files
Product Analytics
DuckDB (native vs SQLAlchemy)

Community

JupySQL vs ipython-sql
FAQ
Code of Conduct
Support
Other projects
Credits
Developer guide

Repository
Open issue

.md

Support

Support#

For support, feature requests, and product updates: join our community or follow us on Twitter/LinkedIn.

previous

Code of Conduct

next

Other projects

By Ploomber

© Copyright 2023.