MySQL MCP Server

Instructions

Implementation Reference

• src/server.ts:343-354 (handler)

  The handler function for the 'mysql_list_tables' tool. It calls DatabaseManager.listTables and returns the formatted result as tool content.

  private async handleListTables(args: { database?: string }): Promise<any> {
    const tables = await this.dbManager.listTables(args.database);
    
    return {
      content: [
        {
          type: 'text',
          text: `表列表:\n${JSON.stringify(tables, null, 2)}`,
        },
      ],
    };
  }

• src/database.ts:123-144 (helper)

  Core implementation in DatabaseManager that executes the SQL query against information_schema.TABLES to list tables in the specified database.

  async listTables(database?: string): Promise<TableInfo[]> {
    const dbName = database || this.config?.database;
    if (!dbName) {
      throw new Error('请指定数据库名称');
    }
  
    const result = await this.query(`
      SELECT 
        TABLE_NAME as name,
        ENGINE as engine,
        TABLE_ROWS as rows,
        DATA_LENGTH as dataLength,
        INDEX_LENGTH as indexLength,
        TABLE_COMMENT as comment
      FROM information_schema.TABLES
      WHERE TABLE_SCHEMA = ?
      AND TABLE_TYPE = 'BASE TABLE'
      ORDER BY TABLE_NAME
    `, [dbName]);
    
    return result.rows as TableInfo[];
  }

• src/server.ts:96-104 (schema)

  Input schema definition for the 'mysql_list_tables' tool, specifying optional 'database' parameter.

    name: 'mysql_list_tables',
    description: '列出指定数据库的所有表',
    inputSchema: {
      type: 'object',
      properties: {
        database: { type: 'string', description: '数据库名称（可选，使用当前连接的数据库）' },
      },
    },
  },

• src/server.ts:243-244 (registration)

  Switch case registration that routes 'mysql_list_tables' tool calls to the handleListTables handler.

  case 'mysql_list_tables':
    return await this.handleListTables(args as any);