Which integrations are available for this server?

Enables AI-driven database administration, observability, and querying with support for schema management, SQL execution, JSONB operations, text processing, statistical analysis, query optimization, and extensions including pgvector, PostGIS, and pg_stat_statements.

postgresql-mcp

License: MIT TypeScript MCP

UNDER DEVELOPMENT - NOT READY FOR PRODUCTION

An enterprise-focused PostgreSQL MCP server enabling secure, AI-driven database administration, observability, and querying via OAuth 2.0, with connection pooling, OAuth 2.0 and advanced tool filtering.

Features

Full PostgreSQL Support - 100% coverage of PostgreSQL features
Connection Pooling - Built-in connection pool management
Tool Filtering - Filter tools by category or custom patterns
Extension Support - PostGIS, pgvector, pg_stat_statements, and more
Code Mode - TypeScript implementation with strict typing

Quick Start

# Install npm install -g postgresql-mcp # Run with connection string postgresql-mcp --postgres postgres://user:password@localhost:5432/database

MCP Client Configuration

Claude Desktop / Cursor

{ "mcpServers": { "postgres": { "command": "npx", "args": ["-y", "postgresql-mcp", "--postgres", "postgres://user:password@localhost:5432/database"] } } }

Tool Categories

Category	Tools	Description
Core Database	TBD	Schema, SQL execution, health
JSON Operations	TBD	JSONB operations, validation
Text Processing	TBD	Similarity, full-text, fuzzy
Statistical Analysis	TBD	Stats, correlation, regression
Performance	TBD	Query optimization, index tuning
Vector/Semantic	TBD	pgvector integration
Geospatial	TBD	PostGIS operations
Backup & Recovery	TBD	Backup planning, restore
Monitoring	TBD	Real-time monitoring, alerting

Extension Support

Extension	Purpose
`pg_stat_statements`	Query performance tracking
`pg_trgm`	Text similarity
`fuzzystrmatch`	Fuzzy matching
`hypopg`	Hypothetical indexes
`pgvector`	Vector similarity search
`PostGIS`	Geospatial operations

Development

# Clone and install git clone https://github.com/neverinfamous/postgresql-mcp.git cd postgresql-mcp npm install # Build npm run build # Run checks npm run check