Operator surface
Pick the task. Get the right CLI.
Use task lanes to choose a tool, verify it safely, and understand the first agent-safe loop before you commit to it.
Task lane
Pick a lane, write the task in plain language, then work from the recommended CLI and its first safe loop.
Recommended CLI
Data & DBpgcli is a strong fit for data & db. pgcli responds locally before you point it at a database.
Best for
postgres shell, autocomplete, and readable results from the terminal.
First move
$ pgcli --versionTrust signal
798 Homebrew installs (30d)
Safe first loop
Why this pick
Supporting tools
6 support tools
usql
universal sql shell, multiple databases, and db scripts from the terminal.
You need databases in both local dev and CI.
Universal SQL shell, multiple databases, and db scripts from the terminal.
usql
sqlite-utils
sqlite automation, csv/json imports, and data transforms from the terminal.
You want databases you can script with structured output.
SQLite automation, csv/json imports, and data transforms from the terminal.
sqlite-utils
duckdb
local analytics, sql, and csv/parquet queries from the terminal.
You want data processing that runs entirely on your machine.
Local analytics, sql, and csv/parquet queries from the terminal.
DuckDB CLI
mycli
mysql shell, autocomplete, and readable results from the terminal.
You work with databases and want a fast terminal interface.
MySQL shell, autocomplete, and readable results from the terminal.
mycli
litecli
sqlite shell, autocomplete, and readable tables from the terminal.
You work with databases and want a fast terminal interface.
SQLite shell, autocomplete, and readable tables from the terminal.
litecli
prisma
schema design, migrations, and type-safe db workflows from the terminal.
You need databases in both local dev and CI.
Schema design, migrations, and type-safe db workflows from the terminal.
Prisma CLI
Repository families
dbcli
small-team / 3 matched
BurntSushi
individual / 1 matched
Simon Willison
individual / 1 matched
amacneil
individual / 1 matched
Drizzle Team
small-team / 1 matched
ducaale
individual / 1 matched
Lane catalog
11 CLIs in Database
pgcli
postgres shell, autocomplete, and readable results from the terminal.
You work with databases and want a fast terminal interface.
Postgres shell, autocomplete, and readable results from the terminal.
pgcli
usql
universal sql shell, multiple databases, and db scripts from the terminal.
You need databases in both local dev and CI.
Universal SQL shell, multiple databases, and db scripts from the terminal.
usql
sqlite-utils
sqlite automation, csv/json imports, and data transforms from the terminal.
You want databases you can script with structured output.
SQLite automation, csv/json imports, and data transforms from the terminal.
sqlite-utils
mycli
mysql shell, autocomplete, and readable results from the terminal.
You work with databases and want a fast terminal interface.
MySQL shell, autocomplete, and readable results from the terminal.
mycli
litecli
sqlite shell, autocomplete, and readable tables from the terminal.
You work with databases and want a fast terminal interface.
SQLite shell, autocomplete, and readable tables from the terminal.
litecli
prisma
schema design, migrations, and type-safe db workflows from the terminal.
You need databases in both local dev and CI.
Schema design, migrations, and type-safe db workflows from the terminal.
Prisma CLI
drizzle-kit
migrations, schema diffs, and typescript db tooling from the terminal.
You need databases in both local dev and CI.
Migrations, schema diffs, and typescript db tooling from the terminal.
drizzle-kit
supabase
local backend, type generation, and db workflows from the terminal.
You're on Supabase and want the official terminal experience.
Local backend, type generation, and db workflows from the terminal.
Supabase CLI
neonctl
serverless postgres, projects, and branches from the terminal.
You want databases you can script with structured output.
Serverless Postgres, projects, and branches from the terminal.
neonctl
pscale
mysql branches, deploy requests, and database workflows from the terminal.
You want databases you can script with structured output.
MySQL branches, deploy requests, and database workflows from the terminal.
PlanetScale CLI
turso
libsql, edge databases, and db management from the terminal.
You want databases you can script with structured output.
libSQL, edge databases, and db management from the terminal.
Turso CLI