Alibaba Cloud AnalyticDB for MySQL + Roo Code: Complete MCP Integration

Alibaba Cloud AnalyticDB for MySQL is a MCP server that Connect to a AnalyticDB for MySQL cluster for getting database or table metadata, querying and analyzing data.It will be supported to add the openapi for cluster operation in the future..

When integrated with Roo Code, you can:

• Execute SQL queries on AnalyticDB for MySQL
• Retrieve query execution plan for optimization
• Get detailed execution plan with runtime statistics

This guide provides step-by-step instructions to set up Alibaba Cloud AnalyticDB for MySQL in Roo Code, including configuration, examples, and troubleshooting.

What You'll Achieve

After completing this setup:

• Alibaba Cloud AnalyticDB for MySQL will be fully integrated and operational
• You can use Alibaba Cloud AnalyticDB for MySQL tools directly in Roo Code
• All Alibaba Cloud AnalyticDB for MySQL capabilities will be available for your workflows
• Access to 5 different tools

Prerequisites

Before starting, ensure you have:

• AnalyticDB for MySQL cluster endpoint
• Database username
• Database password
• Roo Code installed and configured
• Compatible operating system (Windows, macOS, Linux)

Installation

Step 1: Install Alibaba Cloud AnalyticDB for MySQL

Configuration

Step 2: Configure Roo Code

1. Locate your configuration file:

   • Windows: %USERPROFILE%\.roo\mcp_settings.json
   • macOS: ~/.roo/mcp_settings.json
   • Linux: ~/.roo/mcp_settings.json

2. Add server configuration:

{
  "mcpServers": {
    "alibaba-cloud-analyticdb-for-mysql": {
      "command": "npx",
      "args": ["-y", "alibaba-cloud-analyticdb-for-mysql"],
      "env": {
        "ADB_MYSQL_HOST": "adb-cluster-123.mysql.rds.aliyuncs.com",
        "ADB_MYSQL_PORT": "3306",
        "ADB_MYSQL_USER": "analytics_user",
        "ADB_MYSQL_PASSWORD": "secure_password123",
        "ADB_MYSQL_DATABASE": "analytics_db"
      }
    }
  }
}

3. Restart Roo Code

Completely quit and restart Roo Code to load the new configuration.

Examples

Once configured, you can use Alibaba Cloud AnalyticDB for MySQL in Roo Code:

Real-time Analytics Dashboard

undefined

Ask Roo Code: "Execute hourly sales aggregation and performance metrics"

Expected Result: undefined

Data Warehouse Optimization

undefined

Ask Roo Code: "Analyze execution plan for monthly revenue report"

Expected Result: undefined

Schema Management

undefined

Ask Roo Code: "Document all tables and their relationships in the analytics database"

Expected Result: undefined

Testing Your Setup

1. Start a new conversation in Roo Code
2. Ask Roo Code to list available tools
3. Try using Alibaba Cloud AnalyticDB for MySQL functionality

Test prompts:

• "Type @ and verify Alibaba Cloud AnalyticDB for MySQL appears in the tools list"
• "Ask: "Use Alibaba Cloud AnalyticDB for MySQL to help with my task""
• "Check Roo Code output panel for server connection status"

Troubleshooting

Common Issues

MCP Server Not Connecting

Symptoms: Server not appearing in tools list, Connection timeout, MCP tools unavailable

Cause: Incorrect configuration or server not starting

Solution:

• Verify mcp_settings.json syntax is correct
• Check that Node.js and npx are installed and in PATH
• View Roo Code output panel for error messages
• Test server command manually in terminal: npx -y {server_id}
• Ensure environment variables are properly set

Permission Denied Errors

Symptoms: Cannot execute commands, File access denied, Terminal commands blocked

Cause: Roo Code requires explicit permission for file and command operations

Solution:

• Review and approve permission requests when prompted
• Check VS Code workspace trust settings
• Enable necessary permissions in Roo Code settings
• Verify file and folder permissions on your system

API Key or Model Issues

Symptoms: Authentication failed, Model not responding, No AI completions

Cause: AI model API key not configured or invalid

Solution:

• Verify API key is correctly set in Roo Code settings
• Check API key has sufficient credits/quota
• Test with a different AI model provider
• Review Roo Code output panel for API error details

Custom Mode Not Working with MCP

Symptoms: MCP tools not available in custom mode, Mode cannot access server

Cause: Custom mode configuration does not include MCP tool permissions

Solution:

• Edit custom mode configuration to include MCP tools
• Add "Use MCP" to available tools in mode definition
• Ensure mode has appropriate permissions for external tools
• Test with default mode first to verify MCP server works

Extension Conflicts

Symptoms: Roo Code not responding, VS Code performance issues, Unexpected behavior

Cause: Conflicts with other AI coding extensions

Solution:

• Disable other AI coding extensions (Cline, Continue, etc.)
• Restart VS Code after disabling conflicting extensions
• Check VS Code extension logs for conflict errors
• Use only one AI coding assistant extension at a time

Alibaba Cloud AnalyticDB for MySQL not appearing in Roo Code

Symptoms: Server not listed, Tools not available

Cause: Configuration or installation issue

Solution:

• Verify configuration syntax
• Check Alibaba Cloud AnalyticDB for MySQL installation
• Restart Roo Code
• Check logs for error messages

Next Steps

Now that Alibaba Cloud AnalyticDB for MySQL is integrated with Roo Code:

• Explore all Alibaba Cloud AnalyticDB for MySQL capabilities through Roo Code
• Check out other MCP servers that work with Roo Code
• Join the MCP community for tips and support
• Consider contributing to Alibaba Cloud AnalyticDB for MySQL development

Need Help?

• Search for Alibaba Cloud AnalyticDB for MySQL documentation
• Check the Roo Code MCP guide
• Join the MCP community discussions