pgcli Interactive PostgreSQL Client with Autocompletion

pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.

agentskillexchange Updated 28 repo stars

File contents

pgcli Interactive PostgreSQL Client with Autocompletion

pgcli is an interactive PostgreSQL CLI with context-aware autocompletion, syntax highlighting, and multi-line query editing. Part of the dbcli project with 13k+ GitHub stars, it makes database exploration and query writing dramatically more productive.

Installation

Use the upstream install or setup path that matches your environment:

  • $ pip install -U pgcli
  • $ brew install pgcli # Only on macOS
  • $ brew install pgcli
  • $ pip install pgcli

Requirements and caveats from upstream:

Basic usage or getting-started notes:


Source

agentskillexchange/skills/tree/main/skills/pgcli-interactive-postgresql-client commit 1fa61917f6

Frequently asked questions

npx skillmds@latest add agentskillexchange/pgcli-interactive-postgresql-client-with-autocompletion