stack-postgres
PostgreSQL relational database — SQL migrations, indexing strategy, parameterized queries, connection pooling
- License 许可
- Apache-2.0
- 最近更新
- 2026-11-15
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- stack-postgres
- license
- Apache-2.0
- metadata
- { "author": "manuel-retamozo-garcia", "version": "1.0" }
- description
- PostgreSQL relational database — SQL migrations, indexing strategy, parameterized queries, connection pooling
- capabilities
- [ "postgres" ]
03 SKILL.md 正文
Critical Rules
- Never write raw SQL strings with string interpolation; always use parameterized queries to prevent SQL injection.
- Ensure every database schema update is managed via explicit, sequential, version-controlled migration scripts.
- Analyze query execution plans using
EXPLAIN ANALYZEbefore creating indexes or writing complex joins. - Create explicit indexes on foreign keys, highly filtered columns, and join criteria to ensure query performance.
- Limit database connections by configuring a connection pooler like PgBouncer or using client-side connection pooling.
04 同仓库更多 Skills
work-unit-commits
Plan commits as reviewable work units. Trigger: implementation, commit splitting, chained PRs, or keeping tests and docs with code.
stack-webmcp
Trigger: WebMCP, document.modelContext, web tools, AI browser agent. Web Model Context Protocol client-side tool standard.
stack-vite
Vite frontend build tool — configuration, plugins, asset loading
stack-starlight
Astro Starlight documentation framework — setup, sidebar navigation, frontmatter, built-in components, asides, theming, i18n, search
stack-sqlserver
Microsoft SQL Server database — indexing, RCSI, set-based operations, SARGable queries, transaction scopes
stack-springboot
Spring Boot architecture patterns — REST API design, layered services, JPA, caching, Spring Security, TDD with MockMvc and Testcontainers, and pre-release verification