What to Ask Leina to Do with ClickHouse
Copy a prompt, add your details, and send it to Leina in your connected team chat.
Read table metadata and use the column definitions to propose a query for your question.
Read ClickHouse database [database], table [table] schema. Explain relevant columns and keys for [analysis question], then propose a SELECT query with assumptions clearly stated.
Execute your SELECT query and organize rows, columns, and execution statistics into an explanation.
Run this approved ClickHouse SELECT query [query] in database [database] with maximum execution time [seconds]. Explain the rows for [question], state filters and aggregation, and preserve missing values.
Get Started with ClickHouse
-
Connect Your Account
Connect with a ClickHouse endpoint, username, and password.
-
Try a Task
Tell Leina what you need in your team chat. Include the source, destination, and expected result.
Set Up Leina in Your Chat → -
Check the Result
Review the result and any changes in the connected app.
Supported ClickHouse Capabilities
ClickHouse table metadata describes the available columns and keys, while query results provide rows and execution statistics. These support analytical explanations tied to an explicit query.
- Explore Databases and Schemas
-
List databases and tables, inspect table columns and keys, and read a database schema overview.
- List Databases
- List Tables
- Execute SQL Queries
-
Execute a supplied query with database, time-limit, and settings options and retrieve rows, columns, and statistics.
- Execute Query
View All 5 Actions
- Execute Query
- List Databases
- List Tables
- Get Table Schema
- Get Database Schema
Frequently Asked Questions
Can AI inspect columns before proposing SQL?
Yes. Provide the database and table; schema lookup describes columns and table keys, with optional sample data.
Can the explanation state the query’s scope?
Yes. Ask it to show the filters, grouping, and time range from the query alongside the returned rows.
Is query execution restricted to read-only SQL?
The connection executes supplied SQL using the database user’s permissions. Use a read-only database user for analysis and request SELECT queries explicitly.
Your AI employee for ClickHouse
Tell Leina what you need in your team chat. Include the source, destination, and expected result.