Intent-based stack
CLI stack for inspect a database.
pgcli is a strong fit for data & db. pgcli responds locally and is ready for the first real command. Use this page as a permalink for humans, agents, and runbooks.
pgcli fits data & db well, especially for postgres shell, autocomplete, and readable results from the terminal.
823 homebrew installs (30d).
Verify with `pgcli --version` first.
Install
pipx install pgcliVerify
pgcli --versionRecommended stack
Alternatives
usql
Choose this if you care more about universal sql shell, multiple databases, and db scripts from the terminal.
sqlite-utils
Choose this if structured output matters more.
DuckDB CLI
Choose this if keeping more of the workflow local matters.
mycli
Choose this if you care more about mysql shell, autocomplete, and readable results from the terminal.
litecli
Choose this for a lower-risk place to start.
dbmate
Choose this if you care more about sql migrations, simple db workflows, and multiple databases from the terminal.