3,400+ MCP servers ready to use
Vinkius

Bring Sql Query
to VS Code Copilot

Learn how to connect Snowflake to VS Code Copilot and start using 11 AI agent tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code.

Cancel SqlDescribe TableExecute SqlGet Session ContextGet Statement StatusList DatabasesList RolesList SchemasList TablesList UsersList Warehouses
Use with Your AI Agent
Ask AI about this MCP Server
ChatGPT Claude Perplexity

What is the Snowflake MCP Server?

Connect your Snowflake account to any AI agent to automate your data cloud operations and analytical workflows. Snowflake provides a premier platform for data warehousing and analysis, and this integration allows you to execute SQL statements, browse database schemas, and monitor session contexts through natural conversation.

What you can do

  • SQL Query Orchestration — Execute any SQL statement programmatically and retrieve real-time data results for immediate analysis.
  • Database & Schema Oversight — List and search through databases, schemas, and tables to maintain a clear overview of your data architecture directly from the AI interface.
  • Warehouse & Resource Control — Access and monitor available warehouses and user roles to ensure your analytical environment is properly configured.
  • Metadata Intelligence — Describe table structures and retrieve session context metadata via natural language commands to facilitate data exploration.
  • Operational Monitoring — Track statement execution status and cancel long-running queries to ensure your data cloud resources are used efficiently.

How it works

1. Subscribe to this server
2. Enter your Snowflake Account Identifier and Token (JWT or OAuth2)
3. Start managing your data cloud from Claude, Cursor, or any MCP-compatible client

Who is this for?

  • Data Analysts — quickly retrieve query results and explore table schemas without switching between SQL editors.
  • BI Engineers — automate the retrieval of database metadata and monitor warehouse usage via natural conversation.
  • Data Scientists — streamline the exploration of large datasets and track session contexts directly within the chat.

Built-in capabilities (11)

cancel_sql

Cancel a running SQL statement

describe_table

Get table schema details

execute_sql

Returns the first partition of results or a handle for long-running queries. Execute a SQL statement in Snowflake

get_session_context

Get current session context

get_statement_status

Check the status of a SQL statement

list_databases

List all accessible databases

list_roles

List security roles

list_schemas

List schemas in a database

list_tables

List tables in a schema or database

list_users

List Snowflake users

list_warehouses

List compute warehouses

Why VS Code Copilot?

GitHub Copilot Agent mode brings Snowflake data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 11 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

See it in action

Snowflake in VS Code Copilot

AI Agent→Vinkius
High Security·Kill Switch·Plug and Play
Why Vinkius

Snowflake and 3,400+ other MCP servers. One platform. One governance layer.

Teams that connect Snowflake to VS Code Copilot through Vinkius don't need to source, host, or maintain individual MCP servers. Every tool call runs inside a hardened runtime with credential isolation, DLP, and a signed audit chain.

3,400+MCP Servers ready
<40msCold start
60%Token savings
Raw MCP
Vinkius
Server catalogFind and host yourself3,400+ managed
InfrastructureSelf-hostedSandboxed V8 isolates
Credential handlingPlaintext in configVault + runtime injection
Data loss preventionNoneConfigurable DLP policies
Kill switchNoneGlobal instant shutdown
Financial circuit breakersNonePer-server limits + alerts
Audit trailNoneEd25519 signed logs
SIEM log streamingNoneSplunk, Datadog, Webhook
HoneytokensNoneCanary alerts on leak
Custom domainsNot applicableDNS challenge verified
GDPR complianceManual effortAutomated purge + export
Use with Your AI Agent View step-by-step setup guide for VS Code Copilot →
Enterprise Security

Why teams choose Vinkius for Snowflake in VS Code Copilot

The Snowflake MCP Server runs on Vinkius-managed infrastructure inside AWS — a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts. All 11 tools execute in hardened sandboxes optimized for native MCP execution.

Your AI agents in VS Code Copilot only access the data you authorize, with DLP that blocks sensitive information from ever reaching the model, kill switch for instant shutdown, and up to 60% token savings. Enterprise-grade infrastructure, zero maintenance.

Use with Your AI Agent View full Snowflake details →
Snowflake
Fully ManagedVinkius Servers
60%Token savings
High SecurityEnterprise-grade
IAMAccess control
EU AI ActCompliant
DLPData protection
V8 IsolateSandboxed
Ed25519Audit chain
<40msKill switch
Stream every event to Splunk, Datadog, or your own webhook in real-time

* Every MCP server runs on Vinkius-managed infrastructure inside AWS - a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts optimized for native MCP execution. See our infrastructure

The Vinkius Advantage

How Vinkius secures Snowflake for VS Code Copilot

Every tool call from VS Code Copilot to the Snowflake MCP Server is protected by DLP redaction, cryptographic audit chains, V8 sandbox isolation, kill switch, and financial circuit breakers.

< 40msCold start
Ed25519Signed audit chain
60%Token savings
FAQ

Frequently asked questions

01

How do I find my Snowflake Account Identifier?

Your Account Identifier is the part of your Snowflake URL before '.snowflakecomputing.com'. It typically looks like xy12345.us-east-2.aws.

02

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.

03

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.

04

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.

05

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.

06

MCP tools not available

Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.