list_tables
List ClickHouse tables in a database with optional pattern filtering, pagination, and column detail control. Each table shows schema, comment, row count, and column count for quick database inspection.
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 to filter table names not_like: Optional NOT LIKE pattern to exclude table names 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 JSON-encoded string of an object 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 |
|---|---|---|---|
| result | Yes |