FlatQL
Sign in Start free

Alternatives

Kibana alternatives for Elasticsearch and OpenSearch

Kibana is the default front end for Elasticsearch, and for dashboards it is hard to beat. This page covers the other jobs people bring to it, such as SQL, ad-hoc analysis across indices, large exports, and sharing a cluster with people who should not get cluster users.

Why people look for a Kibana alternative#

Kibana does a lot, so the reasons to look elsewhere are specific:

  • You want SQL. Kibana offers KQL, Lucene syntax and ES|QL. A team that thinks in SELECT ... GROUP BY wants to skip the translation step.
  • You need to combine indices. Kibana's answer is ES|QL LOOKUP JOIN, with the conditions described below.
  • You need big exports. CSV export from Discover has size limits that depend on the query mode, per Elastic's Discover documentation.
  • You share a cluster with people who should not have cluster users. Kibana access means an Elasticsearch user or an SSO identity.
  • You run OpenSearch. OpenSearch clusters ship with OpenSearch Dashboards rather than Kibana.
  • You want something smaller. Shard state and a REST console do not need a full Kibana deployment.

What Kibana still does best#

Kibana's Discover explores documents with KQL, Lucene or ES|QL, builds quick charts and saves sessions to dashboards. Dashboards, Lens, Maps, alerting and the Observability and Security apps have no equivalent in the lighter tools below. The licensing FAQ says the default distribution is under the Elastic License 2.0, with AGPLv3 added in 2024 for the free parts of the source; the repository's licence file describes a triple licence (AGPLv3, SSPL, ELv2) with x-pack code under ELv2 only. Elastic's security announcement made TLS, native users and role-based access control free from 6.8 and 7.1; SSO, LDAP and field- or document-level security stayed paid, and PDF or PNG reports are a subscription feature.

If your job is a dashboard someone looks at every morning, Kibana or OpenSearch Dashboards is still the right tool.

SQL analysis and exports#

FlatQL#

FlatQL is a SQL workbench for Elasticsearch 6 to 9 and OpenSearch 1 to 2, in the browser now and as a desktop app soon (macOS first). The cluster runs filters, sorts, limits and GROUP BY as composite aggregations and date histograms; an embedded DuckDB engine runs what Elasticsearch cannot, such as JOINs across indices, CTEs, window functions and HAVING. Every result shows the Query DSL it sent. Exports stream to CSV, TSV, JSON, NDJSON, Excel and Parquet up to 5,000,000 rows. Teams share connections with roles per index pattern that FlatQL enforces, so members never see cluster credentials. The trade-off is scope: no dashboards, no alerting, and the engine side is capped at about 50,000 rows per index per statement, so pushdown and a LIMIT matter (limits). Free covers one cluster without exports; Pro is a $199 one-time licence (pricing, FlatQL vs Kibana).

DBeaver with the Elasticsearch driver#

DBeaver is a desktop database IDE whose Community edition is Apache 2.0. Elastic documents connecting DBeaver through the Elasticsearch SQL JDBC driver, and the Enterprise edition page lists Elasticsearch, Open Distro and OpenSearch drivers with enhanced features in the paid annual edition. You get x-pack SQL's feature set; its limitations page notes that sub-selects must flatten into one SELECT, arrays are unsupported, and aggregations without a LIMIT fail above 10,000 rows. More in FlatQL vs DBeaver.

Cluster administration#

Cerebro#

Cerebro is an MIT-licensed web admin tool written in Scala on the Play framework. It needs Java 11 or newer, runs on port 9000, has official Docker images and supports LDAP authentication. Its source tree has modules for nodes, REST requests, snapshots, repositories, index templates, index and cluster settings, and _cat output. The last release is v0.9.4 from April 2021 and the last commit is from July 2021. Read FlatQL vs Cerebro for the side-by-side.

ElasticVue#

ElasticVue is an MIT-licensed GUI that ships as a desktop app for Windows, macOS and Linux, as a Chrome, Firefox and Edge extension, as a hosted web app, as a Docker image and self-hosted. It covers cluster overview, index and alias management, shards, searching and editing documents, REST queries, and snapshot repositories, and the README says it supports every Elasticsearch version including end-of-life ones. v1.17.0 shipped in October 2026. It is single-user: credentials live in the browser or desktop profile, with no accounts or roles. See FlatQL vs ElasticVue.

Elasticsearch Head#

Elasticsearch Head is the original cluster front end, Apache 2.0 licensed. It runs as a Chrome extension, a standalone Node server on port 9100, or Docker images tagged for Elasticsearch 1, 2 and 5; the site-plugin mode stopped working at Elasticsearch 5. The last release is v5.0.0 (April 2018) and the last commit is from November 2020. See the Elasticsearch Head alternatives roundup if that is what you are replacing.

Browsing and editing documents#

Dejavu#

