Connect Metabase to Tinybird¶

Metabase can connect to Tinybird using the ClickHouse® database driver, taking advantage of Tinybird's ClickHouse® HTTP protocol compatibility. Create dashboards, explore data, and build business intelligence reports with your Tinybird data.

Prerequisites¶

• 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® driver installed in Metabase (available by default in recent versions)

Add Tinybird as a database¶

1. Access Admin Panel: In Metabase, select the gear icon and select Admin settings
2. Navigate to Databases: Select Databases
3. Add a database: Select Add database button
4. Select ClickHouse®: Choose ClickHouse® from the database type dropdown

Database configuration¶

Configure the connection with these settings:

Display name: Tinybird Production  # Choose a descriptive name
Host: clickhouse.tinybird.co
Port: 443  # Use 443 for HTTPS
Databases: <WORKSPACE_NAME> tinybird organization  # Your workspace name and service datasources

Authentication¶

Username: <WORKSPACE_NAME>  # not used for auth, helps you identify the connection
Password: <TOKEN>  # Your Tinybird Auth Token

Advanced options¶

Use a secure connection (SSL): enabled

5. Save the database: Select Save to add the database to Metabase

Test the connection¶

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

1. Select + New to create new SQL query
2. Select your newly created database
3. Write a simple query to test the connection

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

Learn more¶

• ClickHouse® Interface overview
• Tinybird Auth Token management