create_index
Create database indexes on MySQL tables to improve query performance by specifying columns, index name, and uniqueness constraints.
Instructions
Create an index on a table
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| indexName | Yes | Index name | |
| columns | Yes | Column names to index | |
| unique | No | Whether this is a unique index | |
| database | No | Database name (optional) |
Implementation Reference
- src/index.ts:531-560 (handler)Handler function that executes the tool: connects to MySQL pool, constructs CREATE INDEX SQL query with optional UNIQUE, executes it, and returns success response with structured output.async ({ table, indexName, columns, unique, database }) => { const p = await getPool(); const tableName = database ? `\`${database}\`.\`${table}\`` : `\`${table}\``; const columnList = columns.map((c) => `\`${c}\``).join(", "); const uniqueStr = unique ? "UNIQUE " : ""; await p.execute( `CREATE ${uniqueStr}INDEX \`${indexName}\` ON ${tableName} (${columnList})` ); const output = { success: true, table, indexName, columns, unique: unique || false, database: database || null, }; return { content: [ { type: "text" as const, text: `Index ${indexName} created successfully on ${table}`, }, ], structuredContent: output, }; }
- src/index.ts:524-530 (schema)Zod schema for input validation: table (string), indexName (string), columns (array of strings), unique (optional boolean), database (optional string).{ table: z.string().describe("Table name"), indexName: z.string().describe("Index name"), columns: z.array(z.string()).describe("Column names to index"), unique: z.boolean().optional().describe("Whether this is a unique index"), database: z.string().optional().describe("Database name (optional)"), },
- src/index.ts:521-561 (registration)MCP server.tool registration call for 'create_index' tool, specifying name, description, input schema, and inline handler function.server.tool( "create_index", "Create an index on a table", { table: z.string().describe("Table name"), indexName: z.string().describe("Index name"), columns: z.array(z.string()).describe("Column names to index"), unique: z.boolean().optional().describe("Whether this is a unique index"), database: z.string().optional().describe("Database name (optional)"), }, async ({ table, indexName, columns, unique, database }) => { const p = await getPool(); const tableName = database ? `\`${database}\`.\`${table}\`` : `\`${table}\``; const columnList = columns.map((c) => `\`${c}\``).join(", "); const uniqueStr = unique ? "UNIQUE " : ""; await p.execute( `CREATE ${uniqueStr}INDEX \`${indexName}\` ON ${tableName} (${columnList})` ); const output = { success: true, table, indexName, columns, unique: unique || false, database: database || null, }; return { content: [ { type: "text" as const, text: `Index ${indexName} created successfully on ${table}`, }, ], structuredContent: output, }; } );