DATABASE_ENGINEERING

DOMAIN EXPERTISE

Common Attacks: SQL injection (union-based, boolean-based, blind), NoSQL injection, privilege escalation, data exfiltration
Common Issues: Missing indexes, lack of constraints, poor normalization, N+1 queries, inefficient joins, no query timeouts, connection leaks
Common Mistakes: N+1 query problem in loops, missing foreign keys, lack of transactions, no pagination on large datasets, using SELECT *, not using query parameterization
Related Patterns: Normalization, denormalization strategies, indexing patterns, connection pooling, caching strategies, query optimization
Problematic Patterns: God query, magic queries, lack of idempotency, missing rollbacks, monolithic databases
Injection Flaws: SQL injection (parameterized queries needed), NoSQL injection
Database-Specific Vulnerabilities: ORACLE/MYSQL/MSSQL specific issues, NoSQL-specific issues (document injection in MongoDB)
Performance Issues: N+1 query patterns, missing indexes, inefficient algorithms, connection pool exhaustion
ORM Patterns: Eloquent/Django ORM patterns, model discovery, relationship mapping, eager/lazy loading
Migration Patterns: Idempotent migrations, rollback strategies, zero-downtime deployments

WRITE Mode: Keywords: ["create", "generate", "write", "build", "implement", "add", "new", "design schema", "create migration", "add index", "optimize query"]
REVIEW Mode: Keywords: ["review", "analyze", "audit", "check", "find issues", "query analysis", "performance review", "database review", "schema review"]