MotionQL
Elasticsearch and OpenSearch

Elasticsearch and OpenSearch, Kibana-style, on your desktop

Discover with KQL and a date histogram, a console with completion from the mapping, a documents grid you can edit, and cluster, security, lifecycle and snapshot administration.

  • Elasticsearch
  • OpenSearch
  • Elastic Cloud and Elasticsearch Serverless
  • Amazon OpenSearch Service and Serverless
MotionQL's Discover view for an Elasticsearch index with a date histogram and hits

Discover on an Elasticsearch index: KQL, a histogram and the matching documents.

Query DSL, KQL, Lucene, ES|QL and SQL

What you get for Elasticsearch and OpenSearch

Discover

KQL, Lucene or Query DSL, time ranges, a date histogram, a field list with top values and one-click filters, and Visualize to add a chart to a dashboard.

Console

Kibana-style requests with completion from the mapping, aggregation tables and charts, the Profile API, and SQL translated to Query DSL.

Documents grid

Paged with search_after over a point in time, with filters from any cell, edit with optimistic concurrency, and bulk update or delete by query after you type the count.

Cluster administration

Health, nodes, shards with allocation explain, tasks, hot threads and snapshots; users, roles and API keys; ILM or ISM policies on a timeline; templates and ingest pipelines with Simulate.

Any sign-in

Node URLs or a Cloud ID, basic auth, API keys, bearer tokens, AWS SigV4, a custom CA and SSH tunnels. The distribution and version are detected on connect.

Same app, same habits

And everything every connection gets

Each database keeps its own tools, and shares one workspace with the others.

Features to look at next

Also in search, time series and graph: InfluxDB, Neo4j and Memgraph.

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.