Skip to main content

Ctrl+K

Host Voilà and Streamlit apps for free with Ploomber Cloud!

Quick Start

User Guide

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

JupyterLab integration

Sharing notebooks
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

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

Search

Ctrl+K

By Ploomber

© Copyright 2023.