⌘K
ctrl+k
2.0
LTS
2.0
LTS
1.5
1.4
LTS
1.3
1.2
1.1
1.0
0.10
Search Shortcut
cmd
+
k
|
ctrl
+
k
Search docs
⌘K
ctrl+k
Get started
Overview
Installation
Quickstart
How-to Guides
Topics
Import & Export
Import & 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
Parquet Files
Overview
Metadata
Encryption
Tips
Multiple Files
Overview
Combining Schemas
Partitioning
Hive Partitioning
Partitioned Writes
Lakehouse
Overview
IO
Appender
INSERT Statements
SQL
SQL
Introduction
Friendly SQL
Statements
Overview
ANALYZE
ALTER DATABASE
ALTER TABLE
ALTER VIEW
ATTACH and DETACH
CALL
CHECKPOINT
COMMENT ON
CONNECT and DISCONNECT
COPY
CREATE INDEX
CREATE MACRO
CREATE SCHEMA
CREATE SECRET
CREATE SEQUENCE
CREATE TABLE
CREATE VIEW
CREATE TRIGGER
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
UPDATE EXTENSIONS
USE
VACUUM
Query Syntax
SELECT
FROM and JOIN
WHERE
GROUP BY
GROUPING SETS
HAVING
ORDER BY
LIMIT and OFFSET
SAMPLE
Samples
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
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
Variant Functions
Window Functions
Expressions
Overview
CASE Expression
Casting
Collations
Comparisons
IN Operator
Logical Operators
Star Expression
Subqueries
TRY
Meta Queries
Information Schema
Metadata Functions
Constraints
Indexes
DuckDB's SQL Dialect
Overview
Indexing
Keywords and Identifiers
Order Preservation
PostgreSQL Compatibility
SQL Quirks
PEG Parser
Client APIs
Client APIs
Overview
Connecting to DuckDB
Python
Overview
Data Ingestion
Appender
Conversion between DuckDB and Python
DB API
Relational API
Function API
Types API
Expression API
Spark API
API Reference
Known Python Issues
Migrating to 2.0
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
CLI
Overview
Arguments
Dot Commands
Output Formats
Agent Mode
Editing
Friendly CLI
Safe Mode
Autocomplete
Syntax Highlighting
Known Issues
Node.js (Neo)
Overview
Java (JDBC)
Overview
Connect
Import Data
Run Queries
Handle Results
Write User Defined Functions
Profile and Monitor
Deploy as Native Image
Troubleshoot
R
Go
Overview
Connect
Import Data
Run Queries
Handle Results
Write User Defined Functions
Profile and Monitor
Troubleshoot
Rust
Overview
Connect
Import Data
Run Queries
Handle Results
Write User Defined Functions
Profile and Monitor
Troubleshoot
C/C++
Overview
Startup
Configuration
Query
Data Chunks
Vectors
Values
Types
Prepared Statements
Appender
Table Functions
Replacement Scans
API Reference
C API v2
Overview
API Reference
C++
Wasm
Overview
Instantiate
Import Data
Run Queries
Load Extensions
Deploy
Troubleshoot
ODBC/ADBC
Overview
Linux Setup
Windows Setup
macOS Setup
Configuration
ADBC
Other Clients
Overview
Julia
PHP
PHP (PDO)
Swift
Extensions
Extensions
Using Extensions
Overview
Installing Extensions
Advanced Installation Methods
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
S3 API Support
S3 and AWS Authentication
Hugging Face
Legacy Authentication Scheme for S3 API
Iceberg
ICU
inet
Lance
Legacy Parser
MotherDuck
MySQL
ODBC
Quack
PostgreSQL
Sirius
Spatial
SQLite
SQLSmith
TPC-DS
TPC-H
UI
Unity Catalog
Vortex
VSS
Community Extensions
Building Extensions
Distributing Extensions
Extension Repositories
Server & Remote
Server & Remote
Overview
Setup
Overview
Reverse Proxy
Deployment
Using from Wasm
Security
Reference
Troubleshooting
Performance & Operations
Performance & Operations
Overview
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
Configuration
Overview
Secrets
Pragmas
Concurrency
Non-Deterministic Behavior
Security
Overview
Embedding DuckDB
Securing Extensions
Deployment
Installing DuckDB
Install Script
Requirements
Docker
User Agents
Limits
Migrating to DuckDB 2.0
Backup Extension Repositories
Storage Footprint
Files Created by DuckDB
Gitignore for DuckDB
Reclaiming Space
Logging
Development & Internals
Development & Internals
Overview
Building DuckDB
Overview
Build Configuration
Building Extensions
Statically Linking Extensions
Platforms
Android
OpenHarmony
Linux
macOS
Raspberry Pi
Windows
Python
R
Unofficial and Unsupported Platforms
Troubleshooting
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
Internal Errors
Profiling & Benchmarking
Profiling
Metrics
Benchmark Suite
Project
Release Cycle
DuckDB Repositories
Troubleshooting
Docs
Copy Markdown
Database Integration
Pages in This Section
View Markdown
Edit on GitHub
Report an issue
© 2026 DuckDB Foundation, Amsterdam NL
DuckDB Home
Code of Conduct
Trademark Use
Blog
