Documentation Index
Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt
Use this file to discover all available pages before exploring further.
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 |