DuckDB
Overview
DuckDB is an in-process analytical database designed for fast OLAP queries on local data. It runs entirely in-process with no server to manage, supports standard SQL, and can read CSV, Parquet, JSON, and Arrow files directly. DuckDB is widely used for data exploration, ETL pipelines, and embedded analytics.
Driver
- Crate:
duckdb - Version:
1.10502
Connection fields
| Field | Description |
|---|---|
| File | Absolute path to the .duckdb database file. Leave empty for an in-memory database. |
| Options | Additional connection parameters as key1=val1&key2=val2. |
Schema browser
Once connected, Arris fetches the schema tree from the DuckDB catalog. The tree displays schemas at the top level, each containing its own object groups.
The schema tree displays the following object types, grouped by category:
- Tables — regular tables and foreign tables
- Views — views and materialized views
- Routines — functions and procedures
- Sequences — auto-increment sequences
- Indexes — ART and other index types
Double-click any table, view, materialized view, or foreign table to open it in a new tab with browse mode.
Supported SQL commands
| Command | Notes |
|---|---|
SELECT | Query data with WHERE filters, JOINs, aggregates, and window functions. |
INSERT | Insert single or multiple rows. |
UPDATE | Update existing rows. |
DELETE | Delete rows. |
CREATE / DROP | Create and drop tables, views, and other schema objects. |