List tables
list_tablesList user tables with schema, row count, data and index size, and dates to find tables by name or schema and spot large ones. Filter by database, schema, or name pattern.
Instructions
Lists user tables with schema, approximate row count, data and index size in MB, and creation and modification dates. Use it to find tables by name or schema and to spot the large ones; to find tables by a column they hold use find_columns, and for one table's columns and keys use get_table_schema. Narrow large databases with schema and name_pattern.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Filter by schema name. Empty means every schema. Example: 'Feeder' | |
| database | Yes | Name of the database as registered in the configuration. | |
| name_pattern | No | Filter by table name. A pattern without % matches anywhere in the name, so 'Security' finds GenericSecurity; add % yourself for a prefix or suffix match, as in 'Anbima%'. Empty means every table. |