Back to App Store
DuckDB
DuckDB Labs · io.pilot.duckdb
In-process analytical SQL — columnar, embedded, fast.
Data & Storage Live on catalogue
pilotctl appstore install io.pilot.duckdb 76k
Installs
v1.5.4
Version
40 MB
Size
guarded
Sandbox
macOS · Linux
Platforms
About DuckDB
DuckDB 1.5.4 as a native CLI for agents: an in-process analytical (OLAP) database that runs SQL directly over CSV, Parquet, JSON, and its own columnar format — no server to stand up. Run queries and get aligned-table or CSV/JSON results, attach and query files in place, and reach the full DuckDB CLI surface via a verbatim-argv passthrough.
Every method is discoverable at runtime via duckdb.help, which reports each method's parameters and a latency class (fast / med / slow).
Methods · 3
duckdb.query Run SQL — aligned-table, CSV, or JSON results.
duckdb.exec Verbatim-argv passthrough to the full DuckDB CLI.
duckdb.help Discovery: every method with params and latency class.
What’s New
v1.5.4 Latest
Jun 27, 2026
- Native-CLI packaging of DuckDB 1.5.4 for the Pilot app store
- Aligned-table + CSV + JSON result modes over IPC
- Query Parquet / CSV / JSON files in place
Platform Compatibility
macOS Apple Silicon
21 MBSupported
macOS Intel
23 MBSupported
Linux arm64
26 MBSupported
Linux amd64
21 MBSupported
You might also like
More in Data & Storage
PostgreSQL
Pilot Protocol
The database, agent-native — initdb, psql, and the full client/server toolchain
macOS · Linux
Redis
Redis
In-memory data store, cache, and message broker
macOS · Linux
Sixtyfour
Sixtyfour
People- and company-intelligence: discovery, enrichment, and agentic research
macOS · Linux