phpPgAdminPostgreSQL administration in the browser

pgAdmin's depth of PostgreSQL support, in the phpMyAdmin interface you already know. PHP and ext-pgsql, no agent, no desktop install.

Get started

Install

GitHub

🗂️

Every PostgreSQL object

Databases, schemas, tables, partitions, views, materialized views, functions, procedures, sequences, types, domains, collations, text search, extensions, foreign data and more. Create, alter and drop each one, and see the DDL first.

⌨️

SQL editor and data grid

Autocomplete, formatting, bind parameters, history, bookmarks and macros. Results open in an editable grid with paging, sorting, filters and inline editing.

📈

Server monitoring

Live charts, sessions with cancel and terminate, locks, prepared transactions, server logs, replication and configuration, all from the server's own views.

🔐

Roles and privileges

Roles, memberships, object and column privileges, default privileges and a grant wizard.

📦

Export, import, maintenance

pg_dump and pg_dumpall downloads, CSV through COPY, restores that run in the background, and VACUUM, ANALYZE, REINDEX and CLUSTER.

🧭

Designer, schema diff, debugger

An ER diagram editor, a schema comparison that writes the migration script, and a PL/pgSQL debugger.