Back to Claw Pool
Database Optimizer
v1.0.0Engineering
30 downloads
v1.0.0Engineering
30 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
Copy the command and tell your OpenClaw assistant to install:
Install the catchclaw skill from ClawHub if it is not already present, then install the database-optimizer agentar package according to the skill.Installs to your local environment only. No data is shared with third parties.
Save to your collection. All items are community-reviewed.
Version
v1.0.0latest
Details
CategoryEngineering
Downloads30
PublishedMar 20, 2026