# 安装 io.github.timescale/pg-aiguide

- 类型: MCP 工具
- 说明: 提供 PostgreSQL 文档、生态工具与最佳实践查询，辅助开发与运维决策。
- 仓库: https://github.com/timescale/pg-aiguide

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "io.github.timescale/pg-aiguide" MCP 服务：
执行：claude mcp add 'io-github-timescale-pg-aiguide' -- npx -y @tigerdata/pg-aiguide
```

### Codex
```
请帮我安装 askskill 上的 "io.github.timescale/pg-aiguide" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-timescale-pg-aiguide]
command = "npx"
args = ["-y","@tigerdata/pg-aiguide"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "io.github.timescale/pg-aiguide" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-timescale-pg-aiguide": { "command": "npx", "args": ["-y","@tigerdata/pg-aiguide"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env OPENAI_API_KEY=YOUR_VALUE --env PGHOST=YOUR_VALUE --env PGPORT=YOUR_VALUE --env PGUSER=YOUR_VALUE --env PGPASSWORD=YOUR_VALUE --env PGDATABASE=YOUR_VALUE --env DB_SCHEMA=YOUR_VALUE --transport stdio io-github-timescale-pg-aiguide -- npx -y @tigerdata/pg-aiguide
```
需要环境变量：OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA

### Codex
```bash
codex mcp add --env OPENAI_API_KEY=YOUR_VALUE --env PGHOST=YOUR_VALUE --env PGPORT=YOUR_VALUE --env PGUSER=YOUR_VALUE --env PGPASSWORD=YOUR_VALUE --env PGDATABASE=YOUR_VALUE --env DB_SCHEMA=YOUR_VALUE io-github-timescale-pg-aiguide -- npx -y @tigerdata/pg-aiguide
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-timescale-pg-aiguide]
command = "npx"
args = ["-y","@tigerdata/pg-aiguide"]

[mcp_servers.io-github-timescale-pg-aiguide.env]
OPENAI_API_KEY = "YOUR_VALUE"
PGHOST = "YOUR_VALUE"
PGPORT = "YOUR_VALUE"
PGUSER = "YOUR_VALUE"
PGPASSWORD = "YOUR_VALUE"
PGDATABASE = "YOUR_VALUE"
DB_SCHEMA = "YOUR_VALUE"
```
需要环境变量：OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-timescale-pg-aiguide": {
      "command": "npx",
      "args": [
        "-y",
        "@tigerdata/pg-aiguide"
      ],
      "env": {
        "OPENAI_API_KEY": "YOUR_VALUE",
        "PGHOST": "YOUR_VALUE",
        "PGPORT": "YOUR_VALUE",
        "PGUSER": "YOUR_VALUE",
        "PGPASSWORD": "YOUR_VALUE",
        "PGDATABASE": "YOUR_VALUE",
        "DB_SCHEMA": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-timescale-pg-aiguide&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIkB0aWdlcmRhdGEvcGctYWlndWlkZSJdLCJlbnYiOnsiT1BFTkFJX0FQSV9LRVkiOiJZT1VSX1ZBTFVFIiwiUEdIT1NUIjoiWU9VUl9WQUxVRSIsIlBHUE9SVCI6IllPVVJfVkFMVUUiLCJQR1VTRVIiOiJZT1VSX1ZBTFVFIiwiUEdQQVNTV09SRCI6IllPVVJfVkFMVUUiLCJQR0RBVEFCQVNFIjoiWU9VUl9WQUxVRSIsIkRCX1NDSEVNQSI6IllPVVJfVkFMVUUifX0
需要环境变量：OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA