clickhouse-list-tables

A “clickhouse-list-tables” tool lists all tables in a specific ClickHouse database.

About

A clickhouse-list-tables tool lists all available tables in a specified ClickHouse database. It’s compatible with the clickhouse source.

This tool executes the SHOW TABLES FROM <database> command and returns a list of all tables in the specified database that are accessible to the configured user, making it useful for schema exploration and table discovery tasks.

Example

tools:
  list_clickhouse_tables:
    kind: clickhouse-list-tables
    source: my-clickhouse-instance
    description: List all tables in a specific ClickHouse database

Parameters

parametertyperequireddescription
databasestringtrueThe database to list tables from.

Return Value

The tool returns an array of objects, where each object contains:

  • name: The name of the table
  • database: The database the table belongs to

Example response:

[
  {"name": "users", "database": "analytics"},
  {"name": "events", "database": "analytics"},
  {"name": "products", "database": "analytics"},
  {"name": "orders", "database": "analytics"}
]

Reference

fieldtyperequireddescription
kindstringtrueMust be “clickhouse-list-tables”.
sourcestringtrueName of the ClickHouse source to list tables from.
descriptionstringtrueDescription of the tool that is passed to the LLM.
authRequiredarray of stringfalseAuthentication services required to use this tool.
parametersarray of ParameterfalseParameters for the tool (see Parameters section above).