Need advice about which tool to choose?Ask the StackShare community!

pgAdmin

110
131
+ 1
0
pgcli

3
15
+ 1
0
Add tool

pgAdmin vs pgcli: What are the differences?

Developers describe pgAdmin as "Administration and development platform for PostgreSQL". pgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. On the other hand, pgcli is detailed as "Postgres CLI with autocompletion and syntax highlighting". This is a postgres client that does auto-completion and syntax highlighting.

pgAdmin and pgcli can be categorized as "Database" tools.

Some of the features offered by pgAdmin are:

  • Multiplatform
  • Designed for multiple PostgreSQL versions and derivatives
  • Extensive documentation

On the other hand, pgcli provides the following key features:

  • Auto-completion as you type for SQL keywords as well as tables and columns in the database.
  • Syntax highlighting using Pygments.
  • Smart-completion (enabled by default) will suggest context-sensitive completion.

pgAdmin and pgcli are both open source tools. It seems that pgcli with 8.01K GitHub stars and 366 forks on GitHub has more adoption than pgAdmin with 270 GitHub stars and 126 GitHub forks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More

Sign up to add or upvote prosMake informed product decisions

Sign up to add or upvote consMake informed product decisions

What is pgAdmin?

It is the leading graphical Open Source management, development and administration tool for PostgreSQL.

What is pgcli?

This is a postgres client that does auto-completion and syntax highlighting.

Need advice about which tool to choose?Ask the StackShare community!

What companies use pgAdmin?
What companies use pgcli?
    No companies found
    See which teams inside your own company are using pgAdmin or pgcli.
    Sign up for Private StackShareLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with pgAdmin?
    What tools integrate with pgcli?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to pgAdmin and pgcli?
    DataGrip
    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
    OmniDB
    OmniDB is a web tool that simplifies database management focusing on interactivity, designed to be powerful and lightweight.
    DBeaver
    It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
    phpPgAdmin
    It is the leading graphical Open Source management, development and administration tool for PostgreSQL, running on Windows, Linux, Solaris, FreeBSD and Mac OSX
    Navicat
    Powerful database management & design tool for Win, Mac & Linux. With intuitive GUI, user manages MySQL, MariaDB, SQL Server, SQLite, Oracle & PostgreSQL DB easily.
    See all alternatives