Skip to main content The #1 agentic semantic tool search: 91.6% first-try accuracy on S1 Search Bench Explore Tool Discovery
StackOne
Connectors
Pricing
Login
Book Demo Start Free
Connect

Connect to everything your agents need, without writing the infrastructure to get there.

Secure

Enterprise-grade controls to ensure your agent always meets security & compliance standards.

Optimize

Maximise agent efficiency – faster responses, increased accuracy, fewer tokens used.

Explore more use-cases
Closing the Loop: A Self-Evolving Defense
New
StackOne
Connectors
Connect

Connect to everything your agents need, without writing the infrastructure to get there.

Secure

Enterprise-grade controls to ensure your agent always meets security & compliance standards.

Optimize

Maximise agent efficiency – faster responses, increased accuracy, fewer tokens used.

Use-Cases
Pricing
Book Demo Start Free
Live 40 Actions

Matillion MCP Server
for AI Agents

Connect your AI agent to StackOne's Matillion MCP server and give it 40 MCP tools out of the box. Auth, tool execution, and security all managed.

Start Free Book Demo Read Docs →
Matillion logo
Matillion MCP Server
Built by StackOne StackOne
DrataGPLocalyzeFlipMindtoolsScreenloop

Coverage

40 Agent Actions

Create, read, update, and delete across Matillion — and extend your agent's capabilities with custom actions.

MCP Actions → Build Actions →

Authentication

Agent Tool Authentication

Per-user OAuth in one call. Your Matillion MCP server gets session-scoped tokens with zero credentials stored on your infra.

Agent Auth →

Security

Agent Protection

Every Matillion tool response scanned for prompt injection in milliseconds — 88.7% accuracy, all running on CPU.

Prompt Injection Defense →

Performance

Max Agent Context. Min Cost.

Free up to 96% of your agent's context window to enhance reasoning and reduce cost, on every Matillion call.

Tools Discovery →

What is the Matillion MCP Server?

A Matillion MCP server lets AI agents read and write Matillion data through the Model Context Protocol — Anthropic's open standard for connecting LLMs to external tools. StackOne's Matillion MCP server ships with 40 pre-built actions, fully extensible via the Connector Builder — plus managed authentication, prompt injection defense, observability, and agent execution runtime. Connect it from MCP clients like Claude Desktop, Claude Code, Cursor, Goose, and VS Code, or from agent frameworks like OpenAI Agents SDK, LangChain, and Vercel AI SDK.

All Matillion MCP Tools

Every action from Matillion's API, ready for your agent. Create, read, update, and delete — scoped to exactly what you need.

Projects

  • Create Project

    Creates a new project in Matillion

  • List Projects

    Returns a paginated list of all projects

  • Delete Project

    Deletes a project by its ID

Environments

  • Create Environment

    Creates a new environment in a project

  • List Environments

    Returns a paginated list of all environments for a project

  • Delete Environment

    Deletes an environment by its name

Agents

  • Create Agent

    Creates a new agent in Matillion

  • List Agents

    Returns a paginated list of all agents

  • Get Agent

    Returns agent details for a specific agent ID

  • Update Agent

    Partially updates an agent by its ID

  • Delete Agent

    Deletes an agent by its ID

Pipeline Executions

  • List Pipeline Executions

    Returns a paginated list of pipeline executions across all projects

  • Get Pipeline Execution

    Returns the full details of a pipeline execution

Schedules

  • Create Schedule

    Creates a new schedule for a project

  • List Schedules

    Returns a paginated list of all schedules for a project

  • Get Schedule

    Returns the summary of a specific schedule

  • Update Schedule

    Updates an existing schedule

  • Delete Schedule

    Deletes a schedule by its ID

Artifacts

  • Create Artifact

    Creates a new artifact in the specified project

  • List Artifacts

    Returns a paginated list of artifacts for a given project and environment

  • Get Artifact

    Returns a specific artifact by name and version

Streaming Pipelines

  • Create Streaming Pipeline

    Creates a new streaming pipeline definition

  • List Streaming Pipelines

    Returns a paginated list of streaming pipeline definitions

  • Get Streaming Pipeline

    Returns a streaming pipeline definition for a specific pipeline ID

  • Update Streaming Pipeline

    Updates a streaming pipeline definition by its ID

  • Delete Streaming Pipeline

    Deletes a streaming pipeline definition by its ID

Test Executions

  • Create Test Execution

    Triggers a test execution for a project

  • List Test Executions

    Returns a paginated list of test executions

Other (12)

  • List Pipelines

    Returns a paginated list of published pipelines for a given project and environment

  • Get Pipeline Execution Status

    Returns the current status of a pipeline execution

  • Get Pipeline Execution Steps

    Returns the step-level execution results for a pipeline execution

  • Get Streaming Pipeline Status

    Returns the status of a streaming pipeline

  • Get Test Execution Status

    Returns the status of a test execution

  • Trigger Agent Command

    Sends a command to an agent

  • Execute Pipeline

    Triggers the asynchronous execution of a published pipeline

  • Terminate Pipeline Execution

    Cancel an executed pipeline, optionally forcing the termination

  • Toggle Artifact

    Enables or disables an artifact by name and version

  • Promote Artifact

    Promotes an artifact from one environment to another

  • Execute Streaming Pipeline Command

    Sends a command to a streaming pipeline

  • Cancel Test Execution

    Cancels a running test execution

Set Up Your Matillion MCP Server in Minutes

One endpoint. Any framework. Your agent is talking to Matillion in under 10 lines of code.

MCP Clients

Claude Desktop setup guide
Claude Code setup guide
Cursor setup guide
Goose setup guide

Agent Frameworks

Claude Desktop
{
  "mcpServers": {
    "stackone": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote@latest",
        "https://api.stackone.com/mcp?x-account-id=<account_id>",
        "--header",
        "Authorization: Basic <YOUR_BASE64_TOKEN>"
      ]
    }
  }
}

Check More Data Infrastructure MCP Servers

Fivetran

156+ actions

Supabase

129+ actions

New Relic

126+ actions

Render

98+ actions

Grafana

89+ actions

Sentry

85+ actions

Snowflake

80+ actions

All Data Infrastructure MCP Servers →

Platform Resources

MCP Code Mode: Keeping Tool Responses Out of Agent Context

Anthropic's code_execution processes data already in context. Custom MCP code mode keeps raw tool responses in a sandbox. 14K tokens vs 500.

11 min

Comparing BM25, TF-IDF, and Hybrid Search for MCP Tool Discovery

Benchmarking BM25, TF-IDF, and hybrid search for MCP tool discovery across 916 tools. The 80/20 TF-IDF/BM25 hybrid hits 21% Top-1 accuracy in under 1ms.

10 min

Indirect Prompt Injection Defense for MCP Tools: A Technical Guide

MCP tools that read emails, CRM records, and tickets are indirect prompt injection vectors. Here's how we built a two-tier defense that scans tool results in ~11ms.

12 min

MCP vs A2A: Architecture, Security, and When to Use Each

MCP vs A2A: what each protocol standardizes, how they differ, their shared security risks including indirect prompt injection, and when to use one, both, or a hybrid architecture.

12 min

MCP vs API: What 200+ Connector Builds Taught Us

MCP wraps APIs, it doesn't replace them. After building 200+ connectors that serve both, here's when each approach wins.

14 min read

Matillion MCP Server FAQ

Does StackOne have a Matillion MCP server?
Yes. StackOne offers a hosted Matillion MCP server with 40 pre-built actions, and every action is tested and QA'd by StackOne. Connect it to Claude, Cursor, and any other MCP client, or to any agent framework through the AI Action SDK. It ships with managed agent authentication, prompt injection defense, and tool discovery with server-side execution that preserve your agent's context window and keep reasoning performance.
Matillion MCP server vs direct API integration — what's the difference?
A Matillion MCP server and direct API integration serve different use cases. Direct API integration is for software-to-software — backend code calling Matillion. A Matillion MCP server is for AI agents — MCP clients like Claude and Cursor, plus framework agents built with OpenAI, LangChain, or Vercel AI — discovering and calling Matillion at runtime. StackOne provides both.
How does Matillion authentication work for AI agents?
Matillion authentication for AI agents works through a StackOne Connect Session. Create one via the dashboard or the SDK — you get an auth link and ready-to-paste config for Claude Desktop, Cursor, and other MCP clients. Your user authenticates their own Matillion account; StackOne handles token exchange, storage, and refresh. Credentials never reach the LLM, and each user is isolated via origin_owner_id.
Are Matillion MCP tools vulnerable to prompt injection?
Yes — Matillion MCP tools can be vulnerable to indirect prompt injection. Any tool that reads user-written content — documents, messages, tickets, records, or free-text fields — is a potential vector. StackOne Defender scans every tool response before it enters the agent's context — regex patterns in ~1ms, then a MiniLM classifier in ~4ms. 88.7% accuracy, CPU-only.
What is the context bloat of a Matillion agent and how do I avoid it?
Context bloat happens when Matillion tool schemas and API responses eat your Matillion agent's memory, preventing it from reasoning effectively. A single Matillion query can return a massive JSON response, and connecting multiple tools compounds the problem. Tools Discovery and Code Mode reduce context bloat — loading only relevant tools per query and keeping raw responses out of the agent's context.
Can I limit which actions my Matillion agent can access?
Yes — you can limit which actions your Matillion agent can access directly from the StackOne dashboard. Toggle actions on or off, or restrict them to specific accounts, with no code changes to your agent. Session tokens can be scoped to exact actions so if one leaks, exposure stays contained.
Can I create custom agent actions for my Matillion MCP server?
Yes — you can create custom agent actions for your Matillion MCP server using Connector Builder. It's an integration agent your coding assistant (Claude Code, Cursor, or Copilot) can invoke to research Matillion's API, generate production-ready connector YAML, test against the live API, and validate before you ship.
When should I NOT use a Matillion MCP server?
Skip a Matillion MCP server if your integration is purely software-to-software — direct Matillion API integration is simpler when no AI agent is involved. For deterministic, compliance-critical operations (financial transactions, regulatory reporting), direct API gives you predictable behavior without agent-driven decision-making. MCP shines when AI agents need to dynamically discover and call Matillion actions at runtime.
What AI frameworks and AI clients does the StackOne Matillion MCP server support?
The StackOne Matillion MCP server supports both. MCP clients (paste-and-go apps): Claude Desktop, Claude Code, Cursor, VS Code, Goose. Agent frameworks (code SDKs you build with): OpenAI Agents SDK, Anthropic, Vercel AI, Google ADK, CrewAI, Pydantic AI, LangChain, LangGraph, Azure AI Foundry.

Put your AI agents to work

All the tools you need to build and scale AI agent integrations, with best-in-class connectivity, execution, and security.

Start Free Book Demo