Aiven + GitHub Copilot (VS Code): Complete MCP Integration

Aiven is a MCP server that Navigate your Aiven projects and interact with the PostgreSQL®, Apache Kafka®, ClickHouse® and OpenSearch® services.

When integrated with GitHub Copilot (VS Code), you can:

• List all projects in your Aiven account
• List all services in a specific project
• Get detailed information about a specific service

This guide provides step-by-step instructions to set up Aiven in GitHub Copilot (VS Code), including configuration, examples, and troubleshooting.

What You'll Achieve

After completing this setup:

• Aiven will be fully integrated and operational
• You can use Aiven tools directly in GitHub Copilot (VS Code)
• All Aiven capabilities will be available for your workflows
• Access to 5 different tools

Prerequisites

Before starting, ensure you have:

• Aiven API token with appropriate permissions
• GitHub Copilot (VS Code) installed and configured
• Compatible operating system (Windows, macOS, Linux)

Installation

Step 1: Install Aiven

Configuration

Step 2: Configure GitHub Copilot (VS Code)

1. Locate your configuration file:

   • Windows: .vscode\\mcp.json in your project directory
   • macOS: .vscode/mcp.json in your project directory
   • Linux: .vscode/mcp.json in your project directory

2. Add server configuration:

{
  "mcpServers": {
    "aiven": {
      "command": "aiven",
      "args": [],
      "env": {
        "AIVEN_TOKEN": "aiven_token_1234567890abcdef",
        "AIVEN_BASE_URL": "https://api.aiven.io"
      }
    }
  }
}

3. Restart GitHub Copilot (VS Code)

Completely quit and restart GitHub Copilot (VS Code) to load the new configuration.

Examples

Once configured, you can use Aiven in GitHub Copilot (VS Code):

Multi-Cloud Database Management

undefined

Ask GitHub Copilot (VS Code): "Check status of all PostgreSQL services and their performance"

Expected Result: undefined

Event Streaming Monitoring

undefined

Ask GitHub Copilot (VS Code): "Show Kafka service health and recent message volumes"

Expected Result: undefined

Analytics Platform Health Check

undefined

Ask GitHub Copilot (VS Code): "Check ClickHouse query performance and storage usage"

Expected Result: undefined

Testing Your Setup

1. Start a new conversation in GitHub Copilot (VS Code)
2. Ask GitHub Copilot (VS Code) to list available tools
3. Try using Aiven functionality

Test prompts:

• "What MCP tools are available?"
• "Use Aiven to help with my code"
• "Show me what Aiven can do"

Troubleshooting

Common Issues

MCP Configuration Not Loaded

Symptoms: MCP tools not appearing, Copilot does not recognize MCP server

Cause: Configuration file not in correct location or invalid JSON

Solution:

• Verify .vscode/mcp.json exists in project root directory
• Check JSON syntax is valid (no trailing commas, proper quotes)
• Reload VS Code window after making configuration changes
• Check VS Code Developer Tools (Help > Toggle Developer Tools) for errors

MCP Server Not Starting

Symptoms: Tools listed but not responding, Server connection errors

Cause: Server command path incorrect or dependencies missing

Solution:

• Test the MCP server command independently in terminal
• Verify all server prerequisites are installed
• Check that command path is correct (use absolute paths if needed)
• Ensure required environment variables are set in mcp.json
• Review VS Code Output panel for MCP server error messages

GitHub Copilot Subscription Required

Symptoms: Copilot features grayed out, Unable to access Copilot Chat

Cause: No active GitHub Copilot subscription

Solution:

• Sign up for GitHub Copilot subscription (Individual, Business, or Enterprise)
• Verify subscription is active in GitHub account settings
• Re-authenticate GitHub Copilot in VS Code
• Check that VS Code is using correct GitHub account

VS Code Version Too Old

Symptoms: MCP configuration ignored, No mcp.json recognition

Cause: VS Code version below 1.99 does not have native MCP support

Solution:

• Update VS Code to version 1.99 or later
• Check current version: Help > About
• Download latest version from code.visualstudio.com
• After updating, reload window and verify MCP support

{server_name} Tools Not Working

Symptoms: Server connected but tools fail, Error messages when invoking tools

Cause: Server-specific configuration or authentication issues

Solution:

• Verify all required environment variables for {server_name} are set
• Check {server_name} documentation for specific prerequisites
• Test {server_name} with another MCP client to isolate issue
• Review error messages in VS Code Output panel for specific failures

Aiven not appearing in GitHub Copilot (VS Code)

Symptoms: Server not listed, Tools not available

Cause: Configuration or installation issue

Solution:

• Verify configuration syntax
• Check Aiven installation
• Restart GitHub Copilot (VS Code)
• Check logs for error messages

Next Steps

Now that Aiven is integrated with GitHub Copilot (VS Code):

• Explore all Aiven capabilities through GitHub Copilot (VS Code)
• Check out other MCP servers that work with GitHub Copilot (VS Code)
• Join the MCP community for tips and support
• Consider contributing to Aiven development

Need Help?

• Search for Aiven documentation
• Check the GitHub Copilot (VS Code) MCP guide
• Join the MCP community discussions