Build SQLite schemas and migrations
dbsubagentsetup L2★1
Saar45/personal-accounting ↗What it does
Design relational database schemas and optimize query performance
Best for
Data-intensive applications that need optimal schema design and query tuning from first principles.
Inputs
- · data model
- · access patterns
- · query logs
- · normalization requirements
Outputs
- · schema design
- · index recommendations
- · query optimizations
- · migration scripts
Requires
- · SQL database
- · query analyzer
- · schema migration tool
Preconditions
database running, query logs available, schema versioning in place
Failure modes
- · denormalization mistakes
- · missing indexes
- · N+1 queries
- · data integrity violations
Trust signals
- · analyzes query patterns
- · includes normalization justification
- · provides index strategy