Open CLI

duckdb

scriptabledata
$ brew install duckdb
Summary

Local analytics, sql, and csv/parquet queries from the terminal.

  • duckdb fits data & db well, especially for local analytics, sql, and csv/parquet queries from the terminal.
  • 4,627 homebrew installs (30d).
  • Good for scripts and agents.
  • Good fit for coding-agent workflows and repeatable scripts.
  • Structured output is available for automation and parsing.
database-duckdb-SKILL.md

Duckdb guide

Local analytics, sql, and csv/parquet queries from the terminal. Built by DuckDB. Supports structured output — good for scripts and agents. Runs entirely on your machine.

Open CLI packages the install path, verify step, and safe-start workflow so this tool can move from “interesting CLI” to something you can actually use. It also integrates with skills.sh so each CLI comes with the right companion skills, not just a binary and a docs link.

When to apply

  • local analytics, sql, and csv/parquet queries from the terminal.
  • You want data processing that runs entirely on your machine.
  • You need local analytics.
  • You need sql.
  • You need csv/parquet queries.

Quick reference

Installbrew install duckdb
Verifyduckdb --version
First real commandduckdb ':memory:' 'select 42'

Open CLI × skills.sh

Open CLI integrates duckdb with the right skills.sh companions so you get the tool and the workflow together.

Data Analysis

Recommended pairing

Open CLI recommends this skills.sh skill because it fits data workflows. Turn query output and flat files into usable insights faster.

View on skills.sh
$ npx skills add https://github.com/supercent-io/skills-template --skill data-analysis
Starter prompt

Use duckdb together with the Data Analysis skills.sh skill. Start with safe inspection commands, summarize what you find, and ask before any step with side effects.

Also useful from skills.sh
Codebase Searchskills.shWorkflow Automationskills.sh

Why this tool

  • duckdb fits data & db well, especially for local analytics, sql, and csv/parquet queries from the terminal.
  • 4,627 homebrew installs (30d).
  • Good for scripts and agents.

Watch-outs

  • Run the verify command first.

Example workflow

1. duckdb ':memory:' 'select 42'

Safe start

Step 1

Install duckdb.

Step 2

Run `duckdb --version` first.

Step 3

Start with `duckdb ':memory:' 'select 42'`.

Step 4

Install a CLI that matches your database engine.

Alternatives worth considering

jq

JSON processing, apis, and agent output parsing from the terminal.

http

API testing, readable http, and debugging endpoints from the terminal.

yq

YAML processing, config edits, and kubernetes files from the terminal.