pgconsole MCP server

Name: pgconsole
Author: pgplex

Minimal Postgres editor for speed, collaboration, and AI

What pgconsole does

Summarised from the project README; check the repository for the latest details.

Features

Autocomplete — context-aware suggestions for tables, columns, joins, and CTEs
Formatting — pretty-print or collapse SQL to one line
Error detection — red underlines with hover tooltips
Code folding — collapse `SELECT`, `WITH`, and other blocks
Function signature help — parameter hints as you type
Result grid & inline editing — virtual-scrolling query results with staged edits, generated SQL previews, and optional AI risk assessment before execution

Requirements

Node.js 20+

Repository: pgplex/pgconsole
Website: https://www.pgconsole.com
Stars: ★156
Language: TypeScript
Last updated: 2026-08-14
agentaurora-postgresqlcloudsql-postgresdatagripdbeavergitopsmcp-servernavicatneonneondbpostgrespostgres-mcppostgresqlsql-clientsql-editorsupabasetableplus

How to install pgconsole

No install config was found in this README. See the repository for setup steps, then follow our guides for Claude Desktop, Cursor or VS Code.

Featured in: Best MCP servers for PostgreSQL · Best MCP servers for Supabase

Listed on Socketlist – add this badge to your README:

Badge markdown

[![Listed on Socketlist](https://socketlist.pages.dev/badge.svg)](https://socketlist.pages.dev/s/pgplex-pgconsole/)

Maintain this project? Get it featured for free during launch →

Compare with codebase-memory-mcp →

Related Databases MCP servers

codebase-memory-mcp by DeusData · ★46608
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases

nightingale by ccfos · ★13352
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases

code-graph-rag by vitali87 · ★5258
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases

tabularis by TabularisDB · ★5214
Open-source desktop SQL workspace with 3 built-in database drivers and 16 shipped plugins, including SQL Server, DuckDB, ClickHouse and Redi
Databases

whodb by clidey · ★5037
Where data access meets operational intelligence
Databases

dbhub by bytebase · ★3646
Token conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.
Databases

Weekly MCP digest – new and trending MCP servers in your inbox.