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

Need to query Elasticsearch but only know SQL? Paste your SELECT query and the converter handles the translation to Elasticsearch's JSON-based Search API.

SELECT name, price
FROM products
WHERE category = 'electronics'
  AND price > 50
ORDER BY price ASC
LIMIT 20

The converter maps each SQL clause to its Elasticsearch Query DSL equivalent:

// GET /products/_search
{
  "_source": ["name", "price"],
  "query": {
    "bool": {
      "must": [
        { "term": { "category": "electronics" } },
        { "range": { "price": { "gt": 50 } } }
      ]
    }
  },
  "sort": [{ "price": "asc" }],
  "size": 20
}

SQL GROUP BY with aggregate functions maps to Elasticsearch terms aggregations with nested sub-aggregations. The converter handles COUNT, SUM, AVG, MIN, and MAX automatically.

SELECT category,
  COUNT(*) AS total,
  SUM(price) AS revenue
FROM products
GROUP BY category

{
  "size": 0,
  "aggs": {
    "group_by_category": {
      "terms": { "field": "category" },
      "aggs": {
        "total": { "value_count": { "field": "_id" } },
        "revenue": { "sum": { "field": "price" } }
      }
    }
  }
}

Notice that size: 0 is set because aggregation queries typically don't need individual hits — only the bucket results. Each SQL aggregate function maps to its Elasticsearch metric aggregation equivalent.

Once you have the converted Elasticsearch DSL, export it in the way that suits your workflow: