# PostgreSQL & Drizzle ORM Schema Standards

> PostgreSQL and Drizzle ORM standards covering schema definition, indexes, foreign key constraints, connection pooling, and zero-downtime migrations.

Canonical: https://www.agentickit.co/skills/postgres-drizzle
Last updated: 2026-11-18

## Key practices
- Define schemas with strict typing, default timestamps, and explicit foreign keys
- Add B-tree indexes on all filter columns and composite indexes for multi-column queries
- Use drizzle-kit for declarative migrations with automated rollback scripts
- Prevent N+1 query bottlenecks using Drizzle relational query builder

## Related
- [postgres-pro](https://www.agentickit.co/agents/postgres-pro)
- [backend-architect](https://www.agentickit.co/agents/backend-architect)
- [/build-api](https://www.agentickit.co/commands/build-api)
- [/audit](https://www.agentickit.co/commands/audit)
