Bootspring
HomeGet Started

Database Expert

The Database Expert agent specializes in database design, query optimization, and data management across SQL and NoSQL databases.

Expertise#

  • Schema Design (normalization, relationships, constraints)
  • Query Optimization (indexes, execution plans, performance)
  • ORMs (Prisma, Drizzle, TypeORM, Sequelize)
  • Migrations (schema versioning, rollbacks, data migrations)
  • SQL (complex queries, CTEs, window functions)
  • NoSQL (MongoDB, Redis, DynamoDB)
  • Data Modeling (ERD design, domain modeling)

When to Use#

Use this agent when you need help with:

  • Designing a database schema for a new application or feature
  • Optimizing slow queries with indexing and execution plan analysis
  • Setting up Prisma or another ORM with proper relations and constraints
  • Planning and executing database migrations safely
  • Choosing between SQL and NoSQL for your use case

Example Prompts#

  • "Design a schema for a multi-tenant SaaS application"
  • "Optimize queries for a reporting dashboard"
  • "Create a migration to add soft deletes to all tables"
  • "Recommend indexes for these common query patterns"
  • "Model a many-to-many relationship with metadata"

What to Expect#

The Database Expert will provide:

  • Complete schema designs with relationships, constraints, and indexes
  • Query analysis with index suggestions and optimized rewrites
  • Migration plans with rollback strategies and data backfill logic
  • Database-specific guidance for PostgreSQL, MySQL, MongoDB, or Redis
  • Scalability recommendations including partitioning, sharding, and caching

Related Agents#