dbcli/pgcli
Postgres CLI with autocompletion and syntax highlighting observed · 2026-08-28
Health v2 · maintenance only
77/100
- Activity 99
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 4343
- days_rel: n/a
- days_push: 7
- n_releases_24m: 0
Adoption not part of the score
13366 stars · 605 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
pgcli is a command-line REPL client for PostgreSQL that provides context-sensitive auto-completion and syntax highlighting as you type SQL queries. It is a modern, friendlier alternative to psql, supporting backslash meta-commands, query history, named queries, and SSH tunneling.
Use cases
- query postgres from the terminal with autocomplete
- a better psql alternative with syntax highlighting
- interactive SQL REPL for postgres
- explore database schema from the command line
- run postgres queries with smart completion
- connect to postgres over an SSH tunnel from CLI
When to choose
- you work with PostgreSQL daily and want a smarter terminal client than psql
- you want context-aware completion of tables, columns, and keywords while writing SQL
- you want a lightweight CLI instead of a GUI database tool
When to avoid
- you need a MySQL or SQLite client (use mycli or litecli instead)
- you require a graphical interface for browsing and editing data
- you need advanced psql features or exact psql script compatibility
Facets
cli-tool · maturity active
database database-driver cli databases developer-tools windows cli python postgres psql repl autocompletion syntax-highlighting sql-client command-line linux macos
6 sources
- readme: https://github.com/dbcli/pgcli · fetched 2026-08-28 · 843a2baea31f
- homepage: http://pgcli.com · fetched 2026-08-29 · 69002c40b004
- site_page: https://www.pgcli.com/install · fetched 2026-08-29 · d89a4284c9da
- site_page: https://www.pgcli.com/docs · fetched 2026-08-29 · 7eda03de1526
- site_page: https://www.pgcli.com/about · fetched 2026-08-29 · 8694e483956d
- site_page: https://www.pgcli.com/faq · fetched 2026-08-29 · 32e03af3d91a
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| dbcli/pgcli | main | 77 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem