postgres
聚合多份实用参考，适合数据库开发、优化与运维的日常问题。
提供全面的 PostgreSQL 专家参考，涵盖表设计、索引、扩展与迁移。
帮你把 PostgreSQL 表和索引设计好，选数据类型、约束和分区，还能配置 pgvector 向量检索、PostGIS 空间数据或 TimescaleDB 时序表。适合建模、做全文/语义搜索、RAG 场景或规划线上迁移时使用。特别之处是兼顾性能优化、BM25/混合搜索策略和零停机迁移的实战建议。
▸ 展开 SKILL.md 英文原文
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:** - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search, hybrid search, or BM25 ranking - Use PostGIS for spatial/geographic data - Set up TimescaleDB hypertables for time-series data - Migrate tables to hypertables or evaluate migration candidates - Plan or execute safe schema migrations with zero downtime - Create, fork, or manage databases with Ghost **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration, Ghost
帮我安装这个 skill：https://raw.githubusercontent.com/timescale/pg-aiguide/main/skills/postgres/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/timescale/pg-aiguide/main/skills/postgres/SKILL.md"# 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](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-sem