The PostgreSQL MCP Server provides AI assistants with comprehensive PostgreSQL database management through 17 intelligent tools covering schema management, security, data operations, performance optimization, and monitoring.

Core Capabilities:

• Schema & Structure Management - Create/alter tables, manage ENUMs, columns, constraints (foreign keys, checks, unique), indexes (btree, hash, gist, gin, brin), functions (SQL, PL/pgSQL, PL/Python), triggers, and database object comments

• Security & Access Control - Create/drop/alter users and roles with granular permissions, grant/revoke privileges on tables/schemas/databases, implement Row-Level Security (RLS) policies

• Data Operations - Execute SELECT queries with parameterized statements, perform INSERT/UPDATE/DELETE/UPSERT operations with conflict resolution, run arbitrary SQL with transaction support, export/import data (JSON/CSV), and copy data between databases

• Performance & Diagnostics - Generate EXPLAIN plans, identify slow queries, analyze query statistics and cache hit ratios, examine database configuration/performance/security, and troubleshoot connection, lock, and replication issues

• Real-time Monitoring - Monitor active connections, queries, locks, table statistics, replication lag, and set customizable alert thresholds

• Index Management - Create/drop/rebuild indexes (including concurrent operations), analyze usage patterns, and identify duplicates

Key Features: SQL injection prevention through parameterized queries, transaction wrapping for atomicity, connection pooling, flexible connection options (CLI, environment variables, per-tool strings), concurrent operations support, and production-ready error handling with Docker support.

Supports PostgreSQL installation and configuration on Linux platforms with customized setup instructions tailored to Linux environments.

Provides platform-specific PostgreSQL installation and configuration guidance for macOS systems.

Requires Node.js runtime environment for server operation, with specific version requirements (≥ 18.0.0) for proper functionality.

Provides comprehensive PostgreSQL database management capabilities, including database analysis, schema management, data migration, and real-time monitoring. Enables analyzing configurations, debugging issues, creating and altering tables, exporting/importing data between databases, and monitoring performance metrics.

1. Click on "Install Server".

2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.

3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@PostgreSQL MCP Server show me the top 5 slowest queries from yesterday"

That's it! The server will respond to your query, and you can continue using it as needed.

Here is a step-by-step guide with screenshots.

# Install globally
npm install -g @henkey/postgres-mcp-server

# Or run directly with npx (no installation)
# Use env var for connection string (optional)
export POSTGRES_CONNECTION_STRING="postgresql://user:pass@localhost:5432/db"
npx @henkey/postgres-mcp-server
# Or pass directly:
npx @henkey/postgres-mcp-server --connection-string "postgresql://user:pass@localhost:5432/db"

{
 "mcpServers": {
 "postgresql-mcp": {
 "command": "npx",
 "args": [
 "@henkey/postgres-mcp-server",
 "--connection-string", "postgresql://user:password@host:port/database"
 ]
 }
 }
}

npx -y @smithery/cli install @HenkDz/postgresql-mcp-server --client claude

# Build the Docker image
docker build -t postgres-mcp-server .

# Run with environment variable
docker run -i --rm \
 -e POSTGRES_CONNECTION_STRING="postgresql://user:password@host:port/database" \
 postgres-mcp-server

{
 "mcpServers": {
 "postgresql-mcp": {
 "command": "docker",
 "args": [
 "run",
 "-i",
 "--rm",
 "henkey/postgres-mcp:latest",
 "-e",
 "POSTGRES_CONNECTION_STRING"
 ],
 "env": {
 "POSTGRES_CONNECTION_STRING": "postgresql://user:password@host:port/database"
 }
 }
 }
}

git clone <repository-url>
cd postgresql-mcp-server
npm install
npm run build

{
 "mcpServers": {
 "postgresql-mcp": {
 "command": "node",
 "args": [
 "/path/to/postgresql-mcp-server/build/index.js",
 "--connection-string", "postgresql://user:password@host:port/database"
 ]
 }
 }
}

// Analyze database performance
{ "analysisType": "performance" }

// Create a table with constraints
{
 "operation": "create_table",
 "tableName": "users", 
 "columns": [
 { "name": "id", "type": "SERIAL PRIMARY KEY" },
 { "name": "email", "type": "VARCHAR(255) UNIQUE NOT NULL" }
 ]
}

// Query data with parameters
{
 "operation": "select",
 "query": "SELECT * FROM users WHERE created_at > $1",
 "parameters": ["2024-01-01"],
 "limit": 100
}

// Insert new data
{
 "operation": "insert",
 "table": "users",
 "data": {"name": "John Doe", "email": "john@example.com"},
 "returning": "*"
}

// Find slow queries
{
 "operation": "get_slow_queries",
 "limit": 5,
 "minDuration": 100
}

// Execute a parameterized SELECT query
{
 "operation": "select",
 "query": "SELECT * FROM users WHERE id = $1",
 "parameters": [1]
}

// Perform an INSERT mutation
{
 "operation": "insert",
 "table": "products",
 "data": {"name": "New Product", "price": 99.99},
 "returning": "id"
}

// Manage database object comments
{
 "operation": "set",
 "objectType": "table",
 "objectName": "users",
 "comment": "Main user account information table"
}

# Build locally
docker build -t postgres-mcp-server .

# Or pull from Docker Hub
docker pull henkey/postgres-mcp:latest

# Basic usage (using Docker Hub image)
docker run -i --rm \
 -e POSTGRES_CONNECTION_STRING="postgresql://user:password@host:port/database" \
 henkey/postgres-mcp:latest

# Or with locally built image
docker run -i --rm \
 -e POSTGRES_CONNECTION_STRING="postgresql://user:password@host:port/database" \
 postgres-mcp-server

# With tools configuration
docker run -i --rm \
 -e POSTGRES_CONNECTION_STRING="postgresql://user:password@host:port/database" \
 -e POSTGRES_TOOLS_CONFIG="/app/config/tools.json" \
 -v /path/to/config:/app/config \
 postgres-mcp-server

version: '3.8'
services:
 postgres-mcp:
 build: .
 environment:
 - POSTGRES_CONNECTION_STRING=postgresql://user:password@postgres:5432/database
 depends_on:
 - postgres
 stdin_open: true
 tty: true

 postgres:
 image: postgres:15
 environment:
 - POSTGRES_DB=database
 - POSTGRES_USER=user
 - POSTGRES_PASSWORD=password
 ports:
 - "5432:5432"

{
 "mcpServers": {
 "postgresql-mcp": {
 "command": "docker",
 "args": [
 "run",
 "-i",
 "--rm",
 "henkey/postgres-mcp:latest",
 "-e",
 "POSTGRES_CONNECTION_STRING"
 ],
 "env": {
 "POSTGRES_CONNECTION_STRING": "postgresql://user:password@host:port/database"
 }
 }
 }
}