原型 · 预览版:收录官方注册中心里的全部服务器,每 30 分钟同步一次。使用 Google 登录即可撰写评价。原型 · 每 30 分钟更新
PopNx MCP为使用 AI 的人准备的 MCP 服务器 · 用大白话讲清楚

pg-aiguide Skill

代码仓库 ↗

同一项目也有 MCP 版本 →

作者:timescale★ 1,886 (whole repo)10 个 skill

★ Stars are for the whole repo, not each skill

Pick the skill to install

What it does

This repo is a collection of 10 skills

  • Connects Instruction files the AI reads, with steps that call an outside service
  • Account or key Some steps need a key for OpenAI, OPENROUTER_API_KEY (per the README)
  • Category 写代码
Maker’s original description
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
给作者:在 README 中加徽章

如果你是作者,可把这段代码贴到 README。徽章会链接回本页。

[![Featured on PopNx MCP](https://mcp.popnx.com/badge/skill/timescale-pg-aiguide.svg)](https://mcp.popnx.com/en/skills/timescale-pg-aiguide)

可搭配使用

在同一工作中把 AI 连到服务的 MCP

REA

Reverse engineer anything from your terminal or agent with one CLI and MCP server.

作者:morluto广泛使用↓ 38.9万/周★ 46.6万6天前更新

MCP · 连接服务在你的电脑上运行

Fallow

Codebase intelligence for TypeScript and JavaScript, exposed as structured MCP analysis tools.

作者:fallow-rs广泛使用↓ 244.1万/周★ 5379昨天更新

MCP · 连接服务在你的电脑上运行

Desktop Commander

MCP server for terminal commands, file operations, and process management

作者:wonderwhy-er广泛使用↓ 74万/周★ 1万6天前更新

MCP · 连接服务在你的电脑上运行

相似的 Skill

同类工作,排序与 Skill 列表相同

与相似项目对比
本项
pg-aiguide
reaandrej-karpathy-skillsgraphifyMoneyPrinterTurbo
作者timescalemorlutomultica-aiGraphify-Labsharry0703
Skill 数101111
GitHub 星标1,886465,460233,910149,364144,149
最近代码更新2026年11月16日2026年11月17日2026年4月20日2026年11月17日2026年11月17日
许可证Apache-2.0MIT–Apache-2.0MIT

timescale 提供的 10 个 Skill(指令集),AI 读取后照做 · 不是 MCP server

Pick the skill to install

Install only the ones you use. Open a skill to see how to install it

Install the whole set (10)

If you want every one, let the AI install them in one go. Know 2 things first

  • Every installed skill’s description is loaded into every chat. The more you install, the easier it is for the AI to pick the wrong one
  • Some skills duplicate tools the AI already has built in. Installing only the ones you use works better
Where to install
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, for all my projects, putting each at ~/.claude/skills/<skill name> (in Codex use ~/.agents/skills/<skill name>, in Cursor ~/.cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the full path you will install each one to and wait for me to agree.
Please install all 10 skills from https://github.com/timescale/pg-aiguide: design-postgis-tables, design-postgres-tables, find-hypertable-candidates, ghost-database, migrate-postgres-tables-to-hypertables, pgvector-semantic-search, postgres, postgres-database-migration, postgres-hybrid-text-search, setup-timescaledb-hypertables, into the project this chat is open in (at .claude/skills/<skill name>; in Codex use .agents/skills/<skill name>, in Cursor .cursor/skills/<skill name>). Folders in the repo: design-postgis-tables = skills/design-postgis-tables · design-postgres-tables = skills/design-postgres-tables · find-hypertable-candidates = skills/find-hypertable-candidates · ghost-database = skills/ghost-database · migrate-postgres-tables-to-hypertables = skills/migrate-postgres-tables-to-hypertables · pgvector-semantic-search = skills/pgvector-semantic-search · postgres = skills/postgres · postgres-database-migration = skills/postgres-database-migration · postgres-hybrid-text-search = skills/postgres-hybrid-text-search · setup-timescaledb-hypertables = skills/setup-timescaledb-hypertables. First show me every file and tell me whether any has scripts or changes machine settings, then tell me the project name and the full path you will install each one to and wait for me to agree.

Uploading to Claude on the web and apps: you need 10 uploads, one ZIP per skill. Open each skill in the list below to download it

Checked against official docs 2026年11月12日 · Source: support.claude.com, code.claude.com, learn.chatgpt.com, cursor.com

  • design-postgis-tables

    Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

  • design-postgres-tables

    Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference…

  • find-hypertable-candidates

    Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - E…

  • ghost-database

    No description from the maker

  • migrate-postgres-tables-to-hypertables

    Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migratio…

  • pgvector-semantic-search

    Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search. **Trigger when user asks to:** - Store or search vector embeddings in PostgreSQL - Set up semantic search, similarity search, or nearest neighbor search - Create HNSW or…

  • postgres

    Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or mo…

  • postgres-database-migration

    Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases. **Trigger when user asks to:** - Test a schema migration before applying it to production - Add, remove, or rename columns safely on a live tab…

  • postgres-hybrid-text-search

    Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector toge…

  • setup-timescaledb-hypertables

    Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. Use this to improve the performance of any insert-heavy table. **Trigger when user asks to:** - Create or design SQL schemas/…

Skill 和 MCP 有什么不同

MCP = 手

把 AI 连到外部服务或数据,例如读取 Notion 或开发票。需要有程序或服务器在运行。

Skill = 手册

教 AI 怎么做某项工作的文本文件,不连接任何服务。

有些会重叠:少数 Skill 带有调用工具的脚本,少数 MCP 只提供知识。请从你想完成的工作出发。

适用的应用

Claude CodeCodexCursorGemini CLIWindsurfOpenCode

依据开发者 README 和 repo 中的文件夹

安装

Pick a skill first

This repo has 10 skills. Pick one from the list above; its page shows every way to install it, including letting the AI install it and a ZIP

Let the AI install it
Upload to claude.ai

Go to the skill list ↑

The maker’s command installs the whole set of 10
安装 Node.js(如果还没有)

已经装好了吗?先检查 · 打开终端,输入这条命令后按 Enter

node -v
  • 显示版本号(例如 v26.13.1)= 已安装,可跳过这一步
  • 显示 "command not found"(Windows 显示 "is not recognized")= 还没安装,或刚装好但需要关掉终端再重新打开
怎么打开终端

Mac:按 ⌘ + Space,输入 Terminal 后按 Enter

Windows:打开“开始”菜单,输入 Windows PowerShell,然后选“打开”

还没安装: 打开官方下载页,选择 LTS 版本和点选式安装程序:Mac 用 .pkg · Windows 用 .msi。双击后一路下一步即可,不需要 curl 命令

打开 Node.js 下载页 ↗

装好后关掉终端再打开,重新运行同一条命令,应显示版本号: node -v

安装一次,所有需要 Node.js 的工具都能用

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

摘自开发者 README,会下载并运行开发者的代码

讨论

提问、分享技巧或报告无法使用。按“有帮助”数量排序。

还没有帖子,欢迎第一个提问或分享。

此处内容由用户撰写,不代表 PopNx 团队。

登录后发帖

来自 GitHub

GitHub 星标
1,886
Stars are for the whole repo, not each skill
开发者
timescale
许可证
Apache-2.0
最近代码更新
2026年11月16日
repo 中的 SKILL.md 文件(含译本和模板)
10
主题
ai, ai-agents, ai-coding, claude-code-plugin, claude-code-plugins, claude-code-plugins-marketplace, claude-marketplace, claude-plugin, claude-skills, docs, documentation, mcp