← Explore all skills

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.

Upstream setup instructions ↗

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
  1. Install the pinned directory interactively and retain its referenced files; inspect the source before granting tool access.
  2. 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.

  1. https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md

    Supports: summary, review, install, access, limitations

  2. Pinned LICENSE ↗Checked

    https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/LICENSE

    Supports: license

  3. Pinned README.md ↗Checked

    https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/README.md

    Supports: summary, review, install, access, limitations

  4. https://raw.githubusercontent.com/elastic/agent-skills/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md

    Supports: upstreamDescription, review.notTested, review.reviewedAt, review.findings

Evidence & Ask