MCP MySQL Server

Instructions

Implementation Reference

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

  The handler function that executes the SHOW INDEX query to retrieve indexes for the specified table on the connected MySQL database.

  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:198-212 (schema)

  Input schema definition specifying the parameters for the mysql_show_indexes tool: required 'table' and optional 'database'.

  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:196-213 (registration)

  Tool registration entry in the ListTools response, including name, description, and input schema.

  {
    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:259-260 (registration)

  Switch case in CallToolRequest handler that dispatches to the mysql_show_indexes handler function.

  case "mysql_show_indexes":
    return await this.handleShowIndexes(args);