Optimize SQL and NoSQL queries with EXPLAIN plans and indexing strategies.
npx skills add https://github.com/jamesrochabrun/skills --skill query-expert
Please help me install this Agent Skill. Skill: query-expert Source: https://github.com/jamesrochabrun/skills/tree/main/skills/query-expert Command: npx skills add https://github.com/jamesrochabrun/skills --skill query-expert
Writing efficient, cross-datastore queries is error-prone and time-consuming. This Skill helps you generate optimized queries, analyze performance, and troubleshoot bottlenecks across SQL and NoSQL systems.
Ask for a suggested query: "Show me an efficient search on the orders collection with a compound index." Then apply indexing and optimization recommendations.
High-intent search queries and answers about installing and using this skill.
Query optimization involves analyzing execution plans, refactoring inefficient patterns, and designing targeted indexes. This Skill generates optimized queries for PostgreSQL, MySQL, MongoDB, and other engines, then provides actionable guidance to eliminate bottlenecks and improve performance.
Indexing strategies depend on your access patterns and query structure. This Skill designs compound indexes, covering indexes, and database-specific strategies for MongoDB, PostgreSQL, MySQL, and SQL Server to accelerate common queries and reduce scan overhead.
Yes. EXPLAIN plans reveal how databases execute queries—scan types, join orders, and cost estimates. This Skill analyzes these plans across SQL and NoSQL systems to pinpoint slow operations, identify missing indexes, and suggest concrete refactoring steps.
Efficient queries use appropriate join strategies, avoid unnecessary grouping, and leverage window functions for ranking and cumulative operations. This Skill generates and optimizes these SQL patterns while showing best practices to prevent common performance pitfalls.
Yes. This Skill supports GraphQL query optimization, MongoDB query patterns, and Cypher for graph databases, alongside traditional SQL. It generates optimized queries and indexing strategies across all these query languages and datastores.
SQL optimization focuses on join strategies, normalization, and relational indexes; MongoDB optimization emphasizes document structure, embedded data, and query filters. This Skill addresses both paradigms—query generation, index design, and performance analysis tailored to each datastore type.
LincyawProvides ClickHouse database design, query optimization, data ingestion and analytics patterns.
kongaharshaGenerate publication-quality static and interactive charts from data.
MUmerRazzaqConfigure, monitor, and troubleshoot database connection pools.
CloudAI-XProfile and optimize application performance across frontend, backend, and database layers.
