Elasticsearch to SQL Converter Online — Convert ES DSL Queries to SQL

Got an Elasticsearch query you need to understand as SQL? Paste the JSON body from your Kibana Dev Tools, application code, or API response. You can include the GET /index/_search line — the converter extracts the index name automatically.

GET /products/_search
{
  "query": {
    "bool": {
      "must": [
        { "term": { "status": "active" } },
        { "range": { "price": { "gte": 50 } } },
        { "terms": { "category": ["electronics", "clothing"] } }
      ]
    }
  }
}

The converter maps Elasticsearch query types to standard SQL:

SELECT *
FROM products
WHERE status = 'active'
  AND price >= 50
  AND category IN ('electronics', 'clothing')

Elasticsearch aggregations are converted into SQL GROUP BY clauses with the appropriate aggregate functions. Terms aggregations become grouping columns, while sub-aggregations like sum, avg, min, and max map to their SQL equivalents.

{
  "size": 0,
  "aggs": {
    "by_category": {
      "terms": {
        "field": "category"
      },
      "aggs": {
        "total_revenue": {
          "sum": { "field": "revenue" }
        },
        "avg_price": {
          "avg": { "field": "price" }
        }
      }
    }
  }
}

SELECT
  category,
  SUM(revenue) AS total_revenue,
  AVG(price) AS avg_price
FROM table_name
GROUP BY category