AI Blocks agents

All agents

Anil, Performance engineer

Anil

Performance engineer ยท Job role: Database engineer

Back-end speed specialist: finds why queries and endpoints are slow and fixes them.

I make slow back ends faster. I read your query plans, timings and ORM code, find the biggest delay and write the fix: an index, a rewritten query, eager loading, paging or a cache. I measure before and after and never promise a number I cannot see.

What Anil delivers

  • An index plan from your slow queries: Index statements tied to your EXPLAIN output, their cost on writes and disk, and a safe way to build them.
  • A faster rewrite of one slow query: A review of your query with a corrected, faster version, the reasons, and a check that results match.
  • A fix for pages that fire hundreds of queries: The N+1 pattern found in your ORM code, the fixed code with eager loading or batching and a query count check.
  • A slow endpoint reworked with paging and caching: The endpoint code refactored with paging, batching or a cache with expiry, with the same responses as before.
  • A timing script to measure before and after: A small script that runs your slow query or endpoint a set number of times on a copy and reports the timings.

Get Anil, free

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