IMPORTANT: Version 6.6 of Elasticsearch has passed its maintenance date.
This documentation is no longer being updated. For the latest information, see the current release documentation.
This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.
SQuirreL SQL is a graphical, [multi-platform] Java program that will allow you to view the structure of a JDBC compliant database […].
To add the Elasticsearch JDBC driver, use Windows > View Drivers menu (or Ctrl+Shift+D shortcut):
This opens up the
Drivers panel on the left. Click on the
+ sign to create a new driver:
Select the Extra Class Path tab and Add the JDBC jar. List Drivers to have the
Class Name filled-in
automatically and name the connection:
The driver should now appear in the list:
Add a new connection or in SQuirelL terminology an alias using the new driver. To do so, select the Aliases panel on the left and click the
Name the new alias and select the
Elasticsearch driver previously added:
The setup is completed. Double check it by clicking on Test Connection.
The connection should open automatically (if it has been created before simply click on Connect in the Alias panel). SQuirelL SQL can now issue SQL commands to Elasticsearch: