Skip to content
Day 69: new resources are added every day. See what's new
Best Productivity ResourcesBy Shushant LakhyaniVerified creator

Desktop App

pgcli

A friendlier PostgreSQL command line with auto-complete.

Visit pgcli4.6

  • Rating

    4.6 / 5

  • Pricing

    Free

  • Difficulty

    Intermediate

  • Works on

    macOS, Linux

Built with love by Shushant Lakhyani. Building bestproductivityresources.com

Free: 1,100+ ways people make money onlineFree: 399+ ways to make money online

What is pgcli?

pgcli is a Postgres client for the terminal that offers auto-completion and syntax highlighting as you type queries. Its README gives install steps for macOS and Linux and notes it can also be run with Docker.

Third-party open-source projects. We are not affiliated with their authors; repositories are provided as-is by their maintainers. Review each project's license, code and security before installing. See our Disclaimer.

Pros: what pgcli does well

  • Suggests table and column names as you type
  • Colour-highlighted queries are easier to read
  • Install it with a single package command

Cons: where it falls short

  • Terminal only, no window
  • Works with PostgreSQL only

Who pgcli is for

Anyone who writes PostgreSQL queries and wants fewer typos.

Who can skip it

People who prefer a point-and-click database app.

pgcli alternatives

Not sold on pgcli? These do a similar job, and each card says what it has in common.

All Personal Productivity resources

hyperfine

Focus: benchmark, speed test and performance. Shares command line and open source with pgcli. Adds Windows. Same 4.6 rating.

Desktop AppFreemacOS, Windows
4.6Visit

Miller

Focus: csv, json and data wrangling. Shares command line and open source with pgcli. Same 4.6 rating.

Desktop AppFreemacOS, Linux
4.6Visit

Harlequin

Focus: sql editor, database and tui. Shares terminal and open source with pgcli. Adds Windows. Rated 4.5 (pgcli: 4.6).

Desktop AppFreemacOS, Windows
4.5Visit

qsv

Focus: csv, data cleaning and data analysis. Shares command line and open source with pgcli. Adds Windows. Rated 4.5 (pgcli: 4.6).

Desktop AppFreemacOS, Windows
4.5Visit

Atuin

Focus: shell history and sync. Shares terminal and command line with pgcli. Adds Windows. Rated 4.7 (pgcli: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

Free alternatives to pgcli

Want to spend nothing? These free picks cover similar ground.

htop

Focus: process viewer and system monitor. Shares terminal and command line with pgcli. Rated 4.7 (pgcli: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

zoxide

Focus: navigation and shell. Shares terminal and command line with pgcli. Adds Windows. Rated 4.7 (pgcli: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

Tabby

Focus: ssh and serial. Shares terminal and command line with pgcli. Adds Windows. Same 4.6 rating.

Desktop AppFreemacOS, Windows
4.6Visit
Are you the maker of pgcli?Get a free Featured badge for your site, a share image and ready-to-paste posts. No sign-up.

Free Notion database

1,100+ ways people are making money online

Real online businesses, creators and projects, broken down by how they make money: apps, online stores, AI tools and more. Free on Gumroad.

Get the free database

Free Notion database

399+ ways to make money online

Hundreds of online income methods in one place, so you can compare options and pick one to try. Free on Gumroad.

Get the free list

For research and ideas only. Results vary and nothing here is a promise of income. See our Disclaimer.

Weekly newsletter

Everything new, every Monday.

One short email every Monday with everything shipped that week: new free tools and websites, new guides, new free browser tools and what's new in my free Gumroad libraries, plus how the site is growing. Free, and you can unsubscribe anytime.

Join the newsletter

You sign up on Gumroad, which stores your email to send the newsletter. See our Privacy Policy.