Bring Data Transformation
to VS Code Copilot
Create your Vinkius account to connect Coalesce to VS Code Copilot and start using all 8 AI tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code. No hosting, no server setup — just connect and start using.
GDPR Free for SubscribersCompatible with every major AI agent and IDE
Gemini
What is the Coalesce MCP Server?
Connect your AI to Coalesce, the data transformation platform built for Snowflake with a column-aware approach.
What you can do
- Environment Management — List all environments in your Coalesce organization and inspect their configurations.
- Job Monitoring — Check the status of the last run for any environment and view execution logs.
- Trigger Transformations — Start transformation jobs on demand with optional node selectors to target specific pipelines.
How it works
- Add the Coalesce integration to your AI toolset.
- Provide your API Token (from Organization Settings > API Tokens).
- Manage your data pipelines via natural language.
Who is this for?
- Data Engineers — Trigger and monitor pipeline runs without opening the Coalesce UI.
- Analytics Engineers — Check job statuses and debug failed transformations from chat.
- Data Team Leads — Get quick overviews of environment health and recent job results.
Built-in capabilities (8)
Retrieve detailed information about a specific environment
Retrieve detailed information about a specific job
Check the current status and progress of a triggered run
Retrieve all environments configured in your Coalesce organization
Retrieve a list of jobs, optionally filtered by environment
Retrieve metadata about transformation nodes in a specific environment
Trigger a specific job in an environment
Trigger a new run for a specific environment and optionally a job
Why VS Code Copilot?
GitHub Copilot Agent mode brings Coalesce data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 8 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
- —
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
- —
Project-scoped MCP configs (
.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access - —
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
- —
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
Coalesce in VS Code Copilot
Why run Coalesce with Vinkius?
The Coalesce connection runs on our fully managed, secure cloud infrastructure. We handle the hosting, maintenance, and security so you don't have to deal with servers or code. All 8 tools are ready to work instantly without any complex setup.
You stay in complete control of your data. Your AI only accesses the information you approve, keeping your sensitive passwords and private details completely safe. Plus, with automatic optimizations, your AI works faster and more efficiently.
* Every connection is hosted and maintained by Vinkius. We handle the security, updates, and infrastructure so you don't have to write code or manage servers. See our infrastructure
Over 4,000 integrations ready for AI agents
Explore a vast library of pre-built integrations, optimized and ready to deploy.
Connect securely in under 30 seconds
Generate tokens to authenticate and link external services in a single step.
Complete visibility into every agent action
Audit live requests, latency, success rates, and active security compliance policies.
Optimize spending and track token ROI
Analyze real-time token consumption and cost metrics detailed by connection.
Explore our live AI Agents Analytics dashboard to see it all working
This dashboard is included when you connect Coalesce using Vinkius. You will never be left in the dark about what your AI agents are doing with your tools.
Coalesce and 4,000+ other AI tools. No hosting, no code, ready to use.
Professionals who connect Coalesce to VS Code Copilot through Vinkius don't need to write code, manage servers, or worry about security. Everything is pre-configured, secure, and runs automatically in the background.
Raw MCP | Vinkius | |
|---|---|---|
| Ready-to-use MCPs | Find and configure each manually | 4,000+ MCPs ready to use |
| Connection Setup | Manual coding & server setup | 1-click instant connection |
| Server Hosting | You host it yourself (needs 24/7 uptime) | 100% hosted & managed by Vinkius |
| Security & Privacy | Stored in plaintext config files | Bank-grade encrypted vault |
| Activity Visibility | Blind execution (no logs or tracking) | Live dashboard with real-time logs |
| Cost Control | Runaway AI token spend risk | Automatic budget limits |
| Revoking Access | Must delete files or code to stop | 1-click disconnect button |
How Vinkius secures
Coalesce for VS Code Copilot
Every request between VS Code Copilot and Coalesce is protected by our secure gateway. We automatically keep your sensitive data private, prevent unauthorized access, and let you disconnect instantly at any time.
Frequently asked questions
How do I get my Coalesce API token?
In the Coalesce UI, go to Organization Settings > API Tokens and generate a new token. Copy it and paste it below.
Does this work with Snowflake?
Yes. Coalesce is built specifically for Snowflake. The API triggers jobs that run directly on your Snowflake instance.
What is a Node Selector?
A Node Selector lets you filter which transformation nodes to include in a run, based on name, type, or tags.
Which VS Code version supports MCP?
MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.
How do I switch to Agent mode?
Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.
Can I restrict which MCP tools Copilot can access?
Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.
Does MCP work in VS Code Remote or Codespaces?
Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.
MCP tools not available
Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.
Explore More MCP Servers
View all →
Doofinder
10 toolsEmpower e-commerce search via Doofinder — perform keyword and filtered searches, get predictive suggestions, and audit search analytics directly from any AI agent.
SonarCloud
9 toolsMerge your SaaS DevOps workflow with SonarCloud to review AI code and prevent production vulnerabilities.
Finch
11 toolsConnect Finch to automate HRIS and Payroll integration — list employees, retrieve employment data, and manage pay statements directly from your AI agent.
Steam
10 toolsAccess Steam gaming data — player profiles, owned games, achievements, and stats via AI.