Skip to content
whatismyalternative

pgcli

A command line interface for Postgres with auto-completion and syntax highlighting.

Visit pgcli

pgcli is a command-line interface for Postgres that adds auto-completion and syntax highlighting to interactive database sessions. It is an open-source Python project hosted on GitHub under the dbcli organization, installed via pip or Homebrew.

It connects using command-line options for host, port, username, password, and database name, or via connection strings and DSN aliases stored in the pgclirc file. It also supports many of the same environment variables as psql for login options, such as PGHOST, PGPORT, PGUSER, PGPASSWORD, and PGDATABASE. Additional options include a row-limit threshold, automatic vertical output when results exceed terminal width, a warning before running destructive queries, custom prompt formats, and a single-connection mode for completions.

pgcli is aimed at developers and database administrators who work with Postgres from the terminal. It is distributed as open-source software with no paid editions, seat-based licensing, or usage-based pricing indicated.

12 alternatives to pgcli

Ranked by how well each tool replaces pgcli: shared features, audience, price and popularity.

  1. PostgreSQL

    Open source object-relational database system

    Covers 0 of 10 key features and has a free plan.

    Free planOpen source
    66 out of 100 matchFree

  2. pgAdmin

    Everything PostgreSQL, in one place.

    Covers 2 of 10 key features.

    Open source
    66 out of 100 match—

  3. Postgres.app

    Easiest way to get started with PostgreSQL on the Mac

    Covers 0 of 10 key features and has a free plan.

    Free planOpen source
    62 out of 100 matchContact sales

  4. mycli

    A command-line interface for MySQL with auto-completion, syntax highlighting, fuzzy search

    Covers 3 of 10 key features.

    Open source
    60 out of 100 match—

  5. TablePlus

    Database management made easy.

    Covers 1 of 10 key features.

    60 out of 100 match—

  6. PSequel

    A PostgreSQL GUI tool for macOS

    Covers 0 of 10 key features and has a free plan.

    Free plan
    56 out of 100 matchFree

  7. pgModeler

    Multi-platform PostgreSQL schema engineering tool that runs locally with no cloud, no lock

    Covers 0 of 10 key features and has a free plan.

    Free planOpen source
    55 out of 100 matchContact sales

  8. OrcaQ

    The open source next gen database client

    Covers 0 of 10 key features and has a free plan.

    Free planOpen source
    55 out of 100 matchContact sales

  9. PGlite

    Embeddable Postgres

    Covers 0 of 10 key features.

    Open source
    54 out of 100 match—

  10. Studio 3T Community Edition

    Get started with MongoDB using Studio 3T Community Edition, your free starter tool

    Covers 1 of 10 key features and has a free plan.

    Free plan
    52 out of 100 matchContact sales

  11. PgDog

    Scale PostgreSQL horizontally without the pain.

    Covers 0 of 10 key features and has a free plan.

    Free planOpen source
    52 out of 100 matchContact sales

  12. pganalyze

    Postgres performance at any scale

    Covers 0 of 10 key features.

    51 out of 100 match$149/mo