Last update: 2025-12-17T09:59:55.000Z
Content:
---
title: "Connect DataGrip to Tinybird · Tinybird Docs"
theme-color: "#171612"
description: "This guide covers the steps to connect DataGrip to Tinybird using the ClickHouse database driver, enabling advanced SQL development and database management."
inkeep:version: "forward"
---




# Connect DataGrip to Tinybird [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#connect-datagrip-to-tinybird)

Copy as MD DataGrip can connect to Tinybird using the ClickHouse® database driver, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility. This enables you to use DataGrip's advanced SQL development features, including intelligent code completion, on-the-fly error detection, and powerful refactoring capabilities with your Tinybird data.

The ClickHouse® connection to Tinybird is read-only. You can use it to query and analyze data from your Tinybird data sources, but you cannot modify data through this connection.

## Prerequisites [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#prerequisites)

- DataGrip IDE (part of JetBrains IDEs)
- A Tinybird workspace with data sources
- A Tinybird Auth Token with scopes `WORKSPACE:READ_ALL`   and optionally `ORG_DATASOURCES:READ`   . See[  how to create it](../clickhouse-interface#auth-token-requirements)  .

## Create a new data source [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#create-a-new-data-source)

1. Open DataGrip and click the**  +**   icon in the Database Explorer
2. Select**  Data Source**   >**  ClickHouse**
3. If prompted, install or update the ClickHouse driver

### General settings [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#general-settings)

Configure the main connection parameters in the **General** tab:

Host: clickhouse.tinybird.co
Port: 443  # For HTTPS connections
User: <WORKSPACE_NAME>  # Not used for authentication, for identification only
Password: <TOKEN>  # Your Tinybird Auth Token See the list of [ClickHouse hosts](../clickhouse-interface#clickhouse-interface-hosts) to find the correct one for your region.



<-figure->
![DataGrip configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fdata-grip-1.png&w=3840&q=75)

<-figcaption->
DataGrip configuration

</-figcaption->


</-figure->
### SSH/SSL settings [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#sshssl-settings)

1. Click the**  SSH/SSL**   tab
2. Check**  Use SSL**
3. Leave all other SSL settings at their defaults (no custom certificates required)



<-figure->
![DataGrip configuration](/docs/_next/image?url=%2Fdocs%2Fimg%2Fdata-grip-2.png&w=3840&q=75)

<-figcaption->
DataGrip configuration

</-figcaption->


</-figure->
### Test and save [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#test-and-save)

1. **  Test Connection**   : Click**  Test Connection**   to verify the setup
2. **  Apply**   : Click**  Apply**   and then**  OK**   to save the connection

## Explore your data [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#explore-your-data)

Once connected, you can:

1. **  Browse databases**   : Expand your data source to see available databases:  

  - Your workspace database ( `<WORKSPACE_NAME>`     )
  - Service data sources ( `tinybird`    , `organization`     )
  - System tables ( `system`     )
2. **  View tables and schemas**   : Navigate through your Data Sources and examine their structure
3. **  Execute queries**   : Right-click on your data source and select**  New**   >**  Query Console**   to start writing SQL

## Test the connection [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#test-the-connection)

Create a simple query to verify your connection:

1. Open a new Query Console for your Tinybird data source
2. Write a simple query to test the connection:

SELECT *
FROM system.tables
WHERE database = '<WORKSPACE_NAME>'
LIMIT 10 Replace `<WORKSPACE_NAME>` with your actual workspace name. If the connection is working, you should see a list of your Data Sources.

## Learn more [¶](https://www.tinybird.co/docs/forward/work-with-data/publish-data/guides/connect-datagrip#learn-more)

- [  ClickHouse Interface overview](../clickhouse-interface)
- [  Tinybird Auth Token management](/docs/classic/administration/auth-tokens)
- [  DataGrip documentation](https://www.jetbrains.com/help/datagrip/)


