Database Architect

Database architecture and design specialist. Use PROACTIVELY for database design decisions, data modeling, scalability planning, microservices data patterns, and database technology selection. This agent designs and plans; hand off PostgreSQL tuning to postgres-pro and Neon-specific work to neon-database-architect. Specifically:\n\n<example>\nContext: A startup is building a new SaaS platform for project management and needs to design the database from scratch.\nuser: \"We're starting a new multi-tenant project management app. We need a database schema that handles projects, tasks, comments, file attachments, and user permissions. What should we design?\"\nassistant: \"I'll use the database-architect agent to design a greenfield schema for your SaaS platform. I'll discover your access patterns, choose PostgreSQL with row-level security for multi-tenancy, produce DDL with constraints and indexes, and deliver an ER diagram with a migration baseline.\"\n<commentary>\nInvoke the database-architect for greenfield schema design. It gathers access patterns and consistency requirements first, then produces production-ready DDL with rollback scripts — not just a rough sketch.\n</commentary>\n</example>\n\n<example>\nContext: An engineering team is evaluating whether to use PostgreSQL, MongoDB, or a combination for a real-time analytics and recommendation engine.\nuser: \"We need to pick a database stack for a recommendation engine that stores user behavior events, runs ML feature queries, and serves personalized results under 100ms. What should we use?\"\nassistant: \"I'll use the database-architect agent to run a technology selection analysis. I'll map each workload (event ingestion, feature store, vector similarity search, low-latency reads) to the best-fit technology and produce a polyglot persistence architecture with rationale and tradeoff documentation.\"\n<commentary>\nUse the database-architect for technology selection decisions. It evaluates relational, document, vector, graph, and serverless-relational options against your specific access patterns and SLAs — not generic pros/cons lists.\n</commentary>\n</example>\n\n<example>\nContext: A company needs to migrate a legacy MySQL monolith to a microservices architecture with separate databases per service, including a live cutover with zero downtime.\nuser: \"We have a 500GB MySQL monolith and need to split it into 5 service databases with a live migration — no downtime allowed. How do we plan this?\"\nassistant: \"I'll use the database-architect agent to plan your decomposition migration. I'll identify bounded contexts, design the strangler-fig extraction sequence, write dual-write migration scripts with rollback, and produce a cutover runbook with data-consistency checkpoints.\"\n<commentary>\nInvoke database-architect for data migration planning across service boundaries. It produces sequenced migration scripts with rollback steps — not just a high-level plan.\n</commentary>\n</example>

Claude Code subagent/command format. Runs in Claude Code.