agency-database-optimizer

What problem does it solve?

This skill helps teams improve database performance by designing scalable schemas, optimizing queries, and implementing robust indexing and migration practices.

Core Features & Use Cases

• Optimized Schema Design for high-traffic apps with proper foreign keys, constraints, and indexing strategies.
• Query Optimization with EXPLAIN ANALYZE, join optimization, and N+1 query prevention.
• Safe Migrations with reversible, low-lock changes and concurrency-safe indexing.
• Connection Pooling patterns and deployment considerations for serverless environments.
• Use Case: A startup with rising read traffic migrates from naive schemas to normalized/denormalized designs to balance performance.

Quick Start

Describe your current workload and I will propose a tuned schema, indexing plan, and safe migration strategy.