PostgreSQL MCP Server v3.1.0

An enterprise-grade PostgreSQL MCP Server designed for AI-native workflows. Utilize robust pgvector integration, PostGIS spatial operations, and intelligent tool filtering tailored for Windsurf and Cursor.

AI-First Operations: Seamlessly integrate pgvector and PostGIS spatial queries directly into your Claude and Windsurf workflows.
Token Optimization: Dynamic tool filtering ensures your AI only receives the context it needs, reducing token burn.
Zero Vulnerabilities: Deploy with confidence using our cryptographically-verified Docker images with a flawless security audit.

GitHub npm Docker Hub Search Docs

Latest Release — v3.1.0

Highlights

Expand AI Capabilities: Introduced 30 new tools across Security, Roles, and Document Store for advanced database administration.
Ensure Bulletproof Operations: Enforced strict object existence verification to prevent silent failures and guarantee structured error handling.
Harden Supply Chain: Pinned Dockerfile dependencies and patched critical CVEs to secure your infrastructure.

New Features

Automated coverage badge updates upon test suite execution.
Added initializationSql config to safely execute session setup queries on connection checkout.
Introduced 9 new tools for Security (auditing, SSL/TLS, masking, firewall).
Introduced 12 new tools for Roles (CRUD, privilege, RLS management).
Introduced 9 new tools for Document Store (JSONB document management, indexing).

Changes

Updated core dependencies (typescript, eslint, zod, jose, @playwright/test, vitest).
Pinned transitive Docker dependencies for security.
Optimized default limits and payload truncation parameters to prevent LLM token bloat.
Streamlined pg_schema_snapshot and added exclude parameter to pg_list_views.

Bug Fixes

Remediated Zod validation leaks across multiple groups to ensure structured handler errors.
Enforced strict P154 object existence verification across Migration, Core, PostGIS, Performance, etc.
Standardized alias parsing and type coercion across tool groups.
Standardized parsing for missing extensions and native Postgres exceptions into structured errors.
Fixed numerous bugs across Backup, Docstore, Ltree, Transactions, Partman, and Pgcrypto tools.
Stabilized testing infrastructure (PowerShell bleed and E2E assertions).

Security

Bumped hono to 4.12.18, ip-address to 10.2.0, and fast-uri to 3.1.2 via package overrides.

View Full Changelog: v3.0.7...v3.1.0

Quick Start

npm install -g @neverinfamous/postgres-mcp@latest
docker pull writenotenow/postgres-mcp:v3.1.0