MySQL List Tables
mysql_list_tablesRetrieve all tables and views from a MySQL database with metadata including name, type, and schema. Use this to explore database structure.
Instructions
List all tables and views in the database with metadata.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | No | Alias for database | |
| limit | No | Maximum number of tables to return (default: 50). Anti-Hallucination Hint: To get details for a specific table, use describeTable instead. | |
| schema | No | Alias for database | |
| database | No | Database name (defaults to connected database) |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| data | No | ||
| error | No | Error message if operation failed | |
| details | No | Additional error context | |
| metrics | No | Token estimation metrics | |
| success | Yes | Whether the operation succeeded | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |