Get Table Statistics
mysql_table_statsGet row count, data size, and index size for MySQL tables. Filter by database or table, output as markdown or JSON.
Instructions
Get row count and size statistics for tables in a database.
Args:
database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.
table (string, optional): Filter to a specific table. If omitted, returns all tables.
response_format ('markdown' | 'json'): Output format (default: 'markdown')
Returns per table: table_name, row_count, data_size_mb, index_size_mb, engine, create_time
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (uses MYSQL_DATABASE env var if omitted) | |
| table | No | Optional: filter to a specific table name | |
| response_format | No | Output format: 'markdown' or 'json' | markdown |