mysql_show_indexes

Display indexes for a MySQL table to analyze query performance and optimize database structure. Specify the table name and optionally the database.

Instructions

Show indexes for a specific table

Input Schema

TableJSON Schema

Name	Required	Description	Default
`table`	Yes	Table name to show indexes for
`database`	No	Database name (uses current database if not specified)

Implementation Reference

src/index.ts:421-447 (handler)

The main handler function for the 'mysql_show_indexes' tool. It validates input, constructs the full table name, executes the 'SHOW INDEX FROM <table>' SQL query using the MySQL pool, and returns the results as formatted text content.

private async handleShowIndexes(args: any) {
  if (!this.pool) {
    throw new Error("Not connected to MySQL. Use mysql_connect first.");
  }

  const { table, database } = args;
  
  if (!table) {
    throw new Error("Table name is required");
  }

  const fullTableName = database ? `\`${database}\`.\`${table}\`` : `\`${table}\``;

  try {
    const [results] = await this.pool.execute(`SHOW INDEX FROM ${fullTableName}`);
    return {
      content: [
        {
          type: "text",
          text: `Indexes for table '${table}':\n${JSON.stringify(results, null, 2)}`,
        },
      ],
    };
  } catch (error) {
    throw new Error(`Failed to show indexes: ${error instanceof Error ? error.message : String(error)}`);
  }
}

src/index.ts:196-213 (registration)

Tool registration in the ListTools handler, defining the name, description, and input schema for 'mysql_show_indexes'.

{
  name: "mysql_show_indexes",
  description: "Show indexes for a specific table",
  inputSchema: {
    type: "object",
    properties: {
      table: {
        type: "string",
        description: "Table name to show indexes for",
      },
      database: {
        type: "string",
        description: "Database name (uses current database if not specified)",
      },
    },
    required: ["table"],
  },
},

src/index.ts:199-212 (schema)

Input schema (JSON Schema) for the mysql_show_indexes tool, specifying required 'table' parameter and optional 'database'.

inputSchema: {
  type: "object",
  properties: {
    table: {
      type: "string",
      description: "Table name to show indexes for",
    },
    database: {
      type: "string",
      description: "Database name (uses current database if not specified)",
    },
  },
  required: ["table"],
},

src/index.ts:259-260 (registration)
Dispatch case in the CallToolRequest handler that routes calls to the mysql_show_indexes tool to its handler function.
```
case "mysql_show_indexes":
  return await this.handleShowIndexes(args);
```

MCP MySQL Server