# SQL Workbench J

[SQL Workbench/J](http://www.sql-workbench.net/) is a free, DBMS-independent, cross-platform SQL query tool. You can use SQL Workbench/J as SQL authoring tool to interactively develop SQL queries with Treasure Data.

This article is created using a Mac OS. Your screens may differ on Windows and Linux.

* [Install](#install)
* [Download Treasure Data JDBC Driver](#download-treasure-data-jdbc-driver)
* [Add the Treasure Data JDBC Driver](#add-the-treasure-data-jdbc-driver)
* [Connect to Treasure Data](#connect-to-treasure-data)
* [Issue the Query](#issue-the-query)


# Install

Download the latest SQL Workbench/J installer from below, and install the application.

* [SQL Workbench/J: Download](http://www.sql-workbench.net/downloads.md)


Follow the instructions at [Installing and starting SQL Workbench/J](http://www.sql-workbench.net/manual/install.md).

SQL Workbench/J requires Java 7 or higher.

# Download Treasure Data JDBC Driver

Download Treasure Data’s JDBC Driver from:

[JDBC Driver for Trino](https://repo1.maven.org/maven2/io/trino/trino-jdbc/423/trino-jdbc-423.jar)

# Add the Treasure Data JDBC Driver

Select `File` at the top menu, and click `Manage Drivers`. Edit the forms:

![](/assets/image-20191007-182818.78b40d523b7ff17909b0e9da28ceabd7a5d012492c0e4cc25d4dffe736f3999d.60bcc915.png)

* Name: Treasure Data
* Library: JDBC driver file path
* Classname: com.treasuredata.jdbc.TreasureDataDriver
* Sample URL
  * [Hive](https://api-docs.treasuredata.com/en/tools/hive/quickstart/): jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=hive
  * [Presto](https://api-docs.treasuredata.com/en/tools/presto/quickstart/): jdbc:td://api.treasuredata.com/< database >;useSSL=true;type=presto


# Connect to Treasure Data

Click **File** at the top menu, and click **Connect Window. Edit** forms:

![](/assets/image-20191007-183312.fef82be1bf98fb469229f601ed6f8c995dec0bbdc5def41e7bfd6d6d2c6606aa.60bcc915.png)

* Name: Whatever you like
* Driver: Treasure Data
* URL: jdbc:td://api.treasuredata.com/sample_db;useSSL=true
* Username: Your account email
* Password: Your account password
* Read only: True


Click **OK** to add the connection.

# Issue the Query

You’ll see a list of tables and its columns by GUI.

![](/assets/image-20191007-183331.5e14dd62386cee28ebf4ac92562ee4213509b0720d2b174bbf866e39a4a12569.60bcc915.png)

Click the Statement tab, and edit the SQL query to be thrown.

`Ctrl + Enter` after the query is ready, then the query runs and shows the results.

You can check the progress of the query from [TD Console](https://console.treasuredata.com/app/jobs).

![](/assets/image-20191007-183350.9009926c9cf3162fddf9ee4d2d08649992b6a85078c201afda79c3a581a624f6.60bcc915.png)