Brave Search

The best Pgcli alternative is HeidiSQL, which is both free and Open Source.

Which is the best alternative to pgcli? Based on common mentions it is: Fish-shell, Black, Stedolan/Jq, Tldr, Httpie/Cli, Exa, Tig, Autojump, Pipx, Pytest or Ipython

Videos

10:45

YouTube

You're using Postgres WRONG - YouTube

1 week ago

02:14

YouTube

Setup pgcli for PostgreSQL Database (WSL) - YouTube

September 25, 2024

youtube.com

PGCLI - Postgres CLI with autocompletion and syntax ...

02:55

YouTube

Maintainer Stories — Amjith Ramanujam - YouTube

stackshare.io › pgcli › alternatives

Best pgcli Alternatives in 2025

The tool will help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes. ... Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages ...

reddit.com › r/postgresql › pg: a (wannabe) alternative cli tool for postgresql

r/PostgreSQL on Reddit: pg: a (wannabe) alternative cli tool for PostgreSQL

November 24, 2022 -

Hey guys, I'm working on this one https://github.com/ferama/pg

It is an alternative cli tool for PostgreSQL.

I do not really love the available GUI clients, I want something more handy that helps during my workflow.

psql is ok but I find myself always maintaining aliases in my shell for the connections on the servers I need access to. Then periodically I forget some of the aliases :) I find psql overcomplicated sometimes and not so user friendly.

So I tried the do it yourself mantra and started pg. It is in its early development stages but I find it to be usable already. I use it every day and I add fixes and features on my very little spare time :)

What do you think? Can it be useful for you too? Do you know any alternatives I should take a look at?
Feedback will be appreciated.

Thanks you all

Top answer

1 of 2

The command line tool which comes bundled with Oracle is SQL*Plus. Find out more.

SQL*Plus is now a rather old tool so it doesn't necessarily do everything we'd want in a command line tool, or do things in the most intuitive fashion. Even its name looks old-fashioned. Oracle realise this and have a new product, sqlcl. It does lots of neat things (command history, autocompletion, scripting, oh my!) but it is a standalone download and install. Find out more.

2 of 2

If you want a general wrapper: GNU SQL http://www.gnu.org/s/parallel/sql.html

Docker Hub

hub.docker.com › r › pygmy › pgcli

pygmy/pgcli - Docker Image

pgcli⁠ is an alternative and arguably better cli client for PostgreSQL intended as a psql replacement

Find elsewhere

Google Bing Mojeek

Nulogy

til-engineering.nulogy.com › pgcli-a-great-alternative-to-psql

pgcli — a great alternative to psql

Ever wished for a feature-rich, intuitive command-line postgresql client? Look no further! Presenting, pgcli — a result of pouring creativity into features rather than the name of the tool. Supports: Smart autocompletion for almost anything. Even column names in the select query are properly autocompleted from the table you are selecting from; Multi-line query editing support; SQL Syntax highlighting; CLI parameters compatible with psql params.

Hoop

hoop.dev › blog › bastion-host-alternative-pgcli

Bastion Host Alternative Pgcli

August 26, 2025 - In this article, we’ll explore why bastion hosts might not be the best fit for today’s workflows and how alternatives, like pgcli paired with smarter infrastructure tools, can streamline your database management.

GitHub

github.com › dbcli › pgcli

GitHub - dbcli/pgcli: Postgres CLI with autocompletion and syntax highlighting · GitHub

The easiest way to install pgcli is using Homebrew. ... Alternatively, you can install pgcli as a python package using a package manager called called pip.

Starred by 13.3K users

Forked by 602 users

Languages Python 98.1% | Gherkin 1.4%

StackShare

stackshare.io › stackups › mycli-vs-pgcli

Mycli vs pgcli | What are the differences?

Mycli: A CLI for MySQL with auto-completion and syntax highlighting. Mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting; pgcli: Postgres CLI with autocompletion and syntax highlighting.

TigerData

tigerdata.com › blog › state-of-postgresql-2022-13-tools-that-arent-psql

State of PostgreSQL 2022—13 Tools That Aren't | Tiger Data

November 28, 2024 - First on the list is pgcli, a Python-based command-line tool and one of many dbcli tools created for various databases. Although this is not a replacement for psql, it provides an interactive, auto-complete interface for writing SQL and getting results. Syntax highlighting and some basic support for psql backslash commands are included.

Pgcli

pgcli.com

pgcli

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

PostgreSQL Wiki

wiki.postgresql.org › wiki › PostgreSQL_Clients

PostgreSQL Clients - PostgreSQL wiki

1 week ago - 5.1.2 pgcli · 5.1.3 jaqy · 6 Other Resources · These clients are both "free" and "open source" https://beekeeperstudio.io/ Beekeeper Studio is a modern cross-platform SQL editor and database manager available for Linux, Mac, and Windows. Some of its features include: Clean, smooth, usable UI with dark and light themes ·

Libhunt

python.libhunt.com › pgcli-alternatives

pgcli Alternatives - Python Productivity Tools | LibHunt

This is a postgres client that does auto-completion and syntax highlighting. Home Page: http://pgcli.com MySQL Equivalent: http://mycli.net ... Based on the "Productivity Tools" category. Alternatively, view pgcli alternatives based on common mentions on social networks and blogs.

Medium

medium.com › @philmcc › best-postgresql-ide-and-gui-tools-in-2026-c3d3124e7bbb

Best PostgreSQL IDE and GUI Tools in 2026 | by Philip McClarence | Medium

March 3, 2026 - If you are just starting out, install DBeaver (free) and pgcli (free). That combination covers GUI and terminal workflows with zero cost.

Awesomeopensource

awesomeopensource.com › project › dbcli › pgcli

Pgcli Alternatives

Alternatives To Pgcli · Alternatives To Pgcli · Select To Compare · Pgcli ⭐ 11,435 · Postgres CLI with autocompletion and syntax highlighting · dependent packages 6total releases 73most recent commit 2 years ago · Athenacli ⭐ 184 · AthenaCLI is a CLI tool for AWS Athena service that can do auto-completion and syntax highlighting.