capabilities.work

Run an SQL query against Elasticsearch

One step with Elastic Stack. We can help you get access.

Look something up

Run an SQL query against Elasticsearch

Use Elastic Stack: its Elasticsearch Request & Response Specification Sql API lets you run an SQL query against Elasticsearch in a single step (POST /_sql). capabilities.work can help you get signed up and connected.

  • How do I query my Elasticsearch indices with SQL?
  • Can I page through large SQL results with a cursor?
  • Is it possible to set a time zone for date handling in an SQL query?
Say it to your AI assistant
  • Run the SQL query {query}.
  • Execute {query} in time zone {time_zone} and return the results as {format}.
  • Fetch the next page of SQL results with cursor {cursor}.
For your developer

POST /_sql in Elasticsearch Request & Response Specification Sql API. Full spec on APIs.io.