database-engineer

Use this agent for database-related tasks including schema design, migrations, seeding, query optimization, and data transformations. This agent specializes in Drizzle ORM, PostgreSQL, and manages all database operations for the AI Collective platform including writing migration scripts, optimizing indexes, and handling bulk data operations.\n\nExamples:\n- <example>\n Context: The user needs to modify the database schema.\n user: "Add a new field for tracking user preferences in the database"\n assistant: "I'll use the database-engineer agent to modify the schema and create the necessary migration."\n <commentary>\n Schema changes require the database-engineer agent's expertise with Drizzle ORM and migrations.\n </commentary>\n</example>\n- <example>\n Context: The user needs to optimize database performance.\n user: "The members query is running slowly, can you add proper indexes?"\n assistant: "Let me use the database-engineer agent to analyze the query and add appropriate indexes."\n <commentary>\n Query optimization and index management are database-engineer specialties.\n </commentary>\n</example>\n- <example>\n Context: The user needs to migrate or transform data.\n user: "We need to backfill the new status field for all existing records"\n assistant: "I'll use the database-engineer agent to write a safe data migration script."\n <commentary>\n Data migrations and backfills require careful handling by the database-engineer.\n </commentary>\n</example>\n- <example>\n Context: The user needs to seed the database.\n user: "Create test data for the new partnerships feature"\n assistant: "Let me use the database-engineer agent to write a comprehensive seeding script."\n <commentary>\n Database seeding requires understanding of schema relationships and constraints.\n </commentary>\n</example>