# pgadmin-org/pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

Repository: https://github.com/pgadmin-org/pgadmin4
Canonical: https://ross.abutalabs.com/products/pgadmin4
Homepage: https://www.pgadmin.org
Language: Python
License: NOASSERTION
License Family: other
Topics: administration, database, dba, management, postgres, postgresql, postgresql-database
Last push: 2026-08-21T13:20:33+00:00

## Health v2 (maintenance only)
Score: 76/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 98, release rhythm 35, longevity 100
- inputs: {"age_days": 3481, "days_push": 12, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3762, forks 880 (observed 2026-08-28T04:08:17.938468+00:00)

## What it is
pgAdmin 4 is the leading open-source administration and development platform for PostgreSQL, offering a graphical interface for managing database objects, running queries, monitoring, and backups. It is built with Python/Flask on the server and React on the client, and deploys as a web application, a desktop runtime (Electron), or a container.

## Use cases
- manage postgresql databases with a gui
- run sql queries against postgres with syntax highlighting
- design database schemas with an erd tool
- diff two postgres schemas before migration
- backup and restore postgres databases
- monitor postgres server activity and autovacuum
- schedule sql and shell jobs with pgagent
- self-host a web-based postgres admin console for a team

## When to choose
- you need a full-featured graphical tool for PostgreSQL administration
- you want a shared web-based DBA console for multiple users
- you need cross-platform desktop access to Postgres servers
- you want built-in backup/restore, monitoring, and job scheduling in one tool

## When to avoid
- you administer databases other than PostgreSQL and its derivatives
- you prefer lightweight command-line tooling like psql
- you need a minimal, scriptable client rather than a full GUI application

## Facets
- artifact type: application
- maturity: stable
- function: gui, database, developer-tools, monitoring, backup, scheduling
- domain: databases, developer-tools, self-hosted
- platform: windows, python, cross-platform
- tags: postgresql, database-administration, dba, query-tool, erd, schema-diff, pgagent, electron, flask, react, macos, linux, docker, web-server, desktop

## Member repositories
- pgadmin-org/pgadmin4 (main) score 76

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:17.938468+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:28:52.843448+00:00, confidence not recorded.
  - readme: https://github.com/pgadmin-org/pgadmin4 (fetched 2026-08-28T04:08:17.938468+00:00, sha 67fa8bd6c30d)
  - homepage: https://www.pgadmin.org (fetched 2026-08-29T09:23:07.121262+00:00, sha 51e5ba277f61)
  - site_page: https://www.pgadmin.org/features (fetched 2026-08-29T09:23:07.131034+00:00, sha 64d969d8c28a)
  - site_page: https://www.pgadmin.org/docs (fetched 2026-08-29T09:23:07.133468+00:00, sha ed068694df43)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/9.17/index.html (fetched 2026-08-29T09:23:07.135900+00:00, sha e0a98a73e26c)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/9.16/index.html (fetched 2026-08-29T09:23:07.137938+00:00, sha 48aaa275661e)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/9.15/index.html (fetched 2026-08-29T09:23:07.139762+00:00, sha 1011c6084364)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/9.14/index.html (fetched 2026-08-29T09:23:07.141379+00:00, sha 829415f2b33f)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/8.14/index.html (fetched 2026-08-29T09:23:07.142915+00:00, sha 4705926d8b08)
  - site_page: https://www.pgadmin.org/docs/pgadmin4/7.8/index.html (fetched 2026-08-29T09:23:07.144466+00:00, sha ad5a192844fe)
- Data as of 2026-08-30T08:39:29.467469+00:00.