Postgres MCP

Query and manage PostgreSQL databases securely via Model Context Protocol.

One-Click Configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://user:password@localhost/dbname"]
    }
  }
}

Copy this configuration and paste it into your claude_desktop_config.json or Cursor settings.

Official PostgreSQL MCP server. Execute queries, explore schemas, and analyze database structure with AI assistance.

Security: Use read-only database users in production. Consider connection string security.

Setup:

Replace connection string with your database credentials
Recommended: Create read-only user for AI access

← Back to all mcp