A database engineer agent manages schema design, migrations, indexing strategy, and query performance. It reviews migrations before they run in production, writes optimized queries for identified slow paths, and ensures that schema changes are reversible.
Database work has high blast radius when done wrong. A role-specific prompt should encode your migration tooling, your naming conventions, the index review checklist your team follows, and the rules around destructive operations like column drops or table renames.