AgentHubAgentHub

pg-aiguide

MCP ServerMCP Registry官方收录

io.github.timescale/pg-aiguide · v0.5.0

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

源仓库 ↗

概览

pg-aiguide 是一个MCP Server，收录自 官方 MCP Registry。支持 streamable-http、stdio 传输。本页提供 Cursor、Claude Code 等客户端的安装配置片段。

安装

选择你的平台查看安装方式

{
  "mcpServers": {
    "pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "<OPENAI_API_KEY>",
        "PGHOST": "<PGHOST>",
        "PGPORT": "<PGPORT>",
        "PGUSER": "<PGUSER>",
        "PGPASSWORD": "<PGPASSWORD>",
        "PGDATABASE": "<PGDATABASE>"
      }
    }
  }
}

环境变量

OPENAI_API_KEY必填secret

Your API key for text embeddings via OpenAI

PGHOST必填secret

PostgreSQL host to connect to

PGPORT必填secret

PostgreSQL port to connect to

PGUSER必填secret

PostgreSQL user to connect as

PGPASSWORD必填secret

PostgreSQL password to connect with

PGDATABASE必填secret

PostgreSQL database to connect to

DB_SCHEMA可选secret

PostgreSQL database schema to use

OPENAI_API_KEY必填secret

Your API key for text embeddings via OpenAI

PGHOST必填secret

PostgreSQL host to connect to

PGPORT必填secret

PostgreSQL port to connect to

PGUSER必填secret

PostgreSQL user to connect as

PGPASSWORD必填secret

PostgreSQL password to connect with

PGDATABASE必填secret

PostgreSQL database to connect to

DB_SCHEMA可选secret

PostgreSQL database schema to use

相关资源

统一 Manifest

{
  "id": "io.github.timescale/pg-aiguide",
  "type": "mcp-server",
  "version": "0.5.0",
  "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.0",
        "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.0",
        "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"
  }
}
pg-aiguide — MCP Server 安装与配置 · AgentHub