DuckDB

Category: SQL Status: base

Connects to a DuckDB analytical database file. DuckDB is an in-process OLAP SQL engine — no server required.

Connection Settings

Field	Default	Description
path	(empty)	Absolute path to the .duckdb file
authentication	no_auth	no_auth or user_password

Authentication

No authentication by default. Use user_password mode if the DuckDB file was created with access control.

Supported Actions

• execute — run SQL queries (including reading Parquet, CSV, JSON directly)
• stream_table — stream query results

Required Setup

Requires the duckdb Python package:

pip install duckdb

External Links

• https://duckdb.org/docs/