---
title: "Elasticsearch Query DSL Optimization: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/skills/elastic-elasticsearch-query-optimization/
description: "Use query profiles and mappings to investigate slow Elasticsearch searches."
---

# Elasticsearch Query DSL Optimization: review, setup & limitations · Undominated.ai

> Use query profiles and mappings to investigate slow Elasticsearch searches.

[← Explore all skills](/skills/)

SEARCH AND RETRIEVAL / elastic

# Elasticsearch Query DSL Optimization

Use query profiles and mappings to investigate slow Elasticsearch searches.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/elastic/agent-skills/tree/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization)

SOURCE REVIEW

 Reviewed 2026-10-15
 Evidence 4 linked sources
 Publisher elastic
 Licence [Apache-2.0 ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/LICENSE)
 Revision baa511126ba2
 [Read what was—and wasn’t—checked ↓](#review)

“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.”

 [elastic · upstream description ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md) Our analysis follows below.

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.

### A good fit for

 - Compare a slow wildcard/scoring query with a semantically equivalent candidate.

### Weigh up before choosing

 - Profile timings add overhead and omit parts of end-to-end latency. Removing a leading wildcard changes matching unless the intended contract permits it; wildcard-field behavior needs version-specific evidence.
- Source inspection only; no installation, authenticated operation, runtime benchmark or security certification was performed.

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 ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/README.md)

DOCUMENTED COMMAND

 npx skills add elastic/agent-skills/skills/elasticsearch/elasticsearch-query-optimization Copy command ↗

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 Copy reviewed-revision command ↗ - 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

### Compatibility

Agents supporting directory-based SKILL.md instructions

### Local instructions with workflow-dependent access

 - Runs read queries that can consume substantial CPU; may propose mapping/index changes requiring write privileges.

### Cost model

Skill source is freely available under its stated licence; host, infrastructure and service usage may incur charges.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Pinned skills/elasticsearch/elasticsearch-query-optimization/SKILL.md ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md) Checked 2026-10-14 https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md Supports: summary, review, install, access, limitations
- [Pinned LICENSE ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/LICENSE) Checked 2026-10-14 https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/LICENSE Supports: license
- [Pinned README.md ↗](https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/README.md) Checked 2026-10-14 https://github.com/elastic/agent-skills/blob/baa511126ba2dc37b52e273b52734f8e4e0d323c/README.md Supports: summary, review, install, access, limitations
- [2026-10-15 C2-W35 source re-review at the existing pin ↗](https://raw.githubusercontent.com/elastic/agent-skills/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md) Checked 2026-10-15 https://raw.githubusercontent.com/elastic/agent-skills/baa511126ba2dc37b52e273b52734f8e4e0d323c/skills/elasticsearch/elasticsearch-query-optimization/SKILL.md Supports: upstreamDescription, review.notTested, review.reviewedAt, review.findings

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### Elasticsearch Index Mapping Design ↗ Design index field types and storage settings from concrete access patterns.](/skills/elastic-elasticsearch-index-design/)[### Elasticsearch Search Relevance ↗ Choose deterministic query rules or organic ranking changes from mappings and example searches.](/skills/elastic-elasticsearch-search-relevance/)[### Redis Search and Retrieval ↗ Design lexical, filtered and vector retrieval with Redis Search indexes.](/skills/redis-redis-search/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Choose a toolkit](/tools/)
- [Inspect execution hosts](/agents/)
- [Check tool access](/mcp-servers/)
- [Check project dependencies](/check-repo/)
