{"data":{"slug":"pgcli","name":"pgcli","tagline":"BSD-3-Clause Postgres CLI with smart autocompletion","category":"databases","categoryName":"Databases","url":"https://www.pgcli.com","github":"https://github.com/dbcli/pgcli","pricing":"open-source","hook":"pgcli is a drop-in replacement for psql with smart autocompletion of tables, columns and keywords, syntax highlighting and nicer output — the terminal Postgres client you actually enjoy using.","whatsGood":"BSD-3-Clause (dbcli/pgcli), release v4.7.1 (2026-09-20), maintained since 2014. Install with pip, apt or brew, then connect with the same arguments as psql. It is context-aware (suggests columns from the tables in your FROM clause), supports most backslash commands, named queries, pagers, multi-line editing and vi/emacs keys. Sibling project mycli does the same for MySQL. ★~13.4k.","theCatch":"It is a Python app, so startup is slower than psql and you need a Python environment. Some psql meta-commands and scripting behaviours differ, so keep psql for scripts. Huge schemas can make the completion refresh slow.","verdict":"Install it once and you will stop using bare psql for interactive work.","addedAt":"2026-10-18","featured":false,"domain":"Databases","subSpecialty":"Data","subcategory":"Postgres","tags":["cli","self-host","permissive","postgres","active"],"capabilities":["cli"],"surfaces":["CLI","Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"BSD-3-Clause","githubStars":13419,"starsPerWeek":21,"access":"free","archived":false,"repo":{"createdAt":"2014-10-12","pushedAt":"2026-10-15","license":"BSD-3-Clause","archived":false,"checkedAt":"2026-10-19"}},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/pgcli","html":"/gems/pgcli","markdown":"/gems/pgcli.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}