system.database_engines - ClickHouse Documentation

Description

Contains the list of database engines supported by the server.

Columns

name (String) — The name of database engine.

Example

Query

SELECT *
FROM system.database_engines
WHERE name IN ('Atomic', 'Lazy', 'Ordinary')

Response

┌─name─────┐
│ Ordinary │
│ Atomic   │
│ Lazy     │
└──────────┘

Last modified on June 19, 2026

system.database_replicasSystem table containing information about and status of replicated database.