Connect Metabase to Tinybird

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

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

Prerequisites

  • A Tinybird workspace with data sources
  • A Tinybird Auth Token with read permissions for the workspace data sources
  • ClickHouse® driver installed in Metabase (available by default in recent versions)

Add Tinybird as a database

  1. Access Admin Panel: In Metabase, click the gear icon and select Admin settings
  2. Navigate to Databases: Click Databases in the left sidebar
  3. Add a database: Click 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.<REGION>.tinybird.co  # Replace <REGION> with your region
Port: 8443  # Use 8443 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
  1. Save the database: Click Save to add the database to Metabase
Metabase ClickHouse® connection configuration
Metabase ClickHouse® connection configuration

Test the connection

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

  1. Click + 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

Updated