Matillion's MCP server

​

Use cases

​

Prerequisites

• Node.js is installed on your system. We recommend at least v24.
• npm is installed on your system. Version 11 (minimum recommended) should come with Node.js v24 and above.
• The npx command must be available in your system’s global PATH.
• You have your Matillion region, client ID, and client secret.
• At least one installed AI client, such as Claude Desktop or the Gemini CLI.

​

Obtaining Matillion credentials

1. Log in to the .
2. In the left navigation, click your Profile & Account icon.
   Your Matillion region is shown below your account name. Enter eu if your Matillion region starts with EU, or us if it starts with US.
3. Then, select API credentials from the menu.
4. If you don’t have credentials, click Set an API Credential to create a Client ID and Client Secret. Read Authenticating to the API to learn how to create API credentials.
5. Give your credential set a descriptive Name. We recommend that you use a name that suits the application or purpose the credentials will be used for.
6. Click Save to create the Client ID and Secret.
7. Copy the secret immediately. You are not able to view the secret again after this point. If you do not copy it, or otherwise lose it, you will need to delete these credentials and generate a new set. The Secret window will close automatically after this point.

​

Environment variables

​

Claude Desktop

• For macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
• For Windows: %APPDATA%\Claude\claude_desktop_config.json

1. Choose which authentication method to use, then replace the placeholders in the corresponding JSON configuration below with your credentials.
2. Copy your chosen JSON configuration, including the opening and closing , into the Claude Desktop configuration file. If the file already has content, merge the mcpServers object into the existing content.
3. Quit the Claude Desktop app by right-clicking the Claude icon and then clicking Quit. Closing the window will not quit the app completely.
4. Restart Claude Desktop. The Matillion MCP server will now be available.

​

JSON configurations

{
  "mcpServers": {
    "matillion": {
      "command": "npx",
      "args": ["@matillion/mcp-server"],
      "env": {
        "MATILLION_CLIENT_ID": "your_client_id",
        "MATILLION_CLIENT_SECRET": "your_client_secret",
        "MATILLION_REGION": "your_region"
      }
    }
  }
}

{
  "mcpServers": {
    "matillion": {
      "command": "npx",
      "args": ["@matillion/mcp-server"],
      "env": {
        "MATILLION_BEARER_TOKEN": "your_bearer_token",
        "MATILLION_REGION": "your_region"
      }
    }
  }
}

​

Claude Code

• Replace the placeholders in one of the JSON configurations in the Claude Desktop section with your credentials, then copy the mcpServers block into the ~/.claude.json file.
• Replace the placeholders in the following command with your credentials, then run the command.
  claude mcp add matillion \
    --scope "user" \
    --env MATILLION_CLIENT_ID="your_client_id" \
    --env MATILLION_CLIENT_SECRET="your_client_secret" \
    --env MATILLION_REGION="your_region" \
    -- npx -y @matillion/mcp-server
  

​

Claude Code with Visual Studio Code

1. Enable the MCP extension, if this is not already enabled.
2. Open your project workspace in Visual Studio Code.
3. Create or open the .vscode/mcp.json file.
4. Replace the placeholders in the JSON configuration below with your credentials.
5. Copy the JSON configuration, including the opening and closing , into the .vscode/mcp.json file. If the file already has content, merge the servers object into the existing content.
6. Restart Visual Studio Code. The Matillion MCP server will now be available.

{
  "servers": {
    "matillion": {
      "command": "npx",
      "args": ["@matillion/mcp-server"],
      "env": {
        "MATILLION_CLIENT_ID": "your_client_id",
        "MATILLION_CLIENT_SECRET": "your_client_secret",
        "MATILLION_REGION": "your_region"
      }
    }
  }
}

​

Gemini CLI

• For macOS or Linux: ~/.gemini/settings.json
• For Windows: $HOME/.gemini/settings.json (where $HOME is your user profile directory, e.g. C:\Users\YourName)

1. Replace the placeholders in the JSON configuration below with your credentials.
2. Copy the JSON configuration, including the opening and closing , into the Gemini CLI configuration file. If the file already has content, merge the mcpServers object into the existing content.
3. If the Gemini CLI is currently running in your terminal, use the /quit command to quit the CLI.
4. Restart the Gemini CLI. The Matillion MCP server will now be available.

​

JSON configuration

{
  "mcpServers": {
    "matillion": {
      "command": "npx",
      "args": ["@matillion/mcp-server"],
      "env": {
        "MATILLION_CLIENT_ID": "your_client_id",
        "MATILLION_CLIENT_SECRET": "your_client_secret",
        "MATILLION_REGION": "your_region"
      }
    }
  }
}

​

Other MCP-compatible clients

• Command: npx
• Args: ["@matillion/mcp-server"]
• Environment: Set the required authentication variables

​

Unsupported clients

• ChatGPT (Desktop and Web)
• Claude.ai (Web)
• Browser-based AI clients

​

Available tools

​

Debug logging

• OAuth token acquisition and refresh
• HTTP requests and responses
• API call details
• Configuration loading
• Tool invocations