Pgconsole

•
163
•

Offers a web-based PostgreSQL editor designed for speed and collaboration, featuring integrated access control and audit logging.

pgconsole is a robust, web-based PostgreSQL editor that simplifies database management and collaboration. It operates as a single binary with a single configuration file, requiring no additional database. Teams can securely connect to PostgreSQL instances, leveraging fine-grained access control, comprehensive audit logging, and an advanced SQL editor with AI-powered features for query generation, explanation, and risk assessment. It also introduces the Model Context Protocol (MCP) Server, enabling secure interaction between external AI agents and Postgres databases.

Key Features

01Full-featured SQL editor with context-aware autocomplete, formatting, error detection, and schema browsing.
02AI Assistant for generating, explaining, fixing, and rewriting SQL queries with schema context and risk assessment.
03MCP Server to expose Postgres connections to external AI agents over Model Context Protocol with inherited IAM and audit controls.
04Fine-grained Database Access Control with application-layer IAM for read, write, DDL, and administrative permissions.
05Comprehensive Audit Log recording every query and login as structured JSON for easy filtering and forwarding.
06113 GitHub stars

Use Cases

01Collaborative SQL editing and database management for development and operations teams.
02Securely integrating external AI agents and tools with PostgreSQL databases without exposing raw credentials.
03Implementing robust database governance and compliance through built-in access control and audit logging.