home / mcp / postgresql mcp server

PostgreSQL MCP Server

A PostgreSQL MCP Server providing execute_query, list_tables, describe_table, and list_schemas to manage PostgreSQL data via MCP clients.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "liu-creators-postgresql-mcp": {
      "command": "python",
      "args": [
        "postgresql-mcp.py"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "postgres",
        "POSTGRES_DATABASE": "postgres",
        "POSTGRES_PASSWORD": "postgres"
      }
    }
  }
}