List Tables
list_tablesList all tables in a database to discover available tables, filter by name patterns, and get basic metadata like row counts and sizes. Use to identify tables before querying.
Instructions
List all tables in a database for exploration and discovery.
Use this tool to:
Discover what tables exist in a database
Filter tables by name pattern (like/not_like)
Get basic table metadata (name, engine, row counts, sizes, primary keys)
Returns basic table information WITHOUT column details for performance. Tables are returned with empty columns lists and is_summary_table not set.
IMPORTANT: Always call get_table_info(database, table) before querying a specific table. Column metadata (types, categories, merge functions) is required to build correct queries, especially for summary tables which need special -Merge function syntax. list_tables() is intentionally lightweight to avoid loading schema for all tables at once.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| like | No | ||
| not_like | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | Yes |