pg-aiguide — MCP Server 安装配置（官方 MCP Registry）

{
  "id": "io.github.timescale/pg-aiguide",
  "type": "mcp-server",
  "version": "0.5.1",
  "displayName": "pg-aiguide",
  "description": "Comprehensive PostgreSQL documentation and best practices, including ecosystem tools",
  "repository": {
    "url": "https://github.com/timescale/pg-aiguide",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "npm",
        "identifier": "@tigerdata/pg-aiguide",
        "version": "0.5.1",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "OPENAI_API_KEY",
            "description": "Your API key for text embeddings via OpenAI",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGHOST",
            "description": "PostgreSQL host to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGPORT",
            "description": "PostgreSQL port to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGUSER",
            "description": "PostgreSQL user to connect as",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGPASSWORD",
            "description": "PostgreSQL password to connect with",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGDATABASE",
            "description": "PostgreSQL database to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "DB_SCHEMA",
            "description": "PostgreSQL database schema to use",
            "isSecret": true
          }
        ]
      },
      {
        "registryType": "oci",
        "identifier": "ghcr.io/timescale/pg-aiguide:0.5.1",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "OPENAI_API_KEY",
            "description": "Your API key for text embeddings via OpenAI",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGHOST",
            "description": "PostgreSQL host to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGPORT",
            "description": "PostgreSQL port to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGUSER",
            "description": "PostgreSQL user to connect as",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGPASSWORD",
            "description": "PostgreSQL password to connect with",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "PGDATABASE",
            "description": "PostgreSQL database to connect to",
            "isRequired": true,
            "isSecret": true
          },
          {
            "name": "DB_SCHEMA",
            "description": "PostgreSQL database schema to use",
            "isSecret": true
          }
        ]
      }
    ],
    "remotes": [
      {
        "transport": "streamable-http",
        "url": "https://mcp.tigerdata.com/docs"
      }
    ]
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.timescale/pg-aiguide",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.timescale%2Fpg-aiguide/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}