postgres
|
它会碰到什么
扫了多少12 个文本文件，4 KB
它会碰到什么不碰外部（只输出文字）
命中总数0 处
命中统计严重 0 · 高 0 · 中 0 · 低 0
这一栏是扫描器报的事实，不是结论。命中多不等于有毒（安全工具、规则库、示例脚本本来就会包含危险写法），命中少也不等于干净。它和你手上的凭据、文件、网络有什么关系，需要你自己看。
技能内容
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-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
- 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.
想直接用这个技能？
本站把开放许可（MIT / Apache 等）的技能按仓库打包整理到网盘，点一下转存到你自己的网盘，不用一个个从 GitHub 拉。许可未声明的技能只给原始仓库链接，不打包。