HomeServices › DuckDB

DuckDB on a Mac

In-process OLAP database — the SQLite of analytics · Analytics Databases

DuckDB is an embedded analytical database: a single-file, in-process engine (like SQLite, but columnar and vectorized) that queries CSV/Parquet/JSON files, pandas and Polars DataFrames, and even remote S3 data with full SQL — no server to run or administer. brew install duckdb, then duckdb mydb.duckdb for a shell, or duckdb -ui for the bundled local web UI (:4213). The default choice for local analytics before workloads justify a ClickHouse server.

Run DuckDB with FrontierStack

FrontierStack lists DuckDB in its Analytics Databases catalog. Install or connect it from one place, then monitor its status, ports and certificate, secure it with the firewall and Malware Audit, and back it up.

Run it all from one Mac app.

FrontierStack installs, monitors and secures the whole stack — locally and across your fleet — from a single native macOS app.

Download FrontierStack

Related in Analytics Databases