Identify and optimize slow database queries with EXPLAIN ANALYZE profiling.
npx skills add https://github.com/mahg-es/araya --skill db-optimization
Please help me install this Agent Skill. Skill: db-optimization Source: https://github.com/mahg-es/araya/tree/main/skills/db-optimization Command: npx skills add https://github.com/mahg-es/araya --skill db-optimization
This Skill helps developers and DBAs reduce query latency and improve throughput by identifying bottlenecks, rewriting queries, and applying indexing and configuration changes.
Analyze your slow queries and generate an optimization plan with indexing and query rewrites.
High-intent search queries and answers about installing and using this skill.
To improve database query response times, use query profiling like EXPLAIN ANALYZE to detect bottlenecks and identify slow queries. This pinpoints complex joins and read/write contention across development, testing, and production environments for measurable before/after results.
Designing indexing strategies for high read/write contention workloads involves analyzing query execution plans to apply targeted indexing and query rewrites. This reduces query latency and improves throughput by directly addressing data growth and complex join bottlenecks.
Query profiling with EXPLAIN ANALYZE works for optimizing database throughput by executing queries to reveal execution bottlenecks and latency sources. It provides measurable before/after results to guide configuration tuning and indexing recommendations for complex workloads.
Yes, you can apply database configuration tuning for read-heavy workloads in production environments. The optimization workflow supports configuration changes and query rewriting guidance across development, testing, and production to safely improve throughput and reduce latency.
Database query latency increases with large data growth and complex joins due to inefficient execution plans and read/write contention. Identifying these bottlenecks through query profiling allows you to apply indexing and configuration tuning, restoring optimal response times.
DexploarerAnalyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.
BFLabsAIIdentify and prioritize Postgres performance improvements for Supabase deployments.
JeffallanDiagnose slow queries and optimize indexes for PostgreSQL and MySQL.
HieubkavAnalyze database indexes and query execution plans to recommend optimizations.
