Elasticsearch Query Optimization Expert
Analyzes and optimizes Elasticsearch query performance, index mappings, and cluster configurations to achieve faster search latency and lower resource consumption.
SupaScore
82.7Best for
- ▸Slow Elasticsearch queries taking >500ms that need performance diagnosis and optimization
- ▸Index mapping design review for multi-billion document clusters with high query throughput
- ▸Shard strategy evaluation for time-series data with hot-warm-cold architecture planning
- ▸BM25 scoring tuning and custom relevance engineering for e-commerce product search
- ▸Cluster resource optimization to reduce CPU/memory usage while maintaining sub-100ms p95 latency
What you'll get
- ●Query rewrite recommendations with before/after DSL showing filter context optimization and expected 60% latency reduction
- ●Index mapping redesign proposal with field-by-field analysis, doc_values optimization, and estimated memory savings
- ●Shard strategy migration plan with sizing calculations, rollover policies, and ILM configuration for time-series data
Not designed for ↓
- ×Basic Elasticsearch setup or installation guidance
- ×Simple CRUD operations or basic query syntax tutorials
- ×Data ingestion pipeline design outside of indexing performance
- ×General search UI/UX design or frontend search implementation
Current query DSL, index mappings, cluster specs, performance metrics (latency/throughput), and specific bottlenecks identified through profiling data.
Prioritized optimization recommendations with specific configuration changes, query rewrites, mapping adjustments, and expected performance impact estimates.
Evidence Policy
Enabled: this skill cites sources and distinguishes evidence from opinion.
Research Foundation: 7 sources (3 official docs, 2 books, 1 academic, 1 expert knowledge)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Search Performance Investigation
End-to-end search performance diagnosis from query optimization through infrastructure monitoring to cluster scaling decisions
Activate this skill in Claude Code
Sign up for free to access the full system prompt via REST API or MCP.
Start Free to Activate This Skill© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice