MCP Servers / database / PostgreSQL MCP Server

PostgreSQL MCP Server

JSON →
httpnone186database

A server for managing PostgreSQL databases, enabling comprehensive database operations.

Install
How to run this server
[ { "cmd": "npx -y @smithery/cli", "imports": [] } ]
server path: postgresql-mcp-server-3
Tools
What this server exposes
Schema Management
Manage tables, columns, ENUMs, and constraints
User & Permissions
Create users, grant/revoke permissions
Query Performance
EXPLAIN plans, slow queries, statistics
Index Management
Create, analyze, optimize indexes
Functions
Create, modify, manage stored functions
Triggers
Database trigger management
Constraints
Foreign keys, checks, unique constraints
Row-Level Security
RLS policies and management
Execute Query
SELECT operations with count/exists support
Execute Mutation
INSERT/UPDATE/DELETE/UPSERT operations
Execute SQL
Arbitrary SQL execution with transaction support
Comments Management
Comprehensive comment management for all database objects
Database Analysis
Performance and configuration analysis
Debug Database
Troubleshoot connection, performance, locks
Data Export/Import
JSON/CSV data migration
Copy Between Databases
Cross-database data transfer
Real-time Monitoring
Live database metrics and alerts
Configuration
Environment & auth
authnone
Resources
PostgreSQL MCP Server — MCP Server · libregistry