get_schema_info
Retrieve column metadata for tables: names, data types, nullability, defaults, and comments. Use before querying an unfamiliar table to understand its structure.
Instructions
Get column metadata for a table or all tables in the configured database: column names, data types, nullability, default values, and comments. Call this before querying an unfamiliar table. Omit table_name to see all tables at once. Accepts bare table names (uses MYSQL_DATABASE) or database.table for cross-database lookups.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | No | Optional: bare table name, or database.table for a cross-database lookup. |