Text of duckdb.org › docs › current › guides › python › jupyter as Styx crawled it on Oct 15, 2026. The page may have changed since. Only its words are kept, without pictures or layout, and only the first part of a long page.

Open the live page

Jupyter Notebooks – DuckDB

Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import and Export Overview Data Sources CSV Files Overview Auto Detection Reading Faulty CSV Files Tips JSON Files Overview Creating JSON Loading JSON Writing JSON JSON Type JSON Functions Format Settings Installing and Loading SQL to / from JSON Caveats Multiple Files Overview Combining Schemas Parquet Files Overview Metadata Encryption Tips Partitioning Hive Partitioning Partitioned Writes Appender INSERT Statements Lakehouse Formats Client APIs Overview ADBC C Overview Startup Configuration Query Data Chunks Vectors Values Types Prepared Statements Appender Table Functions Replacement Scans API Reference C++ CLI Overview Arguments Dot Commands Output Formats Editing Friendly CLI Safe Mode Autocomplete Syntax Highlighting Known Issues Go Overview Connect Import Data Run Queries Handle Results Write User Defined Functions Profile and Monitor Troubleshoot Java (JDBC) Overview Connect Import Data Run Queries Handle Results Write User Defined Functions Profile and Monitor Deploy as Native Image Troubleshoot Node.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python Issues R Rust Overview Connect Import Data Run Queries Handle Results Write User Defined Functions Profile and Monitor Troubleshoot Wasm Overview Instantiate Import Data Run Queries Load Extensions Deploy Troubleshoot Tertiary Clients Overview Dart Julia PHP PHP (PDO) Swift SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE DESCRIBE DROP EXPORT and IMPORT DATABASE INSERT LOAD / INSTALL MERGE INTO PIVOT Profiling PREPARE, EXECUTE, and DEALLOCATE SELECT SET / RESET SET VARIABLE SHOW and SHOW DATABASES SUMMARIZE Transaction Management UNPIVOT UPDATE USE VACUUM Query Syntax SELECT FROM and JOIN WHERE GROUP BY GROUPING SETS HAVING ORDER BY LIMIT and OFFSET SAMPLE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Geometry Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Variant Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions Date Format Functions Date Functions Date Part Functions Enum Functions Geometry Functions Interval Functions Lambda Functions List Functions Map Functions Nested Functions Numeric Functions Pattern Matching Regular Expressions Struct Functions Text Functions Time Functions Timestamp Functions Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks PEG Parser Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versioning of Extensions Troubleshooting of Extensions Core Extensions Overview AutoComplete Avro AWS Azure Delta DuckLake Encodings Excel Full Text Search httpfs (HTTP and S3) Overview HTTP(S) Support Hugging Face S3 API Support Legacy Authentication Scheme for S3 API Iceberg Overview Writing to Iceberg Iceberg Functions Iceberg Options Iceberg REST Catalogs Troubleshooting ICU inet jemalloc Lance MotherDuck MySQL ODBC Overview ODBC Functions Quack PostgreSQL Overview Secrets Connection Pool Functions Spatial Overview Function Reference R-Tree Indexes GDAL Integration SQLite TPC-DS TPC-H UI Unity Catalog Vortex VSS Quack Remote Protocol Overview Reference Security Setup Overview Reverse Proxy Deployment Using from Wasm Troubleshooting Guides Overview Data Viewers Tableau CLI Charting with YouPlot Database Integration Overview MySQL Import PostgreSQL Import SQLite Import Amazon RDS with IAM Authentication File Formats Overview CSV Import CSV Export Directly Reading Files Directly Reading DuckDB Databases Excel Import Excel Export JSON Import JSON Export Parquet Import Parquet Export Querying Parquet Files File Access with the file: Protocol Meta Queries Describe Table EXPLAIN: Inspect Query Plans EXPLAIN ANALYZE: Profile Queries List Tables Summarize DuckDB Environment Network and Cloud Storage Overview HTTP Parquet Import HTTP CSV Import S3 Parquet Import S3 Parquet Export S3 Iceberg Import S3 Express One GCS Import Cloudflare R2 Import DuckDB over HTTPS / S3 Fastly Object Storage Import SeaweedFS Import Tigris Import ODBC ODBC Guide Performance Overview Environment Import Schema Indexing Join Operations File Formats How to Tune Workloads My Workload Is Slow Out-of-Memory Issues Benchmarks Working with Huge Databases Python Installation Executing SQL Jupyter Notebooks marimo Notebooks SQL on Pandas Import from Pandas Export to Pandas Import from Numpy Export to Numpy SQL on Arrow Import from Arrow Export to Arrow Relational API on Pandas Multiple Python Threads Integration with Ibis Integration with Polars Integration with PyTorch Using fsspec Filesystems SQL Editors DBeaver SQL IDE SQL Features AsOf Join Full-Text Search Graph Queries query and query_table Functions Merge Statement for SCD Type 2 Timestamp Issues Snippets Creating Synthetic Data Dutch Railway Datasets Sharing Macros Analyzing a Git Repository Importing Duckbox Tables Copying an In-Memory Database to a File Calculating a Database Checksum Troubleshooting Command Line Crashes Out of Memory Errors Glossary of Terms Browsing Offline Operations Manual Overview DuckDB's Footprint Files Created by DuckDB Gitignore for DuckDB Reclaiming Space Installing DuckDB Install Script Logging Overview User Agents Securing DuckDB Overview Embedding DuckDB Securing Extensions Non-Deterministic Behavior Limits DuckDB Docker Container Development DuckDB Repositories Release Cycle Metrics Profiling Building DuckDB Overview Build Configuration Building Extensions Android Linux macOS Raspberry Pi Windows Python R Troubleshooting Unofficial and Unsupported Platforms Benchmark Suite Testing Overview sqllogictest Introduction Writing Tests Unit Tester Configuration Debugging Result Verification Persistent Testing Loops Multiple Connections Catch Internals Overview Storage Versions and Format Execution Format Jemalloc Pivot Sitemap Live Demo Documentation / Guides / Python Jupyter Notebooks DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration if desired.

However, additional libraries can be used to simplify SQL query development. This guide will describe how to utilize those additional libraries. See other guides in the Python section for how to use DuckDB and Python together. In this example, we use the JupySQL package. This example workflow is also available as a Google Colab notebook . Library Installation Four additional libraries improve the DuckDB experience in Jupyter notebooks. jupysql : Convert a Jupyter code cell into a SQL cell Pandas : Clean table visualizations and compatibility with other analysis matplotlib : Plotting with Python duckdb-engine (DuckDB SQLAlchemy driver) : Used by SQLAlchemy to connect to DuckDB (optional) Run these pip install commands from the command line if Jupyter Notebook is not yet installed.

Otherwise, see Google Colab link above for an in-notebook example: pip install duckdb Install Jupyter Notebook: pip install notebook Or JupyterLab: pip install jupyterlab Install supporting libraries: pip install jupysql pandas matplotlib duck

The rest of this page is on the live site.