---
title: Connect DBeaver to Tinybird
meta:
  description: This guide covers the steps to connect DBeaver to Tinybird using the ClickHouse JDBC driver, enabling SQL development and database management.
headingMaxLevels: 2
---

# Connect DBeaver to Tinybird

DBeaver can connect to Tinybird using the ClickHouse® JDBC driver, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility. This enables you to use DBeaver's powerful SQL development and database management features with your Tinybird data.

{% callout type="info" %}
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.
{% /callout %}

## Prerequisites

- DBeaver Community or Enterprise Edition
- 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 connection

1. Click the **+** icon and select **New Connection**.
2. In the connection wizard, select **ClickHouse®** from the database list.
3. Click **Next** to proceed to the connection settings.

### Connection settings

Configure the main connection parameters:

```bash
Host: {% user("clickhouseHost") %}
Port: 443  # For HTTPS connections
Database: <WORKSPACE_NAME>  # Your workspace name
Connection name: Tinybird production
```

{% callout type="info" %}
See the list of [ClickHouse hosts](../clickhouse-interface#clickhouse-interface-hosts) to find the correct one for your region.
{% /callout %}

### Authentication

```bash
User name: <WORKSPACE_NAME>  # Not used for authentication, for identification only
User password: <TOKEN>  # Your Tinybird Auth Token
Save credentials for all users with access: yes
```

### SSL Configuration

1. Click the **SSL** tab.
1. Check **Enable SSL**. No certificates are required.


### Test and save

1. **Test Connection**: Click **Test Connection** to verify the setup
2. **Create connection**: Click **Create** to create the connection

{% image src="/img/dbeaver-clickhouse-connection-1.png" alt="DBeaver ClickHouse® connection configuration" caption="DBeaver ClickHouse® connection configuration" /%}

{% image src="/img/dbeaver-clickhouse-connection-2.png" alt="DBeaver ClickHouse® connection SSL configuration" caption="DBeaver ClickHouse® connection SSL configuration" /%}


## Test the connection

Once configured, test your connection by creating a simple query:

1. Select your newly created data connection and SQL Editor
2. For Database Authentication pop-up just click Login, don't fill SSL fields 
3. Write a simple query to test the connection

If the connection is working, you should see the result.

## Troubleshooting

**Transport error**

```plaintext
SQL Error [22000]: Code: 0. DB::Exception: <Unreadable error message> (transport error: 400)
```

Make sure you enabled SSL, in some DBeaver distributions you have to manually change `ssl` to `true` in the Driver properties.

## Learn more

- [ClickHouse Interface overview](../clickhouse-interface)
- [Tinybird Auth Token management](/classic/administration/auth-tokens)