SQLTools ClickHouse Driver

ClickHouse driver for SQLTools VS Code extension.

Installation

• Directly from VS Code by searching @tag:sqltools clickhouse or just clickhouse;
• From marketplace.
• Download vsix from releases.

Usage

After installation you will be able to explore tables and views, run queries, etc. For more details see SQLTools documentation.

Limits

• According to the docs of official ClickHouse nodejs client, this extension should be compatible with ClickHouse server version 24.8 and above. Older versions should work too, but you may lack of keywords completions.
• Don't use FORMAT clause. Driver already uses JSON format to show records and statistics.
• Don't send multiple queries, this is not supported by SQLTools (yet).