Create a database in a ClickHouse® cluster

Last update: October 05 2026Open in Markdown

When creating a ClickHouse® cluster, the default database is automatically created. You cannot create a new database with the same name.

1. Connect to the cluster.

2. Create a database using an SQL query:

   CREATE DATABASE <database_name>;

   Specify <database_name> — the database name.

For more information on creating databases, see the CREATE DATABASE guide in the ClickHouse® documentation.

ClickHouse® is a registered trademark of ClickHouse, Inc. https://clickhouse.com.