mysql_show_indexes
Display all indexes for a specified MySQL table to analyze database performance and optimize query execution.
Instructions
Show indexes for a specific table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (uses current database if not specified) | |
| table | Yes | Table name to show indexes for |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (uses current database if not specified)",
"type": "string"
},
"table": {
"description": "Table name to show indexes for",
"type": "string"
}
},
"required": [
"table"
],
"type": "object"
}