pgcli

A PostgreSQL CLI with auto-completion and syntax highlighting

GitHub
Miscellaneous Python replaces psql

pgcli is a command-line interface for PostgreSQL with auto-completion (including table and column names) and syntax highlighting.

Install

brew brew install pgcli
pip pip install pgcli

Demos

Database Exploration — Part 2: Run a Query
▶ GIF

Database Exploration — Part 2: Run a Query

@agentgif
pgcli — pgcli vs psql
▶ GIF

pgcli — pgcli vs psql

@agentgif
pgcli — Dracula theme
▶ GIF

pgcli — Dracula theme

@agentgif
psql — pgcli vs psql
▶ GIF

psql — pgcli vs psql

@agentgif
Database Exploration — Part 1: Interactive REPL with pgcli
▶ GIF

Database Exploration — Part 1: Interactive REPL with pgcli

@agentgif
pgcli — PostgreSQL CLI with Autocomplete
▶ GIF

pgcli — PostgreSQL CLI with Autocomplete

@agentgif
pgcli — Monokai Pro theme
▶ GIF

pgcli — Monokai Pro theme

@agentgif
pgcli — Gruvbox Dark theme
▶ GIF

pgcli — Gruvbox Dark theme

@agentgif
pgcli — Solarized Dark theme
▶ GIF

pgcli — Solarized Dark theme

@agentgif
pgcli — Tokyo Night theme
▶ GIF

pgcli — Tokyo Night theme

@agentgif
pgcli — Nord theme
▶ GIF

pgcli — Nord theme

@agentgif

Related Tools

asciiquarium

An aquarium/sea animation in ASCII art for your terminal

 Bun

All-in-one JavaScript runtime, bundler, transpiler, and pac…

 calcurse

A calendar and scheduling application for the command line

 Cargo

The Rust package manager and build system

 catimg

Display images in the terminal using Unicode characters

 cbonsai

Grow bonsai trees in your terminal

 chafa

Versatile image-to-text converter for terminal graphics

 cmatrix

Terminal-based Matrix rain animation