Skip to main content
Ctrl+K
Host Voilà and Streamlit apps for free with Ploomber Cloud!
Logo image
  • 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

Index

B | H | R | S

B

  • boxplot() (in module sql.plot)

H

  • histogram() (in module sql.plot)

R

  • run_statements() (in module sql.run.run)

S

  • SQLStore (class in sql.store)

By Ploomber

© Copyright 2023.