# PgAdmin

PgAdmin is a web based administration tool for the PostgreSQL database. It is open source and self-hosted, installable on TrueNAS and Kubernetes (Helm).

Canonical page: https://ourlocalhost.com/app/7294/pgadmin

## Description

pgAdmin is a web based administration tool for the PostgreSQL database.

## Platform availability

Available on 2 of 9 platforms: TrueNAS, Helm.

## Health score

76/100 (Good), based on 3 of 4 factors.
- Maintained: 100 (last commit 3 days ago)
- Popular: 72 (3,909 GitHub stars)
- Easy to install: 35 (2 install platforms, install notes)

## Links

- TrueNAS: https://apps.truenas.com/catalog/pgadmin/
- Kubernetes (Helm): https://artifacthub.io/packages/helm/cetic/pgadmin
- Official website: https://www.pgadmin.org/
- GitHub: https://github.com/pgadmin-org/pgadmin4

## Common questions

### Can pgAdmin be self-hosted in a container?

Yes, pgAdmin can run in desktop or server mode and in containers.

### What authentication-related setting does the pgAdmin FAQ cover?

It covers the Master Password, including how to use it or remove it.

### Can pgAdmin connect to PostgreSQL from a Windows installation?

Yes; one user reported no problems connecting pgAdmin when it was downloaded for Windows.

### Why might pgAdmin 4 be slower than pgAdmin 3?

pgAdmin 4 is written in Python, while the older pgAdmin 3 was written in C++. Python is described as slower than languages such as C++ or Java.

## Alternatives

- Beekeeper studio: Beekeeper Studio is a cross-platform, open-source SQL editor and database manager that helps developers and database administrators connect…
- DBeaver: A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plug…
- DataGrip: DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
- DbGate: DbGate is a cross-database SQL and NoSQL client that lets you manage MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, SQLite, and…
- HeidiSQL: Supports MySQL, MariaDB, Microsoft SQL, and PostgreSQL for data viewing, editing, and exporting with no tracking and offline capabilities.
- LibreDB Studio: LibreDB Studio is an open source (MIT), self-hosted SQL IDE.
- Navicat: Navicat is a database administration tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and…
- TablePlus: A native app which helps you easily edit database data and structure.
- Valentina Studio: FREE native AI enabled database manager for RDBMS: DuckDB, MariaDB, MySQL, Parquet, PostgreSQL, SQLite, SQL Server, Valentina DB, and Mongo…
- cloudbeaver: CloudBeaver is a self-hosted, web-based database manager that provides a rich browser interface for connecting to and managing PostgreSQL,…

---
Source: Our Local Host (https://ourlocalhost.com/app/7294/pgadmin), the self-hosted and open-source app directory.