AGENT SKILL

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 ANALYZE before 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