Elasticsearch Query Builder
Build Elasticsearch DSL queries visually. Add must, should, filter, and must_not clauses with term, match, range, wildcard, and exists queries. Copy the JSON output directly into Elasticsearch.
Frequently Asked Questions
What is the Elasticsearch bool query?▼
The bool query is the primary way to combine multiple queries in Elasticsearch. It has four clauses: must (all must match, contributes to score), should (at least one should match, boosts score), filter (must match but does not affect score — cached), and must_not (must not match — cached).
What is the difference between filter and must?▼
Both require documents to match, but filter skips relevance scoring and is cached by Elasticsearch, making it significantly faster for repeated queries. Use filter for structured data like status, date ranges, and IDs. Use must for full-text search where relevance matters.
When should I use term vs match?▼
Use term for exact value matching on keyword fields (IDs, status codes, tags). term is not analyzed — it compares exact values. Use match for full-text search on analyzed text fields (titles, descriptions) — it applies the same analyzer as the indexed field and splits the query into tokens.
What is a wildcard query and when should I use it?▼
Wildcard queries support * (any number of characters) and ? (single character) patterns, similar to SQL LIKE. Use them for prefix matching (log_*) or flexible string patterns. Avoid leading wildcards (*pattern) as they require scanning all terms and are very slow.
What does the range query support?▼
Range queries support gte (>=), lte (<=), gt (>), lt (<), and format parameters. They work on numeric fields, dates, and strings. Date ranges accept ISO 8601 format (2024-01-01) or relative expressions like now-7d/d (7 days ago, rounded to day).
Does this tool send my data to a server?▼
No. All query building happens entirely in your browser. Nothing is sent to any server.
Related Products
on GumroadDevToolkit 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 →TypeScript 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 →Developer Productivity Bundle
Stop rebuilding the same setup every project. 51 VSCode snippets, 40 Git aliases, 5 Docker Compose stacks, 5 GitHub Actions workflows, 5 README templates, and a dotfiles kit. Set up a professional dev environment in under an hour.
Buy on Gumroad →You Might Also Need
Elasticsearch Query Tester
Paste or build Elasticsearch queries and get instant explanations of each clause. Validates JSON and explains bool, match, term, range, wildcard, and aggregation queries.
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.
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.
Best Free Database Management Tools for Developers in 2026
Compare the best free database management tools for developers in 2026: DBeaver, pgAdmin, MongoDB Compass, Adminer, phpMyAdmin, Azure Data Studio, HeidiSQL, TablePlus, Beekeeper Studio, and Metabase.
Best Free Database GUI Tools for Developers in 2026
A complete guide to the best free database GUI tools in 2026. Covers TablePlus, DBeaver, DataGrip, Beekeeper Studio, pgAdmin, and more — with setup tips and feature comparisons for PostgreSQL, MySQL, SQLite, and MongoDB.
SQL Formatter Online: Beautify Queries for Readability
Format messy SQL queries online for free. Learn how SQL formatters improve code readability, support multiple dialects, and help teams write consistent queries.
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 →