Set up docs MCPDatabase engines allow you to work with tables. By default, ClickHouse uses the Atomic database engine, which provides configurable table engines and an SQL dialect.
Here is a complete list of available database engines. Follow the links for more details:
| Page | Description |
|---|---|
| Shared | Page describing the Shared database engine, available in ClickHouse Cloud |
| Atomic | The Atomic engine supports non-blocking DROP TABLE and RENAME TABLE queries, and atomic EXCHANGE TABLESqueries. The Atomic database engine is used by default. |
| Replicated | The engine is based on the Atomic engine. It supports replication of metadata via DDL log being written to ZooKeeper and executed on all of the replicas for a given database. |
| PostgreSQL | Allows to connect to databases on a remote PostgreSQL server. |
| MySQL | Allows connecting to databases on a remote MySQL server and perform INSERT and SELECT queries to exchange data between ClickHouse and MySQL. |
| SQLite | Allows to connect to SQLite databases and perform INSERT and SELECT queries to exchange data between ClickHouse and SQLite. |
| MaterializedPostgreSQL | Creates a ClickHouse database with tables from PostgreSQL database. |
| Backup | Allows to instantly attach table/database from backups in read-only mode. |
| DataLakeCatalog | The DataLakeCatalog database engine enables you to connect ClickHouse to external data catalogs and query open table format data |