Why pgAdmin?
When managing PostgreSQL across multiple projects and servers at KnausDev, a dedicated admin tool beats running psql for everything. pgAdmin provides visual schema inspection, query execution, and server monitoring in one interface.
Database Management
pgAdmin connects to every PostgreSQL instance across the KnausDev infrastructure — local development databases, staging environments on Hetzner, and production servers. Multi-tenant schemas, replication monitoring, and migration verification all happen here.
What it handles
- Schema inspection: visual overview of tables, indexes, and relationships across databases
- Query execution: ad-hoc queries for debugging and data investigation
- Multi-server management: all PostgreSQL instances registered in one place
- Performance monitoring: identifying slow queries and index candidates
- Migration verification: confirming Laravel migrations applied correctly
Status
Active: PostgreSQL administration across all environments.