get_schema_info
Retrieve column metadata (names, data types, nullability, defaults, comments) for a specified table or all tables in the database. Use before querying unfamiliar tables.
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. |