IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« DbVisualizer SQL Workbench/J »
Elastic Docs ›Elasticsearch Guide [6.5] ›SQL Access ›SQL Client Applications

SQquirelL SQL

edit

SQquirelL SQL

edit

This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.

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/

Prerequisites

edit

Add Elasticsearch JDBC Driver

edit

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

squirell 1 view drivers

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

squirell 2 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:

squirell 3 add driver

The driver should now appear in the list:

squirell 4 driver list

Add an alias for Elasticsearch

edit

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:

squirell 5 add alias

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

squirell 6 alias props

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

Execute SQL queries

edit

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:

squirell 7 data

« DbVisualizer SQL Workbench/J »