ClickHouse

Column-oriented analytics database service for ad-hoc SQL queries, database listings, table schemas, and interactive query consoles.

Tailored to analytics workflows that run SQL queries against ClickHouse, inspect database and table schemas, and load the Play web console.

Use ClickHouse with Snow

Snow is a personal AI assistant that builds real apps for you, and they can put ClickHouse to work.

These are the ClickHouse actions available to the apps you build with Snow. Connecting an account does not make Snow run these on its own.

Execute ClickHouse Query
Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
Get Database Schema
Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. Essential for AI agents to understand the complete database structure in a single call.
Get Table Schema
Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. This is essential for AI agents to understand table structure before constructing queries.
List ClickHouse Databases
List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
List ClickHouse Tables
List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
Get ClickHouse Play Interface
Get the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.

Column-oriented analytics database service for ad-hoc SQL queries, database listings, table schemas, and interactive query consoles.

Tailored to analytics workflows that run SQL queries against ClickHouse, inspect database and table schemas, and load the Play web console.

Snow is a personal AI assistant that builds real apps for you, and they can put ClickHouse to work.

These are the ClickHouse actions available to the apps you build with Snow. Connecting an account does not make Snow run these on its own.

Execute ClickHouse Query
Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
Get Database Schema
Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. Essential for AI agents to understand the complete database structure in a single call.
Get Table Schema
Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. This is essential for AI agents to understand table structure before constructing queries.
List ClickHouse Databases
List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
List ClickHouse Tables
List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
Get ClickHouse Play Interface
Get the ClickHouse Play web user interface for interactive query execution. Returns HTML page with Monaco Editor for writing queries and visualizing results.