pgAdmin is the official, free, open-source administration and development platform for PostgreSQL. pgAdmin 4 (current version) provides both desktop application and web-based server deployment modes. Core features include a powerful query tool with syntax highlighting and auto-complete, graphical explain plan visualization, server dashboard with real-time monitoring, backup/restore wizard, and user/role management. No AI features are integrated—the tool focuses on comprehensive PostgreSQL administration. The web deployment mode (server mode) enables browser-based access for teams, running as a Python Flask application. Supports all PostgreSQL features including extensions, foreign data wrappers, and advanced security. While lacking modern AI capabilities found in commercial tools, it remains the definitive free option for PostgreSQL administration with complete feature coverage. Page should cover: desktop vs server deployment modes, query tool capabilities, explain plan visualization, administration features, Docker deployment for server mode, comparison with DBeaver for PostgreSQL, and tips for enterprise deployment.