Elasticsearch SQL

Tap into Elasticsearch with a familiar syntax

Elasticsearch has the speed, scale, and flexibility your data needs — and it speaks SQL. Use traditional database syntax to unlock non-traditional performance, like full text search across petabytes of data with real-time results.

NewIn 6.6, Elasticsearch SQL expands support for querying dates and times, including the ability to use intervals and build histograms. Learn More

Scalable Search with Scoring... and SQL

Elasticsearch is a full text search engine with all the goodies you’d expect, like relevance scoring, stemming, synonyms, and more. And since it’s a distributed document store — with horizontal scalability — it can handle billions of rows of data without skipping a beat. With Elasticsearch SQL, you can access that full text search, blazing speed, and effortless scalability with a familiar query syntax.

Familiar Requests with Faster Responses

Use your SQL skills to query data within Elasticsearch, harnessing the power of Elastic with a familiar language. Send your SQL queries via a CLI, REST endpoint, or JDBC to get your results with newfound speed. You’ll even see your results in the same tabular views you’ve been getting since your first SELECT statement.

Stick to SQL or Dive into Query DSL

Learning a new language requires either a good teacher or a good dictionary. With our Elasticsearch SQL translate functionality, you get both. Every time you run a SQL command, you can see the exact Query DSL statement being run against your data in Elasticsearch. Once you’re comfortable, take your queries a step further by trying out our expansive Query DSL.

Try Elasticsearch SQL

Find out for yourself how easy it is to query Elasticsearch data with SQL.