Why developers like pgAdmin

What is pgAdmin?

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

pgAdmin is a tool in the Database Tools category of a tech stack.

pgAdmin is an open source tool with GitHub stars and GitHub forks. Here’s a link to pgAdmin's open source repository on GitHub

Who uses pgAdmin?

Companies

29 companies reportedly use pgAdmin in their tech stacks, including doubleSlash, Biting Bit, and UserGuiding.

doubleSlash

Biting Bit

UserGuiding

Kanteronstack

Delovoy Tech

Payolog

back-end

Our Stack

Media4Care

Developers

130 developers on StackShare have stated that they use pgAdmin.

General Stack

My Stack

Software Development

The Server Side

My Stack

Tlive

My Stack

pgAdmin Integrations

MySQL, PostgreSQL, MongoDB, SQLite, and Windows are some of the popular tools that integrate with pgAdmin. Here's a list of all 7 tools that integrate with pgAdmin.

MySQL

PostgreSQL

MongoDB

SQLite

Windows

TimescaleDB

RasaGPT

Decisions about pgAdmin

Here are some stack decisions, common use cases and reviews by companies and developers who chose pgAdmin in their tech stack.

John Calandra

Data Manager at The Garrett Group · Dec 9, 2020 | 8 upvotes · 357.2K views

Needs advice

Linux

pgAdmin

and

PostgreSQL

There is a question coming... I am using Oracle VirtualBox to spawn 3 Ubuntu Linux virtual machines (VM). VM1 is being used as a data lake - just a place to store flat files. VM2 hosts Apache NiFi. VM3 hosts PostgreSQL. I have built a NiFi pipeline that reads flat files on VM1 and then pipes the data over to and inserts it into the Postgresql database. I left this setup alone for a while, and then something hiccupped on VM3, and I had to rebuild it. Now I cannot make a remote connection to Postgresql on VM3. I was using pgAdmin3 on VM3, but it kept throwing errors - I found out it went end-of-life in 2018 and uninstalled it. pgAdmin4 is out, but for some reason, I cannot get the APT utility to find/install it. I am trying to figure out the pgAdmin4 install problem and looking for a good alternative for pgAdmin4 that I can use to diagnose the remote database connection problem. Does anyone have any suggestions? Thanks in advance.

See all decisions

pgAdmin's Features

Multiplatform
Designed for multiple PostgreSQL versions and derivatives
Extensive documentation
Desktop mode
Server mode
Create, view and edit all common PostgreSQL objects

pgAdmin Alternatives & Comparisons

What are some alternatives to pgAdmin?

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

Related Comparisons