MCP Server MySQL

Instructions

Implementation Reference

• src/index.ts:445-465 (handler)

  The handler function for the 'create_database' tool. It creates a new MySQL database using the provided name, charset, and collation, then returns a success response with structured output.

  async ({ database, charset, collation }) => {
    const p = await getPool();
    const cs = charset || "utf8mb4";
    const col = collation || "utf8mb4_unicode_ci";
  
    await p.execute(
      `CREATE DATABASE \`${database}\` CHARACTER SET ${cs} COLLATE ${col}`
    );
  
    const output = { success: true, database, charset: cs, collation: col };
  
    return {
      content: [
        {
          type: "text" as const,
          text: `Database ${database} created successfully`,
        },
      ],
      structuredContent: output,
    };
  }

• src/index.ts:440-444 (schema)

  The input schema (Zod) for the 'create_database' tool defining parameters: database (required string), charset and collation (optional strings).

  {
    database: z.string().describe("Database name"),
    charset: z.string().optional().describe("Character set (default: utf8mb4)"),
    collation: z.string().optional().describe("Collation (default: utf8mb4_unicode_ci)"),
  },

• src/index.ts:437-466 (registration)

  The registration of the 'create_database' tool using server.tool(), including name, description, input schema, and handler function.

  server.tool(
    "create_database",
    "Create a new database",
    {
      database: z.string().describe("Database name"),
      charset: z.string().optional().describe("Character set (default: utf8mb4)"),
      collation: z.string().optional().describe("Collation (default: utf8mb4_unicode_ci)"),
    },
    async ({ database, charset, collation }) => {
      const p = await getPool();
      const cs = charset || "utf8mb4";
      const col = collation || "utf8mb4_unicode_ci";
  
      await p.execute(
        `CREATE DATABASE \`${database}\` CHARACTER SET ${cs} COLLATE ${col}`
      );
  
      const output = { success: true, database, charset: cs, collation: col };
  
      return {
        content: [
          {
            type: "text" as const,
            text: `Database ${database} created successfully`,
          },
        ],
        structuredContent: output,
      };
    }
  );