Alibaba Cloud AnalyticDB for MySQL + MCPHub (mcp.nvim): 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 MCPHub (mcp.nvim), 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 MCPHub (mcp.nvim), 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 MCPHub (mcp.nvim)
- 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
- MCPHub (mcp.nvim) installed and configured
- Compatible operating system (Neovim 0.9+, Windows, macOS, Linux)
Installation
Step 1: Install Alibaba Cloud AnalyticDB for MySQL
Configuration
Step 2: Configure MCPHub (mcp.nvim)
- Open MCPHub (mcp.nvim) settings
- Navigate to MCP server configuration
- Add Alibaba Cloud AnalyticDB for MySQL server with appropriate settings
- Save and restart if needed
Examples
Once configured, you can use Alibaba Cloud AnalyticDB for MySQL in MCPHub (mcp.nvim):
Real-time Analytics Dashboard
undefined
Ask MCPHub (mcp.nvim): "Execute hourly sales aggregation and performance metrics"
Expected Result: undefined
Data Warehouse Optimization
undefined
Ask MCPHub (mcp.nvim): "Analyze execution plan for monthly revenue report"
Expected Result: undefined
Schema Management
undefined
Ask MCPHub (mcp.nvim): "Document all tables and their relationships in the analytics database"
Expected Result: undefined
Testing Your Setup
- Launch MCPHub (mcp.nvim)
- Verify Alibaba Cloud AnalyticDB for MySQL is available in the tools list
- Test basic Alibaba Cloud AnalyticDB for MySQL functionality
Troubleshooting
Common Issues
Plugin Not Loading or Command Not Found
Symptoms: :MCPHub command not recognized, Plugin not appearing in :PlugStatus, No errors but plugin inactive
Cause: Plugin not properly installed or configuration error
Solution:
- Verify plugin is added to plugin manager configuration
- Run plugin manager install command (:PackerInstall, :PlugInstall, or Lazy auto-install)
- Check for errors in :messages after sourcing config
- Ensure dependencies (plenary.nvim, nui.nvim) are installed
- Restart Neovim completely
MCP Server Won't Start
Symptoms: Server status shows "Error", Red indicator on server, Server immediately stops after starting
Cause: Invalid server configuration or missing dependencies
Solution:
- Verify npx is installed and in PATH: npx --version
- Check MCP server package exists: npx -y @modelcontextprotocol/server-filesystem --help
- Review server configuration in setup() - verify command and args
- Check server logs in MCPHub interface for detailed error messages
- Ensure required environment variables are set (e.g., GITHUB_TOKEN)
- Test server manually in terminal: npx -y @modelcontextprotocol/server-filesystem /path
UI Not Displaying Correctly
Symptoms: Blank window, Garbled text, Layout issues, Missing borders
Cause: Terminal or Neovim rendering issues
Solution:
- Verify Neovim version is 0.9 or higher: nvim --version
- Try different border style in ui.border config ("single", "double", "rounded")
- Check terminal supports Unicode and 256 colors
- Update nui.nvim dependency to latest version
- Test with different colorscheme to rule out theme conflicts
Integration with Avante/CodeCompanion Not Working
Symptoms: AI assistant not seeing MCP tools, Tool calls failing, Integration not recognized
Cause: Integration not enabled or incompatible versions
Solution:
- Verify integration is enabled in config: integrations.avante = true
- Ensure Avante.nvim/CodeCompanion.nvim is installed and loaded
- Check versions are compatible - update both plugins to latest
- Restart Neovim after enabling integration
- Check :checkhealth for integration-specific warnings
Marketplace Not Loading
Symptoms: :MCPHubMarketplace shows empty list, Network error in marketplace, Timeout loading servers
Cause: Network connectivity issues or marketplace service unavailable
Solution:
- Verify internet connectivity
- Check firewall allows HTTPS connections
- Try again later if marketplace service is temporarily down
- Review proxy settings if behind corporate firewall
- Check :messages for detailed network error messages
Project-Local Config Not Loading
Symptoms: .mcphub.json ignored, Project servers not appearing, Only global config loaded
Cause: Config file location or format issues
Solution:
- Verify .mcphub.json is in project root (same directory as .git)
- Check JSON syntax is valid using jsonlint or similar tool
- Ensure file name is exactly .mcphub.json (case-sensitive)
- Restart Neovim after creating/modifying project config
- Check file permissions are readable
Alibaba Cloud AnalyticDB for MySQL not appearing in MCPHub (mcp.nvim)
Symptoms: Server not listed, Tools not available
Cause: Configuration or installation issue
Solution:
- Verify configuration syntax
- Check Alibaba Cloud AnalyticDB for MySQL installation
- Restart MCPHub (mcp.nvim)
- Check logs for error messages
Next Steps
Now that Alibaba Cloud AnalyticDB for MySQL is integrated with MCPHub (mcp.nvim):
- Explore all Alibaba Cloud AnalyticDB for MySQL capabilities through MCPHub (mcp.nvim)
- Check out other MCP servers that work with MCPHub (mcp.nvim)
- 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 MCPHub (mcp.nvim) MCP guide
- Join the MCP community discussions