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

Installation

Step 1: Install Alibaba Cloud AnalyticDB for PostgreSQL

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 PostgreSQL in OpenCode:

### Advanced Analytics Pipeline

undefined

**Ask OpenCode:** "Analyze customer behavior patterns and generate insights"

**Expected Result:** undefined

### Knowledge Graph Construction

undefined

**Ask OpenCode:** "Create knowledge graph connecting customers, products, and transactions"

**Expected Result:** undefined

### Intelligent Memory Management

undefined

**Ask OpenCode:** "Store and retrieve conversation history for personalized responses"

**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 PostgreSQL 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 PostgreSQL installation
- Restart OpenCode
- Check logs for error messages



## Next Steps

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

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

## Need Help?

- Search for [Alibaba Cloud AnalyticDB for PostgreSQL documentation](https://www.mcpstack.org)
- Check the [OpenCode MCP guide](https://www.mcpstack.org/clients)
- Join the MCP community discussions