[email protected]:~$ man pgcli

← cd ..
pgcli logo

pgcli

Postgres CLI with autocompletion and syntax highlighting

★ 13.4KBSD-3-Clausev4.7.1PythonData Processing

INSTALLATION

$ pip install -U pgcli
pgcli demo

DESCRIPTION

pgcli is a command-line interface for PostgreSQL that features auto-completion and syntax highlighting.

It provides context-aware suggestions as you type SQL keywords, tables, and columns, making database management faster and more intuitive.

It includes additional features like pretty-printed tabular outputs, smart-completion, and support for standard psql back-slash commands.

DETAILS

Repository
dbcli/pgcli (2026-11-04)
Website
pgcli.com
Author
dbcli
License
BSD-3-Clause
Category
Data Processing
Language
Python
Platforms
Linux, MacOS, Windows
Version
v4.7.1 (2026-09-20)
Repo Age
12 years old

STAR HISTORY

Star history chart for dbcli/pgcli

TAGS

  • database
  • postgres
  • postgresql
  • psql

SEE ALSO

BADGE

Maintain pgcli? Add this badge to your README: listings that link back are marked verified and ranked first in the directory. It's checked once a day.

pgcli on The Terminal Index

[+] show code[−] hide code
Markdown
[![pgcli on The Terminal Index](https://cli.masoko.net/badge/pgcli.svg)](https://cli.masoko.net/tools/pgcli/)
HTML
<a href="https://cli.masoko.net/tools/pgcli/"><img src="https://cli.masoko.net/badge/pgcli.svg" alt="pgcli on The Terminal Index"></a>

RELATED TOOLS