Alibaba Cloud AnalyticDB for MySQL + Amazon Q CLI: 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 Amazon Q CLI, 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 Amazon Q CLI, 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 Amazon Q CLI
• 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
• Amazon Q CLI installed and configured
• Compatible operating system (Windows, macOS, Linux)

Installation

Step 1: Install Alibaba Cloud AnalyticDB for MySQL

Configuration

Step 2: Configure Amazon Q CLI

1. Install Amazon Q CLI

Download and install Q CLI for your platform

Visit: https://docs.aws.amazon.com/amazonq/latest/qdeveloper-ug/command-line-installing.html

2. Authenticate

Set up authentication with AWS Builder ID or IAM Identity Center

q auth

Note: Follow interactive authentication flow

3. Verify Installation

Test Q CLI installation and configuration

q doctor

4. Install MCP Server

Install the MCP server you want to integrate

Note: Ensure server is accessible from command line

5. Configure MCP Integration

Add MCP server configuration to Q CLI

Note: Use q config commands to set server parameters

6. Test Integration

Verify MCP server works with Q CLI

q chat "Use Alibaba Cloud AnalyticDB for MySQL to help me"

Configuration Details

Configure MCP servers through Q CLI commands:

# Configure MCP server integration
q config set mcp.servers.alibaba-cloud-analyticdb-for-mysql.command "alibaba cloud analyticdb for mysql"
q config set mcp.servers.alibaba-cloud-analyticdb-for-mysql.args ""
q config set mcp.servers.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""

# Verify configuration
q config list mcp.servers

Examples

Once configured, you can use Alibaba Cloud AnalyticDB for MySQL in Amazon Q CLI:

Real-time Analytics Dashboard

undefined

Ask Amazon Q CLI: "Execute hourly sales aggregation and performance metrics"

Expected Result: undefined

Data Warehouse Optimization

undefined

Ask Amazon Q CLI: "Analyze execution plan for monthly revenue report"

Expected Result: undefined

Schema Management

undefined

Ask Amazon Q CLI: "Document all tables and their relationships in the analytics database"

Expected Result: undefined

Testing Your Setup

1. Run q doctor to verify system health
2. Start Q CLI chat session
3. Ask Q to list available MCP tools
4. Test specific Alibaba Cloud AnalyticDB for MySQL functionality

Test commands:

q doctor

q chat

q config list mcp.servers

Troubleshooting

Common Issues

Installation Failed

Symptoms: Q command not found, Installation errors

Cause: Incomplete installation or PATH issues

Solution:

• Verify installer completed successfully
• Check PATH environment variable includes Q CLI
• Try running q doctor for diagnostics
• Reinstall using platform-specific method

Authentication Problems

Symptoms: Auth errors, Cannot connect to AWS services

Cause: Invalid credentials or network issues

Solution:

• Run q auth to re-authenticate
• Verify AWS Builder ID or IAM credentials
• Check network connectivity to AWS
• Ensure proper AWS permissions are set

MCP Server Not Found

Symptoms: Server command not found, MCP tools unavailable

Cause: Server not installed or not in PATH

Solution:

• Verify MCP server installation
• Check server executable permissions
• Use absolute path in configuration
• Test server independently with direct command

Configuration Errors

Symptoms: Config commands fail, Settings not persisting

Cause: Invalid configuration syntax or permissions

Solution:

• Check Q CLI configuration file permissions
• Verify configuration syntax is correct
• Use q config list to review current settings
• Report issues with q issue command

Alibaba Cloud AnalyticDB for MySQL not appearing in Amazon Q CLI

Symptoms: Server not listed, Tools not available

Cause: Configuration or installation issue

Solution:

• Verify configuration syntax
• Check Alibaba Cloud AnalyticDB for MySQL installation
• Restart Amazon Q CLI
• Check logs for error messages

Next Steps

Now that Alibaba Cloud AnalyticDB for MySQL is integrated with Amazon Q CLI:

• Explore all Alibaba Cloud AnalyticDB for MySQL capabilities through Amazon Q CLI
• Check out other MCP servers that work with Amazon Q CLI
• 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 Amazon Q CLI MCP guide
• Join the MCP community discussions