Dejavu is an MIT-licensed web UI for Elasticsearch and OpenSearch that runs as a hosted app, a Docker image on port 1358, or fully client-side. It browses multiple indices with filters, edits documents singly or in bulk by query, imports JSON and CSV with a guided mapping step, and exports a filtered view as JSON or CSV. Release 3.10.0 is from September 2025; the README's examples use OpenSearch 2.17 and Elasticsearch 8.15. No aggregations or charts, so you still need Kibana or a SQL tool for those. See FlatQL vs Dejavu.

Dashboards and monitoring#

Grafana#

Grafana is AGPL-3.0 and runs self-hosted or in Grafana Cloud. The built-in Elasticsearch data source supports Elasticsearch 7.17, 8.x and 9.x with Lucene query strings, bucket and metric aggregations, raw Query DSL in code mode and ES|QL; a separate OpenSearch data source adds Lucene and PPL. Grafana Cloud has a free tier with three active users; Pro is a $19 per month platform fee plus $8 per active user. It is the closest replacement for Kibana dashboards when Elasticsearch is one of several data sources, and it is not a document browser or an admin console. See FlatQL vs Grafana.

OpenSearch Dashboards#

OpenSearch Dashboards is the Apache 2.0 interface for OpenSearch, at release 3.9.0 in October 2026. Beyond dashboards and Discover it ships Query Workbench for read-only SQL and PPL with result downloads, a Reporting plugin for PDF, PNG, CSV and XLSX with a 10,000-row CSV default, and the Security plugin with index, document and field-level roles, multi-tenancy and audit logging. For OpenSearch users this is the Kibana replacement; its SQL is the OpenSearch SQL plugin, so no JOINs across indices (FlatQL vs OpenSearch SQL).

Staying in Kibana: Console and ES|QL#

Before adding a tool, check whether Kibana's own Dev Tools cover the gap. Console sends REST requests with autocomplete, keeps the last 500 requests and copies any request as curl, JavaScript or Python. ES|QL is a piped language that runs in Discover, dashboards and Console: FROM logs-* | STATS count = COUNT(*) BY service | SORT count DESC. LOOKUP JOIN has been generally available since Elastic Stack 9.1, but the joined index must use the lookup index mode and wildcards are not allowed, so it is planned enrichment rather than an ad-hoc join between two ordinary indices. If that fits, stay in Kibana.

Comparison#

Tool Form Query language Exports Access control Licence
FlatQL Web, desktop (coming soon) SQL with JOINs, CTEs, windows CSV, TSV, JSON, NDJSON, Excel, Parquet FlatQL roles per index pattern Free; Pro $199 once
DBeaver Desktop x-pack SQL via JDBC DBeaver export tools Cluster users Apache 2.0; paid editions
Cerebro Self-hosted web (JVM) REST None stated LDAP for the UI; cluster users MIT
ElasticVue Desktop, extension, web, Docker REST, Query DSL None stated Cluster users MIT
Elasticsearch Head Extension, standalone web Query DSL None stated Cluster users Apache 2.0
Dejavu Web, Docker, hosted Filters, Query DSL JSON, CSV Cluster users MIT
Grafana Self-hosted, cloud Lucene, aggregations, ES|QL, PPL Panel data Grafana users and teams AGPL-3.0; Cloud free tier
OpenSearch Dashboards Self-hosted web DQL, SQL, PPL PDF, PNG, CSV, XLSX Security plugin roles Apache 2.0
Kibana (Console, ES|QL) Self-hosted web, Elastic Cloud KQL, Lucene, ES|QL CSV from Discover Elasticsearch roles ELv2 / AGPLv3 / SSPL

How to choose#

Pick by the job. Dashboards people watch: keep Kibana, or Grafana if Elasticsearch is one source among many. Cluster health and shards: ElasticVue or Cerebro. Fixing documents by hand: Dejavu or ElasticVue. SQL across indices, exports of millions of rows and a team that should not hold cluster credentials: FlatQL, documented under JOINs, streaming export and team access rules.

FAQ

Questions

Anything else, write to us.

Is Kibana free?

The core of Kibana ships under Elastic's free Basic tier, including Discover, dashboards, Console and role-based access control. Some features, such as PDF and PNG reports, are listed by Elastic as subscription features. See the table and the Kibana section above for sources.

Which Kibana alternative works with OpenSearch?

OpenSearch Dashboards is the project's own interface. FlatQL, Grafana (through its OpenSearch data source) and Dejavu also connect to OpenSearch clusters. ElasticVue and Elasticsearch Head do not name OpenSearch in their documentation.

Can I keep Kibana and add one of these tools?

Yes. All of the tools here talk to the cluster's HTTP API with their own credentials, so they run beside Kibana. FlatQL in particular installs nothing on the cluster; see how FlatQL connects.

Do I need SQL to replace Kibana for analysis?

No. Kibana's own ES|QL is a piped language, Grafana uses Lucene queries and aggregations, and ElasticVue or Dejavu work with Query DSL. SQL matters when you want JOINs across indices, window functions or an export of millions of rows, which is where FlatQL fits.

Start on Free. It stays free.

Connect a cluster and run a join in five minutes. No card, no expiry.

Guides

How FlatQL handles the jobs Elasticsearch makes hard.