MySQL MCP Server

Instructions

Implementation Reference

• src/server.ts:304-315 (handler)

  MCP tool handler for 'mysql_list_databases' that delegates to DatabaseManager.listDatabases() and formats the response as MCP content.

  private async handleListDatabases(): Promise<any> {
    const databases = await this.dbManager.listDatabases();
    
    return {
      content: [
        {
          type: 'text',
          text: `数据库列表:\n${JSON.stringify(databases, null, 2)}`,
        },
      ],
    };
  }

• src/server.ts:63-70 (schema)

  Tool schema definition: name, description, and empty input schema for mysql_list_databases.

  {
    name: 'mysql_list_databases',
    description: '列出所有数据库',
    inputSchema: {
      type: 'object',
      properties: {},
    },
  },

• src/server.ts:237-238 (registration)

  Dispatch registration in CallToolRequest handler switch statement mapping tool name to handler.

  case 'mysql_list_databases':
    return await this.handleListDatabases();

• src/database.ts:82-94 (helper)

  Core helper method in DatabaseManager that executes SQL query to list databases, excluding system databases.

  async listDatabases(): Promise<DatabaseInfo[]> {
    const result = await this.query(`
      SELECT 
        SCHEMA_NAME as name,
        DEFAULT_CHARACTER_SET_NAME as charset,
        DEFAULT_COLLATION_NAME as collation
      FROM information_schema.SCHEMATA
      WHERE SCHEMA_NAME NOT IN ('information_schema', 'performance_schema', 'mysql', 'sys')
      ORDER BY SCHEMA_NAME
    `);
    
    return result.rows as DatabaseInfo[];
  }