Get Largest Tables
get_largest_tablesIdentify the largest Magento tables by storage size to spot bloated tables before running broad queries. Returns top N tables with sizes from INFORMATION_SCHEMA.
Instructions
Returns the biggest Magento tables by storage size (DATA + INDEX) from INFORMATION_SCHEMA. Use to find bloated tables before running broad SELECTs. Row counts are approximate for InnoDB.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of largest tables to return (default 20, max 100). | |
| 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 |