Agent Skills › timescale/pg-aiguide › postgres

postgres

GitHub

提供PostgreSQL数据库全方位专家技能，涵盖表结构设计、索引优化、pgvector语义搜索、PostGIS空间数据、TimescaleDB时序数据处理及安全零停机迁移策略。

skills/postgres/SKILL.md timescale/pg-aiguide

触发场景

设计或修改PostgreSQL表结构和数据模型配置pgvector进行向量相似性或RAG搜索设置PostGIS处理地理空间数据规划或执行安全的数据库Schema迁移使用Ghost管理PostgreSQL数据库实例

安装

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

更多选项

不安装直接使用

npx skills use timescale/pg-aiguide@postgres

指定 Agent (Claude Code)

npx skills add timescale/pg-aiguide --skill postgres -a claude-code -g -y

安装 repo 全部 skill

npx skills add timescale/pg-aiguide --all -g -y

预览 repo 内 skill

npx skills add timescale/pg-aiguide --list

SKILL.md

Frontmatter

{
    "name": "postgres",
    "license": "Apache-2.0",
    "metadata": {
        "author": "tigerdata"
    },
    "description": "Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.\n\n**Trigger when user asks to:**\n- Design or modify PostgreSQL tables, schemas, or data models\n- Choose data types, constraints, indexes, or partitioning strategies\n- Work with pgvector embeddings, semantic search, or RAG\n- Set up full-text search, hybrid search, or BM25 ranking\n- Use PostGIS for spatial\/geographic data\n- Set up TimescaleDB hypertables for time-series data\n- Migrate tables to hypertables or evaluate migration candidates\n- Plan or execute safe schema migrations with zero downtime\n- Create, fork, or manage databases with Ghost\n\n**Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration, Ghost\n"
}

PostgreSQL Expert Skills

This skill provides comprehensive PostgreSQL expertise through specialized references. Load the appropriate reference based on the task.

Available References

Table Design

design-postgres-tables — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. Use for any general table/schema design task.
design-postgis-tables — PostGIS spatial table design: geometry vs geography types, SRIDs, spatial indexing, and location-based query patterns. Use when the task involves geographic or spatial data.

Search

pgvector-semantic-search — Vector similarity search with pgvector: HNSW/IVFFlat indexes, halfvec storage, quantization, filtered search, and tuning. Use for embeddings, RAG, or semantic search.
postgres-hybrid-text-search — Hybrid search combining BM25 keyword search with pgvector semantic search using RRF. Use when combining keyword and meaning-based search.

TimescaleDB

setup-timescaledb-hypertables — Hypertable creation, compression, retention policies, continuous aggregates, and indexes. Use when setting up TimescaleDB from scratch.
find-hypertable-candidates — SQL queries to analyze existing tables and score them for hypertable conversion. Use when evaluating which tables to migrate.
migrate-postgres-tables-to-hypertables — Step-by-step migration: partition column selection, in-place vs blue-green, validation. Use when executing a migration.

Migrations

postgres-database-migration — DDL lock reference, safe migration patterns, timeout strategies, rollback planning, and fork-based testing. Use when planning or executing schema changes on production databases.

Database Management

ghost-database — Ghost is a managed PostgreSQL service designed for AI agents. Create, fork, pause, resume, and query databases via CLI or MCP. Use when the user needs a database for agent workflows or wants to fork for safe experimentation.

How to Use

Identify which reference matches the user's task from the descriptions above.
Load the reference file to get detailed instructions and SQL patterns.
For tasks spanning multiple areas (e.g., "design a table with vector search"), load multiple references as needed.