elasticsearch/docs/reference/sql/endpoints/client-apps/workbench.asciidoc

[role="xpack"]
[testenv="platinum"]
[[sql-client-apps-workbench]]
=== SQL Workbench/J

[quote, https://www.sql-workbench.eu/]
____
https://www.sql-workbench.eu/[SQL Workbench/J] is a free, DBMS-independent, cross-platform SQL query tool.
____

==== Prerequisites

* {es-sql} <<sql-jdbc, JDBC driver>>

==== Add {es} JDBC driver

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

image:images/sql/client-apps/workbench-1-manage-drivers.png[]

Add a new entry to the list through the blank page button in the upper left corner. Add the JDBC jar, provide a name and click on the magnifier button to have the driver *Classname* picked-up automatically:

image:images/sql/client-apps/workbench-2-add-driver.png[]

==== Create a new connection profile

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

image:images/sql/client-apps/workbench-3-connection.png[]

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 queries

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

image:images/sql/client-apps/workbench-4-data.png[]