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

Installation

Step 1: Install Alibaba Cloud AnalyticDB for MySQL

Configuration

Step 2: Configure OpenCode

1. Locate your configuration file:

2. Add server configuration:

Configure MCP servers in your `opencode.json` or `opencode.jsonc`:

```json
{
  "mcp": {
    "my-mcp": {
      "type": "local",
      "command": ["npx", "-y", "@modelcontextprotocol/server-everything"],
      "environment": {
        "API_KEY": "$API_KEY"
      },
      "timeout": 5000
    },
    "remote-server": {
      "type": "remote",
      "url": "https://mcp.example.com/sse",
      "headers": {
        "Authorization": "Bearer $API_TOKEN"
      }
    }
  }
}

Disable a server temporarily:

{
  "mcp": {
    "my-mcp": {
      "type": "local",
      "command": ["npx", "-y", "mcp-server"],
      "enabled": false
    }
  }
}

3. **Restart OpenCode**

Completely quit and restart OpenCode to load the new configuration.



## Examples

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

### Real-time Analytics Dashboard

undefined

**Ask OpenCode:** "Execute hourly sales aggregation and performance metrics"

**Expected Result:** undefined

### Data Warehouse Optimization

undefined

**Ask OpenCode:** "Analyze execution plan for monthly revenue report"

**Expected Result:** undefined

### Schema Management

undefined

**Ask OpenCode:** "Document all tables and their relationships in the analytics database"

**Expected Result:** undefined



## Testing Your Setup

1. Run opencode in terminal
2. Add "use the mcp_name tool" to your prompts
3. Verify tool execution and response



## Troubleshooting

### Common Issues

#### MCP Server Not Loading

**Symptoms:** Server not appearing in tools, Timeout errors, Command not found

**Cause:** Invalid configuration, missing dependencies, or timeout too short

**Solution:**
- Verify command array is correct in opencode.json
- Check environment variables are set properly
- Increase timeout value if server takes longer to start
- Test MCP server command independently in terminal

#### Context Limit Exceeded

**Symptoms:** Context too large errors, Slow responses, Truncated output

**Cause:** Too many MCP servers adding to context

**Solution:**
- Disable unused MCP servers with enabled: false
- Use per-agent tool configuration to limit active MCPs
- Avoid MCP servers that add many tokens (e.g., GitHub MCP)

#### Remote Server Connection Failed

**Symptoms:** Cannot connect to remote MCP, Authentication errors

**Cause:** Invalid URL, missing headers, or network issues

**Solution:**
- Verify remote server URL is correct
- Check authorization headers are properly configured
- Ensure environment variables for tokens are set

#### Alibaba Cloud AnalyticDB for MySQL not appearing in OpenCode

**Symptoms:** Server not listed, Tools not available

**Cause:** Configuration or installation issue

**Solution:**
- Verify configuration syntax
- Check Alibaba Cloud AnalyticDB for MySQL installation
- Restart OpenCode
- Check logs for error messages



## Next Steps

Now that Alibaba Cloud AnalyticDB for MySQL is integrated with OpenCode:

- Explore all Alibaba Cloud AnalyticDB for MySQL capabilities through OpenCode
- Check out other MCP servers that work with OpenCode
- 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](https://www.mcpstack.org)
- Check the [OpenCode MCP guide](https://www.mcpstack.org/clients)
- Join the MCP community discussions