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

Alibaba Cloud AnalyticDB for PostgreSQL is a MCP server that An MCP server to connect to AnalyticDB for PostgreSQL instances, query and analyze data..

When integrated with Roo Code, you can:

• Execute SQL queries (SELECT, DML, DDL) on PostgreSQL
• Get comprehensive table statistics and metadata
• Retrieve and analyze query execution plans

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

What You'll Achieve

After completing this setup:

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

Prerequisites

Before starting, ensure you have:

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

Installation

Step 1: Install Alibaba Cloud AnalyticDB for PostgreSQL

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-postgresql": {
      "command": "npx",
      "args": ["-y", "alibaba-cloud-analyticdb-for-postgresql"],
      "env": {
        "ADBPG_HOST": "adbpg-cluster-123.ads.aliyuncs.com",
        "ADBPG_PORT": "5432",
        "ADBPG_USER": "analytics_user",
        "ADBPG_PASSWORD": "secure_password123",
        "ADBPG_DATABASE": "analytics_db",
        "GRAPHRAG_ENABLED": "true",
        "LLM_MEMORY_SERVICE_URL": "https://memory-service.example.com"
      }
    }
  }
}

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 PostgreSQL in Roo Code:

Advanced Analytics Pipeline

undefined

Ask Roo Code: "Analyze customer behavior patterns and generate insights"

Expected Result: undefined

Knowledge Graph Construction

undefined

Ask Roo Code: "Create knowledge graph connecting customers, products, and transactions"

Expected Result: undefined

Intelligent Memory Management

undefined

Ask Roo Code: "Store and retrieve conversation history for personalized responses"

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 PostgreSQL functionality

Test prompts:

• "Type @ and verify Alibaba Cloud AnalyticDB for PostgreSQL appears in the tools list"
• "Ask: "Use Alibaba Cloud AnalyticDB for PostgreSQL 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 PostgreSQL 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 PostgreSQL installation
• Restart Roo Code
• Check logs for error messages

Next Steps

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

• Explore all Alibaba Cloud AnalyticDB for PostgreSQL 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 PostgreSQL development

Need Help?

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