You can use the Elasticsearch JDBC driver to access Elasticsearch data from SQuirreL SQL.
Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.
- SQuirreL SQL version 4.0.0 or higher
- Elasticsearch SQL JDBC driver
To add the Elasticsearch JDBC driver, use Windows > View Drivers menu (or Ctrl+Shift+D shortcut):

Select Elasticsearch profile from the Drivers panel on the left-hand side (if it is missing check the SQuirreL SQL version or add a new entry to the list through the ‘+’ button in the upper left corner):

Select the Extra Class Path tab and Add the JDBC jar. Name the connection and List Drivers to have Class Name populated if it is not already filled-in :

The driver should now appear in the list with a blue check mark next to its name:

Add a new connection or in SQuirreL terminology an alias using the new driver. To do so, select the Aliases panel on the left and click the + sign:

Name the new alias and select the Elasticsearch driver previously added:

The setup is completed. Double check it by clicking on Test Connection.
