Connect
Optimize
Secure
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.
Matillion MCP Server
Built by 
StackOne
StackOne 
Coverage
40 Agent Actions
Create, read, update, and delete across Matillion — and extend your agent's capabilities with custom 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.
Agent Frameworks
JSON{
"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>"
]
}
}
}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
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.