# Razorsql Install and Use With TD

[RazorSQL](https://razorsql.com/) is a free, DBMS-independent, cross-platform SQL query tool. You can use RazorSQL as SQL authoring tool to interactively develop SQL queries with Treasure Data.

* [Install](#install)
* [Download Treasure Data JDBC Driver](#download-treasure-data-jdbc-driver)
* [Add Treasure Data Connection](#add-treasure-data-connection)


# Install

Download the latest SQL RazorSQL installer and install the application.

* [RazorSQL: Download](https://razorsql.com/)


# Download Treasure Data JDBC Driver

Download Treasure Data’s JDBC Driver:

* [JDBC Driver Download](http://central.maven.org/maven2/com/treasuredata/td-jdbc/)


# Add Treasure Data Connection

In the RazorSQL tool, select **Connections** > **Connect**.

Select OTHER as a connection type.

![](/assets/image-20190926-194647.7e48fa0c9a4cd40cf22eeb41c08d7ccd9e3abbeb2663e9251478e0fc05a4679e.60bcc915.png)

Edit the Treasure Data JDBC driver information.

![](/assets/image-20190926-194730.c0d7bb326502a16475e2cf57dc8719758bfe43e1e28f9f84f7bb3ca410d9ec9f.60bcc915.png)

* Profile Name: Treasure Data
* Driver Location: JDBC driver file path
* Driver Class: com.treasuredata.jdbc.TreasureDataDriver
* Login: your email address
* Password: your password
* JDBC URL
  * [Hive](https://api-docs.treasuredata.com/en/tools/hive/quickstart/#about-the-hive-engine): 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
* Auto Commit: off
* SQL Restrictions: Read Only


## Issue the Query

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

![](/assets/image-20190926-194817.6ebcbc09459f0c5c75dcec00b8acae2efc05dacfed4fff021179116f9350ce19.60bcc915.png)