SEARCH AND RETRIEVAL / elastic
Elasticsearch Query DSL Optimization
Use query profiles and mappings to investigate slow Elasticsearch searches.
“Diagnose slow Elasticsearch Query DSL searches and propose measured fixes. Use when a search is slow, profile output shows an expensive clause, exact-match filters sit in scoring context, or leading wildcards dominate latency. Ground every recommendation in search profiling — move non-scoring clauses to filter context, eliminate leading wildcards, and re-profile to confirm improvement.”
01 / THE REASONING
Why this made the selection.
- The workflow profiles before recommending infrastructure changes and distinguishes query-clause cost from aggregation cost.
- Compare a slow wildcard/scoring query with a semantically equivalent candidate.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- skills/elasticsearch/elasticsearch-query-optimization/SKILL.md
- LICENSE
- README.md
Our findings
- The workflow profiles before recommending infrastructure changes and distinguishes query-clause cost from aggregation cost.
- The source requires before-and-after collector evidence and does not accept took alone as proof of a successful rewrite.
Not established by this review
- Third-party instructions and helpers were not executed; service access, host compatibility and outcomes remain untested.
- Not executed: it was not installed or run.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Add a skill to your workflow.
DOCUMENTED COMMAND
npx skills add elastic/agent-skills/skills/elasticsearch/elasticsearch-query-optimization Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.
Optional: install the reviewed revision
Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.
npx skills add https://github.com/elastic/agent-skills/tree/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization - Install the pinned directory interactively and retain its referenced files; inspect the source before granting tool access.
- Retain the original query/results, inspect the dominant profile clause and mappings, then remeasure both latency and result semantics.
Before you start
- Configured elastic CLI with stack es support, compatible Elasticsearch deployment and scoped credentials
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md
Supports: summary, review, install, access, limitations
- Pinned LICENSE ↗Checked
https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/LICENSE
Supports: license
- Pinned README.md ↗Checked
https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/README.md
Supports: summary, review, install, access, limitations
https://raw.githubusercontent.com/elastic/agent-skills/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md
Supports: upstreamDescription, review.notTested, review.reviewedAt, review.findings