timescale/pg-aiguide

postgres

Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.

查看源码

使用方法

  1. 复制安装命令,在自己的智能体环境安装前先检查源码包。
  2. 从原始文档核对所需工具、凭据和支持的宿主。
  3. 说明输入材料与期望交付物,并对照来源检查输出。
npx skills add https://github.com/timescale/pg-aiguide --skill postgres

开始前需了解

  • 安装不包含模型订阅、API 额度或访问文件的权限。
  • 仓库星数和安装量反映活跃情况,不等于独立质量或安全测试。
仓库原始内容

按源仓库内容呈现,保留标题、案例、代码、表格、链接以及原文引用的演示图片。

PostgreSQL Expert Skills

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

Available References

Existing Databases

  • [schema-exploration](references/schema-exploration/guide.md) — Read-only, question-driven exploration of schemas, tables, views, routines, triggers, RLS, and extensions using pg_catalog. Use to understand an existing database before designing changes or writing queries.

Table Design

  • [design-postgres-tables](references/design-postgres-tables.md) — Data types, constraints, indexes, JSONB patterns, partitioning, and PostgreSQL best practices. Use for any general table/schema design task.
  • [design-postgis-tables](references/design-postgis-tables.md) — 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](references/pgvector-semantic-search.md) — 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](references/postgres-hybrid-text-search.md) — Hybrid search combining BM25 keyword search with pgvector semantic search using RRF. Use when combining keyword and meaning-based search.

TimescaleDB

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

Migrations

  • [postgres-database-migration](references/postgres-database-migration.md) — DDL lock reference, safe migration patterns, timeout strategies, rollback planning, and fork-based testing. Use when planning or executing schema changes on production databases.

How to Use

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

按任务相关推荐

来自同一仓库

更多 Skills

全部 Skills
timescale
社区

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/tables AND Timescale/TimescaleDB/TigerData/Tiger Cloud is available - Set up hypertables, compression, retention policies, or continuous aggregates - Configure partition columns, segmentby, orderby, or chu

1小时安装量
1
GitHub Stars
1886
最近更新
11月18日
timescale
社区

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 table - Change a column's data type without downtime - Add or drop indexes, constraints, or foreign keys on large tables - Understand which ALTER TABLE operations lock the table - Roll back a failed migration

1小时安装量
1
GitHub Stars
1867
最近更新
10月7日
timescale
社区

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 IVFFlat indexes for vectors - Implement RAG (Retrieval Augmented Generation) with PostgreSQL - Optimize pgvector performance, recall, or memory usage - Use binary quantization for large vector datasets Key

1小时安装量
2
GitHub Stars
1837
最近更新
9月15日