List Database Tables
list_tablesDiscover Magento database tables by name pattern or all tables at once. Use to find relevant tables before exploring columns.
Instructions
Lists Magento database tables, optionally filtered by SQL LIKE pattern (e.g. 'sales_%'). Use describe_table for column details. Use search_columns when you know a column name but not the table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | No | SQL LIKE pattern for table names (e.g. 'sales_%', '%customer%'). Omit to list all tables. | |
| profile | No | Override the MAGENTO_SQL_PROFILE env var for this call only. Use list_connection_profiles to see available names. | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |