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.

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

  • DBeaver Community or Enterprise Edition
  • A Tinybird workspace with data sources
  • A Tinybird Auth Token with read permissions for the workspace data sources

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:

Host: clickhouse.<REGION>.tinybird.co  # Replace <REGION> with your region
Port: 443  # For HTTPS connections
Database: <WORKSPACE_NAME>  # Your workspace name
Connection name: Tinybird production

Authentication

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.
  2. 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
DBeaver ClickHouse® connection configuration
DBeaver ClickHouse® connection configuration
DBeaver ClickHouse® connection SSL configuration
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.

Learn more

Updated