# Elastic Sql API

**Canonical:** https://apis.io/apis/elastic/elastic-sql-api/  
**Provider:** Elastic — https://apis.io/providers/elastic/  
**Base URL:** https://api.elastic-cloud.com  
**Documentation:** https://www.elastic.co/docs/api/doc/elasticsearch

Elastic Sql API is one of 50 APIs that [Elastic](https://apis.io/providers/elastic/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. This API exposes 1 JSON Schema definition. Tagged areas include SQL. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, and 1 JSON Schema.

Elasticsearch's SQL APIs enable you to run SQL queries on Elasticsearch indices and data streams.

## Operations (8)

| Method | Path | Summary |
|---|---|---|
| POST | `/_sql/close` | Clear an SQL search cursor |
| DELETE | `/_sql/async/delete/{id}` | Delete an async SQL search |
| GET | `/_sql/async/{id}` | Get async SQL search results |
| GET | `/_sql/async/status/{id}` | Get the async SQL search status |
| GET | `/_sql` | Get SQL search results |
| POST | `/_sql` | Get SQL search results |
| GET | `/_sql/translate` | Translate SQL into Elasticsearch queries |
| POST | `/_sql/translate` | Translate SQL into Elasticsearch queries |

## Machine-readable artifacts (5)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/elastic/refs/heads/main/openapi/elastic-sql-api-openapi.yml
- **Documentation** — https://www.elastic.co/docs/api/doc/elasticsearch
- **Documentation** — https://www.elastic.co/docs/api/doc/kibana
- **Documentation** — https://www.elastic.co/docs/api/doc/cloud
- **JSONSchema** — https://raw.githubusercontent.com/api-evangelist/elastic/refs/heads/main/json-schema/elastic-saved-object-schema.json

## Other Elastic APIs (12)

- [Elastic Account API](https://apis.io/apis/elastic/elastic-account-api/)
- [Elastic Cluster API](https://apis.io/apis/elastic/elastic-cluster-api/)
- [Elastic Deployments API](https://apis.io/apis/elastic/elastic-deployments-api/)
- [Elastic Documents API](https://apis.io/apis/elastic/elastic-documents-api/)
- [Elastic Indices API](https://apis.io/apis/elastic/elastic-indices-api/)
- [Elastic Search API](https://apis.io/apis/elastic/elastic-search-api/)
- [Elastic Security API](https://apis.io/apis/elastic/elastic-security-api/)
- [Elastic Spaces API](https://apis.io/apis/elastic/elastic-spaces-api/)
- [Elastic Status API](https://apis.io/apis/elastic/elastic-status-api/)
- [Elastic TrafficFilters API](https://apis.io/apis/elastic/elastic-trafficfilters-api/)
- [Elastic Analytics API](https://apis.io/apis/elastic/elastic-analytics-api/)
- [Elastic Cat API](https://apis.io/apis/elastic/elastic-cat-api/)

## Tags

SQL

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/elastic/elastic-sql-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/elastic/.