v.23.5New Feature

Add Schema Inference to PostgreSQL, MySQL, MeiliSearch, and SQLite Table Engines

Add schema inference to PostgreSQL, MySQL, MeiliSearch, and SQLite table engines. Closes #49972. #50000 (Nikolay Degterinsky).
Added automatic schema inference for PostgreSQL, MySQL, MeiliSearch, and SQLite table engines in ClickHouse.

Why it matters

This feature addresses the problem of manually defining table schemas when connecting ClickHouse to external data sources such as PostgreSQL, MySQL, MeiliSearch, and SQLite. By automatically inferring the schema, it simplifies integration, reduces configuration errors, and accelerates the process of setting up external tables.

How to use it

When creating a table with one of the supported external table engines (PostgreSQL, MySQL, MeiliSearch, or SQLite), users can enable schema inference by omitting explicit column definitions. ClickHouse will automatically retrieve and apply the schema from the external data source.