SQquirelL SQLedit

 

SQuirelL SQL is a graphical, [multi-platform] Java program that will allow you to view the structure of a JDBC compliant database […].

 
 -- http://squirrel-sql.sourceforge.net/

Prerequisitesedit

Add Elasticsearch JDBC Driveredit

To add the Elasticsearch JDBC driver, use Windows > View Drivers menu (or Ctrl+Shift+D shortcut):

images/sql/client-apps/squirell-1-view-drivers.png

This opens up the Drivers panel on the left. Click on the + sign to create a new driver:

images/sql/client-apps/squirell-2-new-driver.png

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:

images/sql/client-apps/squirell-3-add-driver.png

The driver should now appear in the list:

images/sql/client-apps/squirell-4-driver-list.png

Add an alias for Elasticsearchedit

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 + sign:

images/sql/client-apps/squirell-5-add-alias.png

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

images/sql/client-apps/squirell-6-alias-props.png

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

Execute SQL queriesedit

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:

images/sql/client-apps/squirell-7-data.png