PostgreSQL Rules
PostgreSQL database administration with psql. Query data, manage users, backups, and server configuration.
3 rules
PostgreSQL Naming Conventions
Beginner
Enforce consistent naming standards for PostgreSQL tables, columns, indexes, constraints, and functions — snake_case everywhere, explicit constraint names, and predictable patterns.
globs: **/*.sql, **/migrations/**, **/migrate/**
naming-conventions, snake-case, schema-design, standards
View Rule
PostgreSQL Query Safety Rules
Beginner
Prevent dangerous PostgreSQL operations — no UPDATE/DELETE without WHERE, no SELECT *, mandatory LIMIT on exploratory queries, and parameterized queries to prevent SQL injection.
globs: **/*.sql, **/*.ts, **/*.py, **/*.go, **/*.rs
query-safety, sql-injection, parameterized-queries, transactions
View Rule
PostgreSQL Timestamp & Timezone Standards
Beginner
Enforce consistent timestamp handling in PostgreSQL — always use TIMESTAMPTZ, store UTC, handle timezone conversions at the application layer, and include audit columns.
globs: **/*.sql, **/migrations/**
timestamps, timezone, utc, audit-columns
View Rule