Analyze SQL and ORM queries for N+1 patterns and missing indexes.
npx skills add https://github.com/KILWA73/MiniSoc --skill query-optimizer-kilwa73
Please help me install this Agent Skill. Skill: query-optimizer Source: https://github.com/KILWA73/MiniSoc/tree/main/.agents/skills/query-optimizer Command: npx skills add https://github.com/KILWA73/MiniSoc --skill query-optimizer-kilwa73
Analysts and developers waste time diagnosing slow queries and missing indexes in ORM/SQL code, leading to dropped performance and user frustration.
Provide an optimized SQL/ORM query and explain the execution plan.
High-intent search queries and answers about installing and using this skill.
To fix N+1 query issues, you analyze your ORM query structure to apply eager loading recommendations, which batch related data retrievals and reduce database round trips.
The best way to optimize slow SQL queries is to analyze the query structure to generate index recommendations for complex filtering and joins, alongside optional raw SQL rewrites for unindexed predicates.
You analyze an execution plan by providing your SQL or ORM query to identify unindexed predicates, which reveals missing indexes and allows the system to propose targeted index suggestions for complex filtering.
Yes, query optimization works for speeding up admin dashboards and reports by analyzing data-retrieval paths and endpoints suffering from database bottlenecks to propose eager loading and index recommendations.
You should use raw SQL rewrites when ORM query optimization cannot sufficiently resolve complex filtering and joins, providing an optional alternative to generate more efficient execution plans for slow queries.
sorodriguezzAnalyze SQL statements and runtime statistics to diagnose query performance in InterSystems IRIS.
LaunchPadLabDetect and fix Rails runtime performance issues like N+1 queries and slow SQL.
camelranchentertainmentOptimize PostgreSQL and MySQL queries with EXPLAIN ANALYZE and indexing strategies.
januarfontiDesign schemas, indexes, migrations, and query optimizations for PostgreSQL, MySQL, and NoSQL databases.
