PostgreSQL MCP Server

A comprehensive PostgreSQL server for the Model Context Protocol (MCP) that provides database access through MCP tools and resources.

Features

• Database Operations: Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
• Schema Management: Get table schemas, list tables, create tables
• Database Statistics: Get database stats and connection information
• Connection Management: Test connections and monitor pool status
• MCP Resources: Access database schema and connection status as resources
• Environment Configuration: Configure via environment variables
• npx Support: Can be run via npx for easy integration with MCP clients

Installation

Local Installation

npm install

Global Installation (for npx usage)

npm install -g mcp-server-postgres

Using npx (recommended)

npx mcp-server-postgres

Usage

Running with npx

The server can be run directly with npx, making it easy to integrate with MCP clients:

npx mcp-server-postgres

MCP Client Configuration

#### For Local Development Add this to your MCP client configuration (e.g., Claude Desktop) for local development:

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["c:\\Users\\CascadeProjects\\mcp-postgres-server\\bin\\mcp-server-postgres.js"],
      "env": {
        "POSTGRES_USER": "pguser",
        "POSTGRES_HOST": "localhost",
        "POSTGRES_DB": "postgres",
        "POSTGRES_PASSWORD": "admin",
        "POSTGRES_PORT": "5432",
        "POSTGRES_SSL": "false"
      }
    }
  }
}

#### For Published Package (npx) If the package is published to npm registry:

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["mcp-server-postgres"],
      "env": {
        "POSTGRES_USER": "pguser",
        "POSTGRES_HOST": "localhost",
        "POSTGRES_DB": "postgres",
        "POSTGRES_PASSWORD": "admin",
        "POSTGRES_PORT": "5432",
        "POSTGRES_SSL": "false"
      }
    }
  }
}

Environment Variables

Configure your PostgreSQL connection using these environment variables:

• POSTGRES_USER - Database username (default: postgres)
• POSTGRES_HOST - Database host (default: localhost)
• POSTGRES_DB - Database name (default: postgres)
• POSTGRES_PASSWORD - Database password
• POSTGRES_PORT - Database port (default: 5432)
• POSTGRES_SSL - Enable SSL (default: false)

Available Tools

• execute_query - Execute SQL queries with optional parameters
• get_table_schema - Get detailed schema information for tables
• list_tables - List all tables in the database
• get_database_stats - Get database statistics and metadata
• create_table - Create new tables with columns and constraints
• test_connection - Test database connection and get status

Available Resources

• postgres://schema/all - Complete database schema information
• postgres://status - Current connection status and pool information

Testing

Run the test scripts to verify functionality:

npm test
npm run test-postgres