Awesome

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 nodejs client, this extension should be compatible with ClickHouse version 23.3 and above.
• 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).
• Use LIMIT when selecting a large amount of data, otherwise the results may take a long time to load.