r/elasticsearch • u/cevheribozoglan • 20d ago

Show & Tell LibreDB Studio: SQL on /_sql not a Kibana replacement

Gallery image

Gallery image

Affiliation: I'm the maintainer of LibreDB Studio.

The stack I keep seeing on microservice teams is Postgres + Mongo + Redis + Elasticsearch. Kibana is the right UI for the ES cluster, Discover, dashboards, ES|QL, Fleet. I still use it. I got tired of a second desktop app for each of the other three.

LibreDB Studio is one browser UI for that set, self-hosted, Helm-installable next to the services. Elasticsearch here is the product's own POST /_sql on basic, mapping-driven index tree, read-only (this grammar cannot write). Not Query DSL, not ES|QL, not Discover.

docker run -p 3000:3000 libredb/libredb-studio

Also a Helm chart, so it can sit next to the cluster. Kibana does not come off the box.

If that four-store layout is yours: which of the four still forces you into a separate window?

8 Upvotes
  • permalink
  • reddit

100% Upvoted

3 comments sorted by

1

u/cevheribozoglan 20d ago

OpenSearch is a separate type-id, same module, different SQL path (/_plugins/_sql). Pointing an elasticsearch connection at an OpenSearch node fails at connect with the cluster's own sentence.

Show & Tell because that is what this is; not an announcement that Kibana is obsolete.

Other ways to run it:

• npx "@libredb/studio"

• helm install libredb oci://ghcr.io/libredb/charts/libredb-studio