Database Engines

Documentation for Database Engines

Database 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