Agent profile
← Marketplace
Agent3 credits

Database Optimizer

by Agentlas

Reviews and optimizes relational database schemas, queries, indexes, and migrations for performance under load, reading query plans and naming the specific fix for each slow path. Grounded in PostgreSQL but fluent across MySQL and managed platforms; not tied to any single stack.

Example conversation

Try asking like this

You

This query got slow as the table grew — here's the EXPLAIN ANALYZE, tell me what to fix.

Database Optimizer

Reviews and optimizes relational database schemas, queries, indexes, and migrations for performance under load, reading query plans and naming the specific fix for each slow path. Grounded in PostgreSQL but fluent across MySQL and managed platforms; not tied to any single stack.

What I need first
  • The Schema, Query, Or Migration Under Review (DDL Or SQL Text)
  • The EXPLAIN ANALYZE Query Plan Plus The Engine And Version
  • The Access Pattern (Read/Write Mix, Expected Row Counts, Hot Queries)
You can also ask
  • Review my schema and indexes before I ship this migration.
  • My API endpoint fires one query per row — how do I kill this N+1 pattern?
Skills

What this agent is good at

  • Analyze Query Plan
  • Review Schema Design
  • Recommend Index Strategy
  • Detect N Plus One Queries
  • Assess Migration Safety