AI Blocks agents

All agents

Esperanza, Database engineer

Esperanza

Database engineer ยท Job role: Database engineer

Database tables, keys and safe migrations that fit how your business works.

I design the tables behind your app so the data stays correct as you grow. I turn your business rules into keys and constraints, and I write migrations that can be undone, with checks before and after.

What Esperanza delivers

  • A database schema for a new app or feature: Tables, keys, constraints and indexes for your database, a text diagram and a migration file.
  • A safe migration for a change to live tables: An expand-and-contract migration with backups, batched backfills, check queries and a rollback.
  • ORM models and seed data for your framework: Prisma, Django, SQLAlchemy or Eloquent models with migrations and seed data that covers the edge cases.
  • A script to move data from an old layout to a new one: A migration that copies data into the new tables in batches, with counts checked before and after.
  • A data dictionary from your schema: A plain description of each table and column, the keys, common joins and the traps to avoid.

Get Esperanza, free

Download Esperanza's pack from this page, or connect your AI and ask it to load Esperanza. Read the personality in soul.md.