SQL Workbench/Jedit

 

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool.

 
 -- https://www.sql-workbench.eu/
Important

Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.

Prerequisitesedit

  • SQL Workbench/J build 125 or higher
  • Elasticsearch SQL JDBC driver

Add Elasticsearch JDBC driveredit

Add the Elasticsearch JDBC driver to SQL Workbench/J through Manage Drivers either from the main windows in the File menu or from the Connect window:

workbench 1 manage drivers

Select Elasticsearch profile from the left-hand side (if it is missing check the SQL Workbench/J version or add a new entry to the list through the blank page button in the upper left corner):

workbench 2 select driver

Add the JDBC jar (if the driver name hasn’t been picked up already, click on the magnifier button):

workbench 3 add jar

Create a new connection profileedit

With the driver configured, create a new connection profile through File > Connect Window (or Alt+C shortcut):

workbench 4 connection

Select the previously configured driver and set the URL of your cluster using the JDBC syntax. Verify the connection through the Test button - a confirmation window should appear that everything is properly configured.

The setup is complete.

Execute SQL queriesedit

SQL Workbench/J is ready to talk to Elasticsearch through SQL: click on the profile created to execute statements or explore the data:

workbench 5 data