Execute ClickHouse Query
Execute a SQL query in ClickHouse and return the results. This is the primary action for querying data from ClickHouse databases.
ActionTry it
Integrate ClickHouse
with your AI workspace
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
Explore Triggers and Actions
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.
ActionTry it
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.
ActionTry it
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.
ActionTry it
List ClickHouse Databases
List all databases in the ClickHouse instance. Useful for discovering available databases before querying tables.
ActionTry it
List ClickHouse Tables
List tables in ClickHouse databases. Returns information about tables including their engine, size, and row count.
ActionTry it