Skip to content

ultram4rine/sqltools-clickhouse-driver

Repository files navigation

SQLTools ClickHouse Driver

Visual Studio Marketplace Version Open VSX Version License CI/CD

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 22.8 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.