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.

Tinybird does not support Metabase's Roles or Impersonation features. You will be able to access the data but the permissions will be handled by the Tinybird Token used to configure the 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.tinybird.co
Port: 443  # Use 443 for HTTPS
Databases: <WORKSPACE_NAME> tinybird organization  # Your workspace name and service datasources

See the list of ClickHouse hosts to find the correct one for your region.

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