Pg Aiguide

Name: Pg Aiguide
Author: timescale

作者：timescale版本 0.6.1i★ –i电脑或云端

注册名称io.github.timescale/pg-aiguide

安装

概览

作者提供的说明（英文原文）

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

PopNx MCP 的三大支柱

这三项永远不会合并成一个分数：意见、测量和人气是不同的东西。

用户评价i暂无评价评价功能将在后续阶段与账户功能一起开放
我们的基础检查i1 项中通过 1 项依据公开信息检查；尚未扫描代码
使用情况i尚未统计★ –

它能帮你做什么

我们还没有为它写通俗的介绍。下面是我们从注册中心读取到的事实。

连接方式: 电脑或云端
传输方式: stdio, Streamable HTTP
分类: 数据库与数据集
你需要填写：OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA

安装

选择你使用的 AI 应用，然后复制设置。

安装之前

基础检查：1 项中通过 1 项
在作者的服务器上运行：你向它提出的内容会经过他们的服务器。
需要你自己填写： OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA

标为机密的值是你账户的钥匙。千万不要分享给别人，也不要粘贴到聊天里。

你需要

在云端运行无需安装任何东西，通过互联网连接
npm已安装 Node.js（用于 npx 命令）

你用的是哪个应用？

ClaudeClaude CodeCursorVS CodeChatGPT

在上方选择你的应用。我们会记住它，下次按钮会显示“安装到 …”。

适用于网页版、桌面版和手机版 Claude：

打开 Settings → Connectors
点击 Add custom connector
粘贴下面的地址，然后点击 Add
如果要求登录，请登录作者的服务

https://mcp.tigerdata.com/docs

或者在你的电脑上运行

打开 Claude Desktop → Settings → Developer → Edit Config，把下面的内容粘贴到 claude_desktop_config.json

{
  "mcpServers": {
    "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"
      }
    }
  }
}

在终端中运行这条命令

claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs

或者在你的电脑上运行

claude mcp add pg-aiguide --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 -- npx -y @tigerdata/pg-aiguide

运行前请先填写空着的值。

在 Cursor 中打开

或者自己复制设置

粘贴到项目中的 .cursor/mcp.json，或 ~/.cursor/mcp.json

