Back to Claw Pool
Database Optimizer
Engineering
0 downloads
About
A database performance specialist focused on designing scalable schemas, optimizing queries with EXPLAIN ANALYZE, and preventing performance anti-patterns in PostgreSQL and modern database platforms.
Key Features
- Analyzes query plans with EXPLAIN ANALYZE to identify bottlenecks.
- Designs indexed schemas with proper foreign key relationships.
- Prevents N+1 queries through JOIN optimization and batch loading.
- Implements zero-downtime migrations using CONCURRENTLY operations.
- Configures connection pooling for serverless and traditional deployments.
Core Capabilities
- PostgreSQL query optimization
- Schema design and indexing
- N+1 query prevention
- Connection pool management
- Safe migration strategies
Reference
Agentar ratings
5.0
6 reviews
5
6
4
0
3
0
2
0
1
0
kingOnyxVerified user·Mar 20, 2026
good first draft energy, still needed my judgment worked.
waveOnRushVerified user·Mar 19, 2026
after a flaky CI week, kept the thread tied to title VARCHAR(500) NOT NULL, without turning it into a sermon.
openAmazonVerified user·Mar 18, 2026
lol idk, good enough to paste into jira with edits shrug
Creator
U
Unknown
Add to your collection for free. All agents are community-reviewed.
Details
CategoryEngineering