# OpenCLI Agent Pack: DuckDB CLI

Use this when an AI agent needs to work with `duckdb`.

## What this CLI is for
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.

Best for: local analytics, sql, and csv/parquet queries from the terminal.

## Agent readiness
Great for agents (85/100)
- Structured output is available for parsing.
- Supports non-interactive/scripted use.
- Works well in CI or repeatable automation.
- Can run locally with less credential exposure.

## Install
```sh
brew install duckdb
```

## Verify before real work
```sh
duckdb -c "select 1"
```
Expected signal: DuckDB executes a local SQL query.

## Safe starting commands
```sh
duckdb -c "select 1"
```

```sh
duckdb ':memory:' 'select 42'
```

## Guardrails for agents
- Start read-only, then ask before mutations.

## Suggested agent instruction
You may use DuckDB CLI (`duckdb`) for local analytics, sql, and csv/parquet queries from the terminal.. First install it if missing, then run the verify command. Start with read-only or inspection commands. Summarize what you found before changing anything. Ask for confirmation before commands that mutate remote state, spend money, deploy, delete data, merge code, or expose secrets.

Source: OpenCLI