io.github.timescale/pg-aiguide

Streamable HTTP / SSE endpoint. Add to any MCP client that supports remote servers.

https://mcp.tigerdata.com/docs

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}

npx -y @tigerdata/pg-aiguide

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-i",
        "ghcr.io/timescale/pg-aiguide:0.5.0"
      ],
      "env": {
        "OPENAI_API_KEY": "<your-openai_api_key>",
        "PGHOST": "<your-pghost>",
        "PGPORT": "<your-pgport>",
        "PGUSER": "<your-pguser>",
        "PGPASSWORD": "<your-pgpassword>",
        "PGDATABASE": "<your-pgdatabase>",
        "DB_SCHEMA": "<your-db_schema>"
      }
    }
  }
}