AgentIndex icon
AgentIndex
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Submit Tool
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompare
Home/
Dev Tooling/
pgconsole
pgconsole logo

pgconsole

Active·★ 157·Apache-2.0·Updated 2026-08-14
★ Hidden Gem

pgconsole is a web-based PostgreSQL editor offering a full-featured SQL workspace with intelligent parser-powered features and AI assistance. It provides robust database access control, audit logging, and the ability to securely expose PostgreSQL connections to external AI agents, all managed through a single configuration file.

#PostgreSQL#SQL Editor#Web-based#AI Assistant#Database Access Control
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
Best by use caseAboutContactAdvertisePrivacy PolicyTerms of UseQYSGitHubBuy me a coffee ☕

Browse by Category

MCP ServersCode AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.

Guides
#Audit Log
#Database Tool
#DevSecOps
$ Install
$ npm install -g @pgplex/pgconsole && pgconsole --config pgconsole.toml
↗ Visit site★ GitHub
01

Features

01SQL Editor: Full-featured SQL workspace with autocomplete, formatting, error detection, code folding, and schema browser.
02AI Assistant: Generate, explain, fix, and rewrite SQL using AI, with schema context and risk assessment.
03Database Access Control: Fine-grained IAM for read, write, DDL, and admin permissions enforced at the application layer.
04Audit Log: Comprehensive recording of every query and login as structured JSON for monitoring and compliance.
05MCP Server: Securely expose Postgres connections to external AI agents via Model Context Protocol with inherited IAM and audit controls.
02

Compatibility

Node.js
Runtime
Verified via docs
PostgreSQL
Database
Verified via docs
Docker
Deployment
Verified via docs
OpenAI
AI Provider
Verified via docs
Anthropic
AI Provider
Verified via docs
Google
AI Provider
Verified via docs
03

Quick start

1
$ npm install -g @pgplex/pgconsole
2
$ pgconsole --config pgconsole.toml
04

Use cases

↳Secure Team Collaboration: Teams needing a shared PostgreSQL editor with built-in access control and audit trails for collaborative database management.
↳AI-Powered SQL Development: Developers looking for an intelligent SQL editor that can generate, explain, and optimize queries with AI assistance and schema awareness.
↳Integrating AI Agents with Databases: Organizations wanting to connect external AI agents (like CI bots or LLMs) to PostgreSQL securely without exposing raw database credentials.
↳Simplified Database Management: Users who prefer a single-binary, single-config solution for managing PostgreSQL instances without requiring a separate database for the tool itself.
05

Alternatives

⚡Top VS:
VSkeypaste★452→VSgodot-mcp★179→VSunity-mcp★15.3k→VS

Comments

Log in to leave a comment

No comments yet. Be the first!

On this page
01Features02Compatibility03Quick start04Use cases05Alternatives
nginx-ui
★11.7k
→
keypaste logo
keypaste★ 452
A KeePass-compatible password and secrets manager for people who work with AI agents.
VSCompare→
godot-mcp logo
godot-mcp★ 179
Give your AI assistant eyes and hands in the Godot editor: scene editing, input injection, deterministic playtesting, and live game state for agents
VSCompare→
unity-mcp logo
unity-mcp★ 15.3k
Unity MCP acts as a bridge, allowing AI assistants (like Claude, Cursor) to interact directly with your Unity Editor via a local MCP (Model Context Protocol) Client. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.
VSCompare→
nginx-ui logo
nginx-ui★ 11.7k
Yet another WebUI for Nginx
VSCompare→
tabularis logo
tabularis★ 5.3k
Open-source database client for PostgreSQL, MySQL/MariaDB and SQLite with SQL notebooks, visual EXPLAIN, AI and MCP built in. Hackable with plugins.
VSCompare→
pgedge-postgres-mcp logo
pgedge-postgres-mcp★ 239
pgEdge MCP Server. A PostgreSQL MCP server with a Natural Language Agent CLI and Web UI.
VSCompare→
agent logo
agent★ 1.8k
DevOps agent that won't accidentally tweet your AWS credentials 🦀
VSCompare→
sourcey logo
sourcey★ 1.4k
Precision documentation from OpenAPI, MCP, Doxygen, and Markdown guides. Static HTML you own.
VSCompare→
See all alternatives →
pgplex /
pgconsole
↗

Minimal Postgres editor for speed and collaboration

157Apache-2.0
Last commit2mo ago
StatusActive
CategoryDev Tooling
Links
Documentation↗Discussion↗Issues↗Releases↗
Cloud Infrastructure
Ad

Deploy on DigitalOcean

Host your MCP servers, Docker containers, and AI agents with $200 free credit over 60 days.

Claim $200 Free Credit