whatisgithub

What is pgadmin4?

pgadmin-org/pgadmin4 — explained in plain English

Analysis updated 2026-05-18

3,611PythonAudience · developerComplexity · 3/5Setup · moderate

In one sentence

pgAdmin 4 is a free visual tool for browsing, querying, and managing PostgreSQL databases, available as a desktop app or a web application.

Mindmap

mindmap
  root((pgAdmin 4))
    What it does
      Manage PostgreSQL
      Run queries
      View and edit data
    Tech stack
      Python
      Flask
      React
      Electron
    Use cases
      Database administration
      Team database access
      Query and browse data
    Audience
      Developers
      Database admins

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Browse and edit PostgreSQL database contents through a visual interface.

USE CASE 2

Run and manage SQL queries without using a command-line client.

USE CASE 3

Host a shared web-based database admin tool for a whole team.

What is it built with?

PythonFlaskReactElectron

How does it compare?

pgadmin-org/pgadmin4karpathy/reader3markfzp/act-plus-plus
Stars3,6113,6123,615
LanguagePythonPythonPython
Setup difficultymoderateeasyhard
Complexity3/51/55/5
Audiencedevelopervibe coderresearcher

Figures from each repo's GitHub metadata at analysis time.

How do you get it running?

Difficulty · moderate Time to first run · 30min

Most users should download a pre-built installer instead of building from source.

No license information is stated in the README.

So what is it?

pgAdmin 4 is an open-source desktop and web application for managing PostgreSQL databases. PostgreSQL is a widely used database system, and pgAdmin gives you a visual interface to work with it: creating tables, running queries, viewing data, managing users, and monitoring what is happening inside the database. It is the most popular administration tool for PostgreSQL and has been around in various forms for many years, with version 4 being a complete rewrite of the older pgAdmin 3. The application can run in two modes. In desktop mode, it launches as a standalone program on your computer using a technology called Electron, which wraps the web interface in a native window. In server mode, it runs as a web server that multiple users can connect to through a browser, making it suitable for shared team environments or hosting on a company's internal network. The technical stack is Python on the backend using a framework called Flask, and React on the frontend for the browser interface. For developers who want to build it from source, the README walks through installing Node.js, Python, yarn, and PostgreSQL, then running commands to compile the JavaScript assets and start the Python server. For most users, the easier path is to download a pre-built installer for their operating system directly from the pgAdmin website, rather than building from this source code. The repository is primarily for contributors, packagers, and developers who need to modify or extend pgAdmin itself. If you are a non-technical user who received a link to this project, the short version is that pgAdmin is a free, visual tool for browsing and editing database contents, similar in spirit to a spreadsheet interface but built specifically for PostgreSQL databases.

Copy-paste prompts

Prompt 1
Explain the difference between running pgAdmin 4 in desktop mode versus server mode.
Prompt 2
Walk me through building pgAdmin 4 from source with Node.js, Python, and yarn.
Prompt 3
What can I do with pgAdmin 4 that I could not do using the plain psql command line?
Prompt 4
Should I build this from source or just download the pre-built pgAdmin installer?

Frequently asked questions

What is pgadmin4?

pgAdmin 4 is a free visual tool for browsing, querying, and managing PostgreSQL databases, available as a desktop app or a web application.

What language is pgadmin4 written in?

Mainly Python. The stack also includes Python, Flask, React.

What license does pgadmin4 use?

No license information is stated in the README.

How hard is pgadmin4 to set up?

Setup difficulty is rated moderate, with roughly 30min to a first successful run.

Who is pgadmin4 for?

Mainly developer.

Open on GitHub → Ask about another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.