Skip to main content
Database configurations connect OpenLIT to ClickHouse. They are scoped to the active project, so each project can use its own database connection.

​
Add a database configuration

1

Open Organisation

Select Organisation from the sidebar.
2

Open a project

Choose the project that should own the database configuration.
3

Add config

Click Add database config and enter the ClickHouse connection details.
4

Test and save

Test the connection, then save the configuration.
5

Select config

Select the database configuration from the project page or the top navigation selector.

​
Selection behavior

The active database configuration is scoped to the current user and project. Switching projects updates the available database configurations. If a project does not have a database configuration, OpenLIT guides you through onboarding before showing data pages.

​
Multiple databases

A project can have multiple database configurations. Use multiple configurations when you need to switch between environments or ClickHouse clusters without changing the organisation.

Multiple database guide

Learn more about using multiple ClickHouse database configurations in OpenLIT.