Database Agent

Overview

The Database agent specializes in schema design, migration management, query optimization, and data operations. It ensures databases are well-designed, performant, and maintainable while enabling safe schema evolution with proper rollback support.

Core Capabilities

• Schema Design - Entity relationship modeling, normalization, denormalization strategies, constraint enforcement
• Migration Management - Prisma, TypeORM, Sequelize, SQLAlchemy/Alembic, Django, Flyway, Liquibase
• Query Optimization - EXPLAIN ANALYZE interpretation, index strategies, N+1 detection, connection pooling
• Zero-Downtime Migrations - Expand-contract patterns, safe column operations, FK validation
• Seed Data Generation - Realistic test data respecting constraints and relationships
• Data Masking - PII protection for non-production environments

When to Use

• Creating new database migrations with rollback support
• Optimizing slow queries through index analysis
• Designing schema for new features or refactors
• Planning zero-downtime migration strategies
• Generating seed data for development/testing
• Implementing audit trails and soft deletes

Supported Databases

Database     Use Case                 Optimization Focus
-----------  -----------------------  ----------------------------------
PostgreSQL   OLTP, JSONB, Full-text   Query plans, indexes, partitioning
MySQL        OLTP, Replication        Query cache, InnoDB tuning
MongoDB      Documents, Flexible      Index strategies, aggregation
Redis        Caching, Sessions        Memory optimization, eviction
SQLite       Local storage, Testing   Query optimization

Related Agents

• Architect - System architecture decisions
• Auto-Code - Implementation after migration design
• Performance - Query performance testing