{
  "mcpServers": {
    "pg-aiguide": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

或者在你的电脑上运行

在 Cursor 中打开

或者自己复制设置

粘贴到项目中的 .cursor/mcp.json，或 ~/.cursor/mcp.json

{
  "mcpServers": {
    "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"
      }
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

在 VS Code 中打开

或者自己复制设置

粘贴到项目中的 .vscode/mcp.json

{
  "servers": {
    "pg-aiguide": {
      "type": "http",
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

或者在你的电脑上运行

在 VS Code 中打开

或者自己复制设置

粘贴到项目中的 .vscode/mcp.json

{
  "servers": {
    "pg-aiguide": {
      "type": "stdio",
      "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"
      }
    }
  }
}

浏览器会先询问是否打开应用，然后应用会显示设置并请你确认。密钥的值会留空，由你自己填写。

ChatGPT 只能连接互联网上的服务器：

打开网页版 ChatGPT → Settings → Connectors (Apps)
点击 Create 或 Add（部分套餐需要先在 Advanced 中开启 Developer mode）
粘贴下面的地址，起个名字，然后保存
如果要求登录，请登录作者的服务

https://mcp.tigerdata.com/docs

菜单名称可能因套餐和版本不同而略有差异。

你的选择通过 Cookie 保存在这台设备上，无需账户。

需要你填写的值

OPENAI_API_KEY 机密必填 env
Your API key for text embeddings via OpenAI
PGHOST 机密必填 env
PostgreSQL host to connect to
PGPORT 机密必填 env
PostgreSQL port to connect to
PGUSER 机密必填 env
PostgreSQL user to connect as
PGPASSWORD 机密必填 env
PostgreSQL password to connect with
PGDATABASE 机密必填 env
PostgreSQL database to connect to
DB_SCHEMA 机密 env
PostgreSQL database schema to use

这些设置是根据作者在注册中心的条目生成的。如果 README 的写法不同，请以 README 为准。

它能做什么

我们还没有读取这个服务器的工具列表；我们会轮流检查各个端点。

基础检查i

我们检查的是任何人都能看到的信息；我们没有阅读代码。不适用的检查项不计入总数。 · 检查于 2026年11月7日

✓ 通过
作者与仓库一致
注册名称已通过 GitHub 账户 timescale 验证，该账户拥有此仓库
… 尚未检查
仍在维护
我们还没有从 GitHub 读取这个仓库
… 尚未检查
有许可证
我们还没有从 GitHub 读取这个仓库
… 尚未检查
端点有响应
尚未检查；我们会轮流检查各个端点
… 尚未检查
使用 OAuth 登录
尚未检查；我们会轮流检查各个端点
… 尚未检查
工具描述中没有隐藏指令
尚未检查；我们会在检查端点时读取工具列表

与“数据库与数据集”中的其他服务器比较i

星标数多于此分类中其他 954 个服务器的 0%
发布到注册中心的时间比此分类中其他 954 个服务器的 31% 更新
基础检查结果等于或优于此分类中其他 954 个服务器的 100%

与注册中心里这个分类中所有活跃的服务器比较。只有当发布者拥有该仓库时，星标数才计入。

常见问题

Pg Aiguide 安全吗？

它在 1 项适用的基础检查中通过了 1 项。我们没有阅读代码。在添加密钥或令牌之前，请先看看这个服务器要求哪些权限，并使用只具备所需权限的密钥。

它需要哪些密钥或代码？

你需要填写：OPENAI_API_KEY, PGHOST, PGPORT, PGUSER, PGPASSWORD, PGDATABASE, DB_SCHEMA

它在我的电脑上运行还是在云端？

两种方式都可以：安装在你的电脑上，或者连接云端版本。

它还在维护吗？

GitHub 仓库最后更新于–，最新版本（0.6.1）于2个月前进入注册中心。

哪些应用可以使用它？

支持 MCP 的应用，例如 Claude Desktop、Claude Code、Cursor 和 VS Code。它通过 URL 连接，所以接受远程 MCP 服务器的应用也可以使用，例如开启开发者模式的 ChatGPT。

有什么可以替代它？

同一分类中有：Supabase, MongoDB MCP Server, Elasticsearch MCP Server

替代选择

同一分类中其他作者的服务器，按星标数排序。

如何看卡片：★ GitHub 星标i三大支柱：评价 · 检查 · 使用情况i更新 = 最新版本发布到注册中心的时间i

Supabase

作者：supabase

MCP server for interacting with the Supabase platform

电脑或云端★ 2,993Apache-2.0昨天更新

安装

MongoDB MCP Server

作者：mongodb-js

MongoDB Model Context Protocol Server

在你的电脑上运行★ 1,157Apache-2.0前天更新

安装

Elasticsearch MCP Server

作者：cr7258

MCP server for interacting with Elasticsearch

在你的电脑上运行★ 315Apache-2.014个月前更新

安装

作者的 README

打开 README

按原文从作者的仓库复制。PopNx MCP 没有审查或背书其内容。HTML、图片和脚本已被移除。链接会离开本站。

pg-aiguide

AI-optimized PostgreSQL expertise for coding assistants

pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:

Semantic search across the official PostgreSQL manual (version-aware)
AI-optimized “skills” — curated, opinionated Postgres best practices used automatically by AI agents
Extension ecosystem docs, starting with TimescaleDB, with more coming soon

Use it as:

Agent Skills via npx skills — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents
a public MCP server that can be used with any AI coding agent, or
a Claude Code plugin optimized for use with Claude's native skill support.

⭐ Why pg-aiguide?

AI coding tools often generate Postgres code that is:

outdated
missing constraints and indexes
unaware of modern PG features
inconsistent with real-world best practices

pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.

See the difference

https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d

Video Transcript

Prompt given to Claude Code:

Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.

Result (summarized):

4× more constraints
55% more indexes (including partial/expression indexes)
PG17-recommended patterns
Modern features (GENERATED ALWAYS AS IDENTITY, NULLS NOT DISTINCT)
Cleaner naming & documentation

Conclusion: _pg-aiguide produces more robust, performant, maintainable schemas._

🚀 Quickstart

Agent Skills

Install curated PostgreSQL best-practice skills for your AI coding agent:

npx skills add timescale/pg-aiguide --skill postgres

Or install the schema exploration skill to investigate an existing PostgreSQL database:

npx skills add timescale/pg-aiguide --skill schema-exploration

Or pick individual skills interactively:

npx skills add timescale/pg-aiguide

Works with Claude Code, Cursor, Codex, Gemini CLI, VS Code, and 40+ other agents.

For even deeper PostgreSQL knowledge, also add the MCP server to give your agent semantic search over the official PostgreSQL, TimescaleDB, and PostGIS manuals.

MCP Server

For semantic search over PostgreSQL, TimescaleDB, and PostGIS documentation, add the public MCP server:

https://mcp.tigerdata.com/docs

Manual MCP configuration using JSON

"mcpServers": { "pg-aiguide": { "url": "https://mcp.tigerdata.com/docs" } } }

Or it can be used as a Claude Code Plugin:

claude plugin marketplace add timescale/pg-aiguide

claude plugin install pg@aiguide

Install by environment

Claude Code

This repo serves as a claude code marketplace plugin. To install, run:

claude plugin marketplace add timescale/pg-aiguide

claude plugin install pg@aiguide

This plugin uses the skills available in the skills directory as well as our publicly available MCP server endpoint hosted by TigerData for searching PostgreSQL documentation.

Codex

Run the following to add the MCP server to codex:

codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguide

Cursor

One-click install:

Or add the following to .cursor/mcp.json

"mcpServers": { "pg-aiguide": { "url": "https://mcp.tigerdata.com/docs" } } }

Gemini CLI

Run the following to add the MCP server to Gemini CLI:

gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t http

OpenCode

Add the following to your global OpenCode config file (~/.config/opencode/opencode.json), or to a project level opencode.json. See the OpenCode config docs for more about file locations, and the MCP server docs for more about the mcp options.

"$schema": "https://opencode.ai/config.json", "mcp": { "pg-aiguide": { "type": "remote", "url": "https://mcp.tigerdata.com/docs" } } }

Add use pg-aiguide to your prompts to use the pg-aiguide tools.

Visual Studio

Click the button to install:

VS Code

Click the button to install:

Alternatively, run the following to add the MCP server to VS Code:

code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'

VS Code Insiders

Click the button to install:

Alternatively, run the following to add the MCP server to VS Code Insiders:

code-insiders --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'

Windsurf

Add the following to ~/.codeium/windsurf/mcp_config.json

"mcpServers": { "pg-aiguide": { "serverUrl": "https://mcp.tigerdata.com/docs" } } }

💡 Your First Prompt

Once installed, pg-aiguide can answer Postgres questions or design schemas.

Simple schema example prompt

Create a Postgres table schema for storing usernames and unique email addresses.

Complex schema example prompt

You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company.

The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as

the main data points as well as other measurements that vary from device to device. Each device has a unique id

and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data

includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.

Features

Documentation Search (MCP Tools)

`search_docs` Unified search tool supporting semantic (vector similarity) and keyword (BM25) search across multiple documentation sources:
postgres - Official PostgreSQL manual, scoped by version
tiger - Tiger Data's documentation (TimescaleDB and ecosystem)
postgis - PostGIS spatial extension documentation

Skills (AI-Optimized Best Practices)

[`view_skill`](API.md#view_skill) Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.

These skills provide guidance on:

Exploring existing PostgreSQL schemas and objects
Schema design
Indexing strategies
Data types
Data integrity and constraints
Naming conventions
Performance tuning
Modern PostgreSQL features

🔌 Ecosystem Documentation

Supported today:

TimescaleDB (docs + skills)
PostGIS (docs)

Coming soon:

pgvector

We welcome contributions for additional extensions and tools.

🛠 Development

See DEVELOPMENT.md for:

running the MCP server locally
adding new skills
adding new docs

🤝 Contributing

We welcome:

new Postgres best-practice skills
additional documentation corpora
search quality improvements
bug reports and feature ideas

📄 License

Apache 2.0

Pg Aiguide

概览

PopNx MCP 的三大支柱

它能帮你做什么

安装

安装之前

或者在你的电脑上运行

或者在你的电脑上运行

或者在你的电脑上运行

或者在你的电脑上运行

需要你填写的值

它能做什么

基础检查i

作者与仓库一致

仍在维护

有许可证

端点有响应

使用 OAuth 登录

工具描述中没有隐藏指令

与“数据库与数据集”中的其他服务器比较i

常见问题

替代选择

Supabase

MongoDB MCP Server

Elasticsearch MCP Server

作者的 README

pg-aiguide

⭐ Why pg-aiguide?

See the difference

🚀 Quickstart

Agent Skills

MCP Server

Install by environment

💡 Your First Prompt

Features

Documentation Search (MCP Tools)

Skills (AI-Optimized Best Practices)

🔌 Ecosystem Documentation

🛠 Development

🤝 Contributing

📄 License