How to Use the Coalesce MCP in Pydantic AI
Build type-safe data agents with Pydantic AI to validate every Coalesce pipeline action and run status at runtime.
Works with every AI agent you already use
…and any MCP-compatible client
Connect Coalesce MCP to Pydantic AI
Create your Vinkius account to connect Coalesce to Pydantic AI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.
Type-safe Snowflake pipeline execution with Pydantic AI
The Coalesce MCP Server provides type-safe access to your Snowflake pipelines through Pydantic AI validation. When your agent calls `trigger_run` or `trigger_job`, Pydantic AI validates the environment and job IDs against strict schemas before sending the request. If the agent attempts to pass an invalid string format, the SDK blocks the call immediately. This guarantees that your Coalesce platform only receives perfectly structured API requests.
Fail loudly on unexpected metadata changes
This MCP Server exposes metadata from your active data pipelines directly to your validation models. When your Pydantic AI agent queries `list_nodes` or `get_environment` in Coalesce, the returned JSON is parsed directly into strict models. If a Coalesce node configuration changes unexpectedly, the Pydantic AI system throws a validation error instead of passing bad data to your model. This prevents silent failures in your data pipeline automation.
Predictable job monitoring and status checks
The Coalesce MCP Server delivers structured status updates for tracking your data transformations. Your agent calls `get_run_status` and parses the progress state into typed Python objects. You can confidently write logic based on the status field, knowing the framework guarantees its structure. If `get_job_details` returns an unexpected status code, your Pydantic AI code catches it instantly.
Set up Coalesce MCP in Pydantic AI
Prerequisites
- Python 3.10+ installed
-
pydantic-ai-slim[fastmcp]package - Active Vinkius subscription with a valid endpoint token
- 1
Install Pydantic AI with FastMCP
Run
pip install "pydantic-ai-slim[fastmcp]". The FastMCP toolset replaces the deprecatedMCPServerHTTPclass with full protocol support. - 2
Configure the FastMCPToolset
Pass a JSON-style config dict to
FastMCPToolsetwith your Vinkius URL. Replace[YOUR_TOKEN_HERE]with your token from cloud.vinkius.com. Supports Streamable HTTP, SSE, and Stdio transports. - 3
Create and run your agent
Pass the toolset to
Agent(toolsets=[toolset])and callagent.run(). Swapopenai:gpt-4ofor any supported model — Anthropic, Google, Mistral, or Groq.
from pydantic_ai import Agent
from pydantic_ai.toolsets.fastmcp import FastMCPToolset
toolset = FastMCPToolset({
"mcpServers": {
"coalesce-mcp": {
"url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
}
}
})
agent = Agent(
"openai:gpt-4o",
toolsets=[toolset],
system_prompt="You have access to Coalesce tools.",
)
result = await agent.run("List recent Coalesce transactions")
print(result.output) Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Coalesce. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.
Why Choose Vinkius
Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.
Real-time monitoring
Live
visibility into every interaction
Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.
Built-in savings
60%
lower AI costs
Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.
Single dashboard
One
place for every integration
Every tool your AI connects to, managed from a single screen. One account, complete control.
Common questions about Coalesce MCP in Pydantic AI
Use it with your favorite AI tools
Connect this server to Cursor, Claude, VS Code, and more.
Start using the Coalesce MCP today
We host it, we monitor it, we maintain it. You just paste one token.