Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.

$ pgcli --help Usage: pgcli [OPTIONS] [DBNAME] [USERNAME] Options: -h, --host TEXT Host address of the postgres database. -p, --port INTEGER Port number at which the postgres instance is listening. -U, --username TEXT Username to connect to the postgres database.

May 26, 2025 - pgcli is a command-line PostgreSQL client with auto-completion and syntax colouring, built for quick interactive querying directly from the terminal.

July 23, 2025 - PGCLI is a Python package that is used as an interactive command-line interface for the PostgreSQL database server. For following with the article, make sure you have PostgreSQL installed and set up in your local system.

June 3, 2026 - Install pgcli with Anaconda.org. CLI for Postgres Database. With auto-completion and syntax highlighting.

brew install pgcli · CLI for Postgres with auto-completion and syntax highlighting · https://pgcli.com/ License: BSD-3-Clause · Development: Pull requests · Formula JSON API: /api/formula/pgcli.json · Formula code: pgcli.rb on GitHub ·

January 6, 2015 - I'm planning to do a sweep of the popular destinations for the socket file before falling back to an empty string. https://github.com/amjith/pgcli/issues/37

View the file list for pgcli · View the soname list for pgcli · Copyright © 2002-2026 Judd Vinet, Aaron Griffin and Levente Polyák. The Arch Linux name and logo are recognized trademarks. Some rights reserved.

In [2]: %pgcli postgres://someone@localhost:5432/world Connected: someone@world someone@localhost:world> select * from city c where countrycode = 'USA' and population > 1000000; +------+--------------+---------------+--------------+--------------+ | id | name | countrycode | district | population ...

August 18, 2023 - Learn how to simplify your PostgreSQL database management using pgcli, a user-friendly command-line tool. This guide covers the installation and usage of pgcli.

Pgcli uses psycopg to talk to postgres database. In order to install psycopg, you will need libpq and python-dev installed on your system.

The config file for pgcli is located in the home folder (~/.config/pgcli/config).

October 16, 2025 - When comparing pgcli vs sqlplus, the database backend is a decisive factor. pgcli is for PostgreSQL and derivatives. sqlplus is for Oracle. But engineers often work across stacks. Some teams migrate from Oracle to Postgres, or run hybrid systems. In these cases, knowing both tools is useful.

October 16, 2025 - Pgcli, the popular CLI for Postgres, is more than a command-line shell. It’s a tool that rewrites how you interact with your database. A strong Pgcli Team Lead shapes that experience.

March 13, 2026 - pgcli enhances the psql experience with auto-completion, syntax highlighting, and formatted table output. Compare pgcli and psql for querying PostgreSQL.

October 16, 2025 - Pgcli is a command-line interface for PostgreSQL with autocomplete and syntax highlighting. When combined with RBAC, it becomes a fast, secure way to manage permissions without sacrificing speed or control.

January 27, 2023 - pgcli is a command-line interface (CLI) for interacting with PostgreSQL databases, similar to the psql command-line utility that is…

pgcli - CLI for Postgres Database. With auto-completion and syntax highlighting · python3-pgcli+keyring - Metapackage for python3-pgcli: keyring extras · python3-pgcli+sshtunnel - Metapackage for python3-pgcli: sshtunnel extras ·

August 26, 2025 - Combining auto-remediation workflows with pgcli creates a powerful system to address common database issues. Since pgcli offers an efficient way to execute commands, it provides a smooth surface on which automation can operate.

November 4, 2022 - 🐍🐳🐘 A python command line interface for DigitalOcean postgres clusters (5+ integrations). - jim-schwoebel/dopg_cli