sosedoff/pgweb
Pgweb
pgweb is a web-based database client and graphical administration tool for PostgreSQL. It provides a browser-based interface for executing SQL queries, inspecting schemas, and managing database objects.
The tool includes a read-only mode that prevents destructive operations by blocking specific SQL keywords. It supports secure remote access to private instances through native SSH tunneling and encrypted database connections.
The application covers a broad range of management capabilities, including multi-environment session management, database structure inspection, and the export of query results into CSV, JSON, or XML formats. It also provides monitoring tools for tracking database activity and analyzing query performance.
The project is available as a container image for simplified deployment.
Features
- Database Administration Interfaces - Provides a comprehensive web-based graphical administration tool for managing PostgreSQL databases.
- PostgreSQL Administration Tools - Provides a comprehensive graphical tool for administering and managing PostgreSQL databases.
- Encrypted Connections - Secures data transmission using SSL certificates and encrypted tunnels for database connectivity.
- SQL Query Execution - Executes custom SQL statements with features like keyword autocompletion and selected-block execution.
- Table Browsers - Enables browsing of table contents with pagination, column sorting, and row filtering.
- Web-Based Database Clients - Provides a browser-based interface for executing SQL queries and managing PostgreSQL databases.
- Database Schema Explorers - Offers interactive tools for browsing and inspecting live database schemas, tables, and views.
- Database Management Consoles - Serves a comprehensive database management console through a browser-based HTTP interface.
- SSH Tunneling - Establishes secure, encrypted network paths to remote databases using native SSH tunneling.
- Query Result Exporters - Extracts records and query results from tables into portable formats like CSV and JSON.
- Table Management Utilities - Provides administrative utilities for tables, including deletion, truncation, and statistics analysis.
- Multi-Database Connections - Maintains simultaneous connections to multiple PostgreSQL servers to switch between development and production.
- Query Performance Monitors - Examines execution plans and performance metrics to identify and optimize slow SQL operations.
- Read-Only Access Modes - Prevents accidental data modification by blocking destructive SQL keywords in a read-only mode.
- Database Session Management - Manages simultaneous connections to multiple database instances for quick switching between environments.
- Multi-Format Data Exports - Converts table content and query results into CSV, JSON, or XML files for external use.
- Containerized Deployments - Provides a container image for consistent application execution across different operating systems.
- Secure Database Access - Enables secure, audited connectivity to private PostgreSQL instances via encrypted tunnels and SSL.
- Activity Monitors - Monitors currently active queries and server statistics through a dedicated activity interface.
- Schema Navigators - Builds a searchable navigation tree by querying database metadata for tables, views, and constraints.
- Database Tools - Web-based PostgreSQL database browser.
- Database Utilities - Web-based browser for PostgreSQL databases.
- Database GUI Clients - Web-based database browser built with Go.
- Database GUIs - Web-based database browser for PostgreSQL.
- Database Tools - Web-based PostgreSQL database browser.
