PostgreSQL MCP

PostgreSQL database server with advanced query capabilities

By ModelContextProtocolMIT
View Repositorynpm install @modelcontextprotocol/server-postgres

Features

Complex query execution
Schema analysis
Performance monitoring
Connection pooling

Use Cases

Database optimizationData migrationReport generationSchema documentation

Installation

NPM Package
npm install @modelcontextprotocol/server-postgres

Supported Models

Claude 3.5 SonnetGPT-4

Configuration Example

{
  "mcpServers": {
    "postgres": {
      "command": "@modelcontextprotocol/server-postgres",
      "env": {
        // Add your environment variables here
      }
    }
  }
}