Bolt.newSQLDatabase

Generic Database Rules for Bolt.new

Generic Database Rules adapted for Bolt.new. High-signal generic engineering guidance for real projects.

rules file
# Generic Database Rules for Bolt.new

## Schema
- Every table has primary key, created_at, updated_at.
- Add indexes for foreign keys and frequent filters.
- Model constraints in DB (unique, foreign keys, check constraints).

## Migrations
- Forward-only migrations; never edit applied migration files.
- Pair risky migrations with rollback/runbook notes.
- Backfill large changes in chunks, not one giant lock-heavy operation.

## Query discipline
- Select only required columns.
- Use transactions for multi-step state changes.
- Use explain plans for slow queries before shipping.
#database#sql#migrations#bolt#generic-rules#ai-coding-rules

Related Rules