About pgAdmin
pgAdmin is an open source administration and development tool for PostgreSQL. It runs as a desktop app or as a web application that you can reach from a browser.
What it does
pgAdmin lets you create, browse and maintain PostgreSQL objects such as databases, tables and roles through a graphical interface. It shows the SQL behind each change, so you can learn from it or reuse it. The query tool offers syntax highlighting, auto-completion, query history and a graphical EXPLAIN view that helps you see where a slow query spends its time.
Key features
- Graphical management of PostgreSQL objects
- Query tool with syntax highlighting and history
- Graphical EXPLAIN for query plans
- Desktop mode and server mode
- Installers for Windows, macOS, Linux and containers
Who it's for
Developers and database administrators who manage PostgreSQL, teams that want a shared web-based admin tool, and beginners who are learning Postgres.
Pricing and good to know
pgAdmin is free and released under the PostgreSQL licence. New versions arrive roughly every six weeks, and the community helps translate the interface. Server mode suits shared use, but it should sit behind proper access controls and secure connections.
Highlights
- Create and manage PostgreSQL objects in a GUI
- Write queries with highlighting and auto-complete
- Review query history to reuse past work
- Read query plans with a graphical EXPLAIN view
- Run as a desktop app or a web application
