Elasticsearch Query Tester
Paste or build Elasticsearch queries and get instant explanations of each clause.
Validates your JSON, explains
bool,
match,
term,
range,
wildcard,
and aggregation clauses. Includes a field type guide.
Frequently Asked Questions
What is the Elasticsearch bool query?▼
The bool query is the primary way to combine multiple queries. It has four clauses: must (all must match, contributes to relevance score), filter (must match but doesn't affect score — cached, faster), should (optional — boosts score if matched), and must_not (excluded, cached). Use filter for structured data like status or date ranges, and must for full-text relevance.
What's the difference between match and term?▼
match is for full-text fields — it analyzes the query string using the same analyzer as the indexed field (lowercasing, stemming, etc.). term is for exact value matching on keyword, numeric, and boolean fields. Using term on a text field usually fails because the stored value is tokenized, not the original string.
When should I use filter vs must?▼
Use filter for anything where relevance score doesn't matter — IDs, status codes, date ranges, numeric thresholds. Filter results are cached by Elasticsearch, making them significantly faster on repeated queries. Use must only when you want the clause to contribute to the _score (full-text relevance).
What does size: 0 mean in aggregations?▼
Setting size: 0 tells Elasticsearch not to return any document hits — only the aggregation results. This is the standard pattern for analytics queries where you only care about counts, averages, or groupings, not the actual documents.
What is minimum_should_match?▼
In a bool query with should clauses, minimum_should_match controls how many should conditions must match. Normally if must or filter clauses exist, should is optional. Set minimum_should_match: 1 to require at least one should clause to match even when must/filter is present.
Does this tool send my query to Elasticsearch?▼
No. All analysis runs entirely in your browser. Nothing is sent to any server — not Elasticsearch, not our servers, nothing. Your query stays local.
Related Products
on GumroadTypeScript Quick Reference Toolkit
5 practical reference files for TypeScript developers: cheatsheet, TS vs JS comparison, 20 utility types with real examples, tsconfig best practices template, and 15 common mistakes guide. Print it. Keep it on your desk.
Buy on Gumroad →DevToolkit Starter Kit
A ready-to-deploy developer tools website with 12 built-in tools. Astro + Preact + Tailwind. Deploy to Cloudflare Pages for free. Built-in SEO, dark mode, and ad-ready layout.
Buy on Gumroad →DevPlaybook Interview Vault
210+ real technical interview questions with model answers, asked at Google, Meta, Amazon, Microsoft, Stripe, and Shopify. Covers Frontend (55), Backend (55), System Design (50), and DSA (50). Available in English and Traditional Chinese.
Buy on Gumroad →You Might Also Need
Elasticsearch Query Builder
Build Elasticsearch bool queries visually. Add must, should, filter, and must_not clauses with term, match, range, wildcard, and exists query types. Outputs ready-to-use JSON DSL.
Open free tool →
SQL ERD Diagram Generator
Paste SQL CREATE TABLE statements to instantly visualize your database schema as an entity-relationship diagram. Shows tables, column types, primary keys, foreign keys, and relationships.
Open free tool →
Neon DB Query Builder
Visual query builder for Neon serverless PostgreSQL. Generate raw SQL, @neondatabase/serverless TypeScript, and Drizzle ORM code for SELECT, INSERT, UPDATE, DELETE operations.
Open free tool →
More Free Tools
Related Articles
MongoDB Schema Design: 5 Patterns for Scalable Apps
Master MongoDB schema design with 5 proven patterns: embedding vs referencing, bucket pattern, outlier pattern, computed pattern, and polymorphic schema. Real-world examples with Node.js and Mongoose.
PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project
PostgreSQL vs MySQL vs SQLite: which database is best for your project? Compare performance, features, ease of use, scaling, and ideal use cases.
Essential MySQL Tools for Developers in 2026
The best MySQL tools for developers in 2026. Covers GUI clients, CLI utilities, ORM frameworks, backup tools, and monitoring solutions for MySQL 8.x and MariaDB.
PostgreSQL vs MySQL: Which to Choose in 2026?
Comprehensive comparison of PostgreSQL and MySQL in 2026. Performance, JSON support, replication, licensing, and a decision framework for choosing the right database for your project.
PostgreSQL vs MySQL 2026: Which Database Should You Choose?
A comprehensive comparison of PostgreSQL and MySQL in 2026. Deep dive into performance, JSON support, replication, ecosystem, and which database fits your use case.
Enjoying this tool? Get more like it.
Weekly developer tool guides, productivity playbooks & AI tricks. Free. No spam.
Unlock AI-Powered Dev Tools
- ⚡ AI Code Review, Doc Generator & SQL Builder
- ⚡ All premium templates & early access
- ⚡ Member discounts on Gumroad products
$9/mo after trial · Cancel anytime
Want the full toolkit?
Get DevPlaybook Pro
Every template, guide, boilerplate, and automation script in one bundle. 13 premium products — grab them all at once and save big.
MIT licensed · Instant download · No subscription
See what's included → Browse all deals →