Database

Database & Persistence

Use this skill when creating or modifying database schemas, Drizzle definitions, migrations, queries, or persistence logic.

PostgreSQL

PostgreSQL is the system of record.

Store core business state in relational columns.

Use JSONB selectively for:

• raw provider payloads
• extraction outputs
• generated machine-readable artifacts

Do not hide important queried business fields in JSONB.

• Paginate list queries.
• Avoid unbounded reads.
• Add indexes intentionally for foreign keys and common filters.
• Use transactions for multistep domain writes.

Drizzle ORM

Use Drizzle schema as the authoritative schema definition.

• Keep schema definitions explicit and readable.
• Use domain-aligned table and column names.
• Prefer junction tables for many-to-many relationships.
• Include standard timestamps consistently.