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.

Getting started with Elasticsearch: Store, search, and analyze with the free and open Elastic Stack.

Watch video

Intro to ELK: Get started with logs, metrics, data ingestion and custom visualizations in Kibana.

Watch video

Getting started with Elastic Cloud: Launch your first deployment.

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.

Screenshot

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, ODBC, 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.

It’s Canvas-ready

Use Elasticsearch SQL query syntax to build live, infographic-style presentations in Canvas. Query, aggregate, and shape your Elasticsearch data with SQL syntax — painting your data points into a story that goes beyond the grid.

Canvas animation

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.

SQL translate animation