list_tables
List ClickHouse tables in a database with schema details, row count, and column count. Filter by name patterns and paginate results.
Instructions
List available ClickHouse tables in a database, including schema, comment, row count, and column count.
Args: database: The database to list tables from like: Optional LIKE pattern(s) to filter table names. Can be a single string or list of strings. Multiple patterns are combined with OR logic. not_like: Optional NOT LIKE pattern(s) to exclude table names. Can be a single string or list of strings. Multiple patterns are combined with OR logic. page_token: Token for pagination, obtained from a previous call page_size: Number of tables to return per page (default: 50) include_detailed_columns: Whether to include detailed column metadata (default: True). When False, the columns array will be empty but create_table_query still contains all column information. This reduces payload size for large schemas.
Returns: A dictionary containing: - tables: List of table information (as dictionaries) - next_page_token: Token for the next page, or None if no more pages - total_tables: Total number of tables matching the filters
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| like | No | ||
| not_like | No | ||
| page_token | No | ||
| page_size | No | ||
| include_detailed_columns | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||