Skip to content
All data sources
Elasticsearch logo

Elasticsearch is a distributed search and analytics engine. Basedash queries your indices and data streams through the Elasticsearch SQL API. Connect Elasticsearch to Basedash to ask questions, build dashboards, and automate reporting with AI.

14-day trial. No credit card required.

Chat/Elasticsearch growth
Connected
Show Elasticsearch weekly trend over the last 12 weeks, with the prior period as a comparison.

Pulled the last 12 weeks from elasticsearch. Up +38% vs. the prior period — growth accelerating in the last four weeks.

Elasticsearch weekly

94+38%(42)
Elasticsearch
68+13%(38)
Prior period
12 weeks
0255075100W1W3W5W7W9W119468
Save it to the Acme Corp dashboard.
Ask a follow-up about Elasticsearch…↵

Basedash connects to Elasticsearch through its SQL API and runs analytics on your indices and data streams, on Elastic Cloud or self-hosted clusters.

Read the Elasticsearch setup guide
  1. Copy the Elasticsearch endpoint

    Use your cluster's REST URL with its port, for example https://example.es.cloud.es.io:443, not the Kibana URL.

  2. Choose an authentication method

    Paste an encoded API key, or enter the username and password of a dedicated user.

  3. Connect and sync indices

    Basedash checks the SQL API, then syncs the schema of the indices and data streams you can read.

Index privileges

  • read on the indices and data streams you want to query
  • view_index_metadata on the same indices

Imagine ChatGPT or Claude, but with full context of your Elasticsearch schema and how your team uses it. Basedash answers in plain language, backed by real queries.

Try asking

  • Show row growth across Elasticsearch tables over the last 90 days.
  • Which Elasticsearch tables are growing fastest this quarter?
  • Top customers in Elasticsearch by revenue last month.
  • Find the slowest queries hitting Elasticsearch this week.

Plain-language queries

Ask follow-ups in natural language. Basedash translates them into SQL against your Elasticsearch data.

Knows your business

Basedash learns your KPIs, schemas, and the way your team talks about Elasticsearch.

Agentic by default

Runs multiple queries, resolves errors, and keeps iterating until the answer is right.

Keep querying Elasticsearch directly, and sync your SaaS tools into a managed warehouse to see how sales, finance, product, and operations actually connect.

  • Queries run in placeBasedash connects to Elasticsearch directly and queries your data where it lives. No copies to keep in sync.
  • Scoped credentialsConnect with a dedicated Elasticsearch user or key so Basedash only sees the data you grant.
  • SaaS data alongsideSync CRM, billing, and support tools into Basedash Warehouse and analyze them in the same workspace.
Explore the warehouse

Common questions about Elasticsearch and Basedash

Why does Basedash say the Elasticsearch SQL endpoint wasn't found?

That error usually means the URL points at Kibana instead of Elasticsearch, or the SQL API isn't enabled on the cluster. Use the Elasticsearch REST endpoint, include the port if your deployment needs one, and confirm the SQL API is available.

What privileges does Basedash need in Elasticsearch?

Grant the API key or user the read and view_index_metadata privileges on the indices and data streams you want to query, and nothing more. Create a key or user just for Basedash so you can rotate or revoke it independently.

Can Basedash query nested or time-based Elasticsearch indices?

Yes. Basedash queries indices and data streams through Elasticsearch SQL. Add context in Basedash for nested or object fields, unclear field names, and which index pattern or timestamp field to use, so the AI writes the right queries. If you write SQL yourself, use unique column aliases, since Elasticsearch rejects results with duplicate column names.

We'll walk through how Basedash works with Elasticsearch and answer questions for your exact use case.