Analyze SQL queries for performance issues and optimization recommendations.
npx skills add https://github.com/47network/Sven --skill db-query-optimizer
Please help me install this Agent Skill. Skill: db-query-optimizer Source: https://github.com/47network/Sven/tree/main/skills/compute-mesh/db-query-optimizer Command: npx skills add https://github.com/47network/Sven --skill db-query-optimizer
Analyzes SQL queries for performance issues and provides actionable optimization recommendations.
Provide a SQL query and set action to analyze to receive performance diagnostics and optimization suggestions.
High-intent search queries and answers about installing and using this skill.
To optimize SQL queries, you analyze them to identify performance bottlenecks and surface actionable recommendations. This process detects anti-patterns like missing WHERE clauses and N+1 queries, then proposes concrete improvements such as generating appropriate indexes.
Common SQL anti-patterns that slow down database queries include N+1 query structures, missing WHERE clauses, and inefficient joins. Detecting these anti-patterns allows you to refactor the workload and apply targeted optimizations for better performance.
Yes, you can analyze PostgreSQL and MySQL execution plans to improve query performance. By explaining the execution plan, you can identify bottlenecks within your specific database dialect and receive concrete structural improvements to speed up the workload.
To know which indexes to add for slow SQL queries, you analyze the query structure and database schema. This analysis suggests appropriate indexes, including composite indexes tailored to your specific joins and filtering conditions, to accelerate execution.
Database query optimization works for both OLTP and reporting workloads, as well as ad-hoc analytics queries. It analyzes the specific SQL commands across PostgreSQL, MySQL, and SQLite to provide targeted performance diagnostics and structural improvements.
fuziix266Optimize SQL queries and design database schemas across PostgreSQL, MySQL, and SQL Server.
HainrixzAudit foreign key constraints in relational databases for integrity issues.
EIS-ITSGenerate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.
curiositechAnalyze Node.js application performance via CPU profiling and database query analysis.
