pip install -r requirements.txt

python server.py --host host.example.com --port 61025 --database example --username example_user --password example_pwd --test

{
  "mcpServers": {
    "local-postgres-mcp": {
      "command": "C:\\Users\\sk\\AppData\\Local\\Programs\\Python\\Python313\\python.exe",
      "args": [
        "C:\\Workspace\\GitLab\\capacity-planning2\\postgresql-mcp\\server.py",
        "--host", "host.example.com",
        "--port", "61025",
        "--database", "example",
        "--username", "example_user",
        "--password", "example_pwd"
      ],
      "env": {"PYTHONUNBUFFERED": "1"},
      "timeout": 60000
    }
  }
}

Query the database: SELECT * FROM "capacity_planning2".ports LIMIT 5

List all tables in the capacity_planning2 schema

Describe the structure of the ports table in capacity_planning2 schema

Show me all available database schemas