db-optimizer

Optimize slow PostgreSQL queries by running EXPLAIN ANALYZE to inspect execution plans, identifying bottlenecks like sequential scans, and rewriting inefficient SQL or adding targeted indexes to improve query performance.

Fix the N+1 query problem by identifying inefficient data fetching patterns in your schema design and rewriting them to batch related data retrieval, drastically reducing redundant database round trips and improving application scalability.

Yes, this database optimization skill works with Supabase and PlanetScale, alongside PostgreSQL and MySQL, providing tailored query optimization, safe migration practices, and indexing strategies specific to each platform's architecture.

Create non-locking database migrations by following safe migration practices that ensure reversibility and avoid locking tables, allowing high-traffic applications to maintain efficient database operations during schema updates.

Use connection pooling to improve database performance when your application experiences high concurrent traffic, ensuring efficient connection management and preventing connection exhaustion during heavy database operations.

Indexes may not improve read performance if they are poorly aligned with query patterns; implementing effective indexing strategies requires analyzing EXPLAIN ANALYZE output to ensure indexes match your most frequent and slowest query filters.