EDQL

EDQL is a professional query and management tool for Elasticsearch. It's intelligent and powerful for manage Elasticsearch cluster and query from Elasticsearch. also It always follow Elasticsearch the newest features.

It is full compatible with official Query DSL, we can just copy DSL and run on EDQL without any extra effort. also EDQL has visual editor for quickly write query conditions with interactive UI.

Powered by ChatGPT and LLM capabilities, you can now query your Elasticsearch data using natural language - just describe what you're looking for, and let EDQL translate it into powerful search queries. This revolutionary feature combines the robust search capabilities of Elasticsearch with the intuitive nature of conversational AI, making complex data exploration as simple as having a conversation. Whether you're a data analyst, developer, or DevOps engineer, EDQL's AI-powered search will dramatically boost your productivity. (Note: ChatGPT features require your own API key)

It has powerful script engine: function, variable and iteration etc. with smart Intellij you can easily write query DSL(live templates, refactor, extract...). view more on: EDQL Wiki

# f1 = k1
# f2 in ["k1", "k2", "k3"]
# f3 date field gt now-3d
# f4 number lt 20

POST my-index/_search
{
  "query": {
    "bool": {
      "filter": [
        term("f1", "k1"),
        terms("f2", ["k1", "k2", "k3"]),
        gt("f3", "now-3d"),
        lt("f4", 20)
      ]
    }
  }
}

1 Install and Query

1.1 Install EDQL Plugin on Intellij

• Search EDQL from Intellij plugin marketplace and install
• Download from Github Releases, find latest version download and open Intellij plugin and manually install it.

1.2 Install EDQL Standalone GUI

• Download from Github Releases, find latest QSharp version(ex: QSharp1.10.16), Since it's not signed, you should trust it and install.

1.3 New Connection and Query

1.4 Chat Query Elasticsearch