› › ›

DbVisualizer

You can use the Elasticsearch JDBC driver to access Elasticsearch data from DbVisualizer.

Elastic does not endorse, promote or provide support for this application.

Prerequisites

DbVisualizer 13.0 or higher
Elasticsearch SQL JDBC driver

Note

Pre 13.0 versions of DbVisualizer can still connect to Elasticsearch by having the JDBC driver set up from the generic Custom template.

Setup the Elasticsearch JDBC driver

Setup the Elasticsearch JDBC driver through Tools > Driver Manager:

dbvis 1 driver manager

Select Elasticsearch driver template from the left sidebar to create a new user driver:

dbvis 2 driver manager elasticsearch

Download the driver locally:

dbvis 3 driver manager download

and check its availability status:

dbvis 4 driver manager ready

Create a new connection

Once the Elasticsearch driver is in place, create a new connection:

dbvis 5 new conn

by double-clicking the Elasticsearch entry in the list of available drivers:

dbvis 6 new conn elasticsearch

Enter the connection details, then press Connect and the driver version (as that of the cluster) should show up under Connection Message.

dbvis 7 new conn connect

Execute SQL queries

The setup is done. DbVisualizer can be used to run queries against Elasticsearch and explore its content:

dbvis 8 data

© 2023-2025 Elasticsearch
As of September 2024, Elasticsearch is available under a choice of three licenses: the Server Side Public License (SSPL), the Elastic License, or the AGPLv3 (OSI approved).
Elasticsearch and the Elasticsearch logo are trademarks of Elasticsearch B.V., registered in the U.S. and in other countries.
https://www.elastic.co/guide/en/elasticsearch/reference/7.17/sql-client-apps-dbvis.html