🍺 BREW Explorer

← all formulae

pgcli

brew install pgcli v4.5.0 BSD-3-Clause

Interactive PostgreSQL command-line client with auto-completion and syntax highlighting.

Why you might care

Drop-in replacement for psql that adds intelligent auto-completion for SQL keywords, table/column names, and functions—dramatically faster for exploratory queries. Syntax highlighting makes complex queries readable; includes a pager for large result sets. Built in Python but requires only libpq, so it works everywhere psql does.

Categories

database-client shell

Alternatives

psql dbeaver mycli
1.8k
30-day installs · #1017
5.0k
90-day · #1090
13.1k
365-day · #1288

Runtime dependencies

libpq python@3.14

Links

Blurb generated by claude-haiku-4-5 on today.

Raw metadata 
{
  "aliases": [],
  "alternatives": [
    "psql",
    "dbeaver",
    "mycli"
  ],
  "build_dependencies": [],
  "categories": [
    "database-client",
    "shell"
  ],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [
    "libpq",
    "python@3.14"
  ],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "CLI for Postgres with auto-completion and syntax highlighting",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:41:16+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "pgcli",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://pgcli.com/",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": "pgcli",
  "installs_30d": 1835,
  "installs_365d": 13131,
  "installs_90d": 4972,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "BSD-3-Clause",
  "llm_generated_at": "2026-06-20T23:48:27+00:00",
  "llm_model": "claude-haiku-4-5",
  "name": "pgcli",
  "oldnames": [],
  "one_liner": "Interactive PostgreSQL command-line client with auto-completion and syntax highlighting.",
  "optional_dependencies": [],
  "rank_30d": 1017,
  "rank_365d": 1288,
  "rank_90d": 1090,
  "raw_hash": "ddb01acc88f2ae62",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/p/pgcli.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [],
  "version_head": null,
  "version_stable": "4.5.0",
  "versioned_formulae": [],
  "why_use_this": "Drop-in replacement for psql that adds intelligent auto-completion for SQL keywords, table/column names, and functions\u2014dramatically faster for exploratory queries. Syntax highlighting makes complex queries readable; includes a pager for large result sets. Built in Python but requires only libpq, so it works everywhere psql does."
}