postgresql
PostgreSQL gotchas and version-gated facts - indexing (B-tree, GIN, GiST, BRIN, partial, expression), JSONB, EXPLAIN ANALYZE and tuning, row-level security and multi-tenancy, full-text search, partitioning, connection pooling, extensions, logical replication, pgvector and RAG. Use when designing tables or indexes for PostgreSQL, writing or reviewing raw SQL, diagnosing a slow query, or choosing a PostgreSQL feature. For EF Core query performance use the optimizing-ef-core-queries skill; for migrations follow the ef-migrations rule.
- License 许可
- MIT
- 最近更新
- 2026-11-10
- Stars
- ★ 2
- Forks
- 1
01 前言 Front Matter
- name
- postgresql
- description
- PostgreSQL gotchas and version-gated facts - indexing (B-tree, GIN, GiST, BRIN, partial, expression), JSONB, EXPLAIN ANALYZE and tuning, row-level security and multi-tenancy, full-text search, partitioning, connection pooling, extensions, logical replication, pgvector and RAG. Use when designing tables or indexes for PostgreSQL, writing or reviewing raw SQL, diagnosing a slow query, or choosing a PostgreSQL feature. For EF Core query performance use the optimizing-ef-core-queries skill; for migrations follow the ef-migrations rule.
02 资源文件 12
- 许可证LICENSE.txt1.1 KB
- 参考文档references/postgresql-advanced-indexing.md2.0 KB
- 参考文档references/postgresql-connection-management.md5.5 KB
- 参考文档references/postgresql-extensions.md2.9 KB
- 参考文档references/postgresql-full-text-search.md5.8 KB
- 参考文档references/postgresql-genai-rag.md3.0 KB
- 参考文档references/postgresql-jsonb-patterns.md1.9 KB
- 参考文档references/postgresql-query-performance.md2.6 KB
- 参考文档references/postgresql-replication.md6.8 KB
- 参考文档references/postgresql-row-level-security.md2.8 KB
- 参考文档references/postgresql-table-partitioning.md3.2 KB
- 参考文档references/postgresql-vector-search.md2.9 KB
03 SKILL.md 正文
PostgreSQL
Each reference lists what models get wrong about one area, with version gates and anti-hallucination rules. Read only the reference that matches the task; read several when the task spans them (a slow JSONB query needs both jsonb-patterns and query-performance).
| Task | Reference |
|---|---|
| Choosing or reviewing an index | references/postgresql-advanced-indexing.md |
Slow query, reading EXPLAIN ANALYZE, server settings |
references/postgresql-query-performance.md |
| JSONB columns, operators, indexing, updates | references/postgresql-jsonb-patterns.md |
| Row-level security, tenant isolation | references/postgresql-row-level-security.md |
Full-text search (tsvector, tsquery, ranking) |
references/postgresql-full-text-search.md |
| Partitioning large tables | references/postgresql-table-partitioning.md |
| Connection pooling, exhaustion, timeouts | references/postgresql-connection-management.md |
| Installing or upgrading extensions | references/postgresql-extensions.md |
| Logical replication | references/postgresql-replication.md |
| Vector similarity search with pgvector | references/postgresql-vector-search.md |
| RAG, hybrid search | references/postgresql-genai-rag.md |
- Check the server version (
SELECT version();) before recommending a version-gated feature. - Schema changes (indexes, extensions, RLS policies, partitions) go through EF Core migrations, raw SQL in
migrationBuilder.Sql(...)where EF has no API, following theef-migrationsrule. Don't apply DDL directly to a database.
04 同仓库更多 Skills
writing-for-agents
Writing documents for agents. Use when creating or editing skills, or modifying AGENTS.md or CLAUDE.md.
tdd
Test-driven development for ASP.NET Core and EF Core with xUnit. Use when building a feature or fixing a bug test-first, when the user mentions TDD or red-green-refactor, or when adding integration tests for endpoints or data access.
retro
Conduct a retrospective on a coding session.
pr
Use when writing a PR body.
improve-codebase-architecture
Scan a codebase for deepening opportunities, present them as a visual HTML report, then grill through whichever one you pick.
handoff
Compact the current conversation into a handoff document for another agent to pick up.