data warehouse
Snowflake MCP servers and skills
There are 55 ways to connect Snowflake to Claude, ChatGPT, Cursor and other AI assistants: 17 MCP servers and 38 skills. The most used is Opentabs Plugin Snowflake (989 GitHub stars).
Best Snowflake MCP servers, compared →Most used
OpenTabs plugin for Snowflake — run SQL queries, browse database schemas, and manage worksheets
Generate CocoMeter chargeback invoices. Usage: $meter invoice
V2-native deterministic contract for the owning CocoPlus feature. Executes the behavior formerly delegated to audit-ci skill without registered runtime scripts.
Manually trigger CocoCupper analysis of the current session's work. Runs immediately (not in background) and writes findings to .cocoplus/grove/cupper-findings.md.
Search curated wisdom and the session-log lexical index together.
Add a clearly marked manual CocoAudit event. Usage: $audit add "<message>".
MCP servers (17)
- 1Opentabs Plugin Snowflake opentabs-dev · DatabasesOpenTabs plugin for Snowflake — run SQL queries, browse database schemas, and manage worksheets87
- 2OSS Snowflake MCP Server Snowflake-Labs · DatabasesMCP Server for Snowflake from Snowflake Labs68
- 3Snowflake Analytics MCP Server sagar1012 · DatabasesSnowflake MCP server for the Analytics Model platform. Table discovery, SQL query, and Cortex AI tools over stdio, runnable via npx.64
- 4Snowflake MCP faressoft · DatabasesMCP server for executing Snowflake queries60
- 5Stellar MCP snowflake-eng · DatabasesMCP server for Stellar Design System59
- 6Snowflake MCP Server naganpm · DatabasesMCP Server for Snowflake — exposes Snowflake operations as MCP tools54
- 7Snowflake MCP Server mikdanjey · DatabasesModel Context Protocol server for Snowflake database integration51
- 8Snowflake MCP Server nsphung · DatabasesA Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants45
- 9Bach Snowflake MCP bachstudio · DatabasesMock Snowflake-style SQL warehouse (alasql) over REAL datasets: Telco Churn (subscriptions), IBM HR Attrition (employees), US city Budget vs Actual (budget_actuals), Legacy Purchase Orders (purchase_orders), and a full GL star schema (gl/coa/territory/cal36
- 10Discord snowflake id shape, value discarded sadri-dridi · DatabasesDiscord snowflake id shape, value discarded25
- ADYour product hereThis row is seen by people browsing Snowflake tools. Book it from $249 a month.See prices →
- 11Discord snowflake worker bits, id discarded sadri-dridi · DatabasesDiscord snowflake worker bits, id discarded25
- 12Snowflake 63-bit digit shape, value discarded sadri-dridi · DatabasesSnowflake 63-bit digit shape, value discarded25
- 13Snowflake sequence bits, id discarded sadri-dridi · DatabasesSnowflake sequence bits, id discarded25
- 14Snowflake timestamp bits, id discarded sadri-dridi · DatabasesSnowflake timestamp bits, id discarded25
- 15Snowflake timestamp bits, value discarded sadri-dridi · DatabasesSnowflake timestamp bits, value discarded25
- 16Snowflake worker-id bits, id discarded sadri-dridi · DatabasesSnowflake worker-id bits, id discarded25
- 17Snowflake id shape sadri-dridi · DatabasesSnowflake id shape24
Skills (38)
- 1meter-invoice Snowflake-Labs · DatabasesGenerate CocoMeter chargeback invoices. Usage: $meter invoice73
- 2audit-ci Snowflake-Labs · DatabasesV2-native deterministic contract for the owning CocoPlus feature. Executes the behavior formerly delegated to audit-ci skill without registered runtime scripts.73
- 3cup Snowflake-Labs · DatabasesManually trigger CocoCupper analysis of the current session's work. Runs immediately (not in background) and writes findings to .cocoplus/grove/cupper-findings.md.73
- 4wisdom-recall Snowflake-Labs · DatabasesSearch curated wisdom and the session-log lexical index together.73
- 5audit-add Snowflake-Labs · DatabasesAdd a clearly marked manual CocoAudit event. Usage: $audit add "<message>".71
- 6personas-discover Snowflake-Labs · DatabasesDiscover dynamic specialist personas from project evidence and record candidates.71
- 7adversary Snowflake-Labs · DatabasesShow CocoAdversary reviewer configuration and latest challenge results.71
- 8trace-health Snowflake-Labs · DatabasesCompute CocoTrace Snowflake asset health grade. Usage: $trace health71
- 9hygiene Snowflake-Labs · DatabasesRun CocoHygiene audits for harness simplification and model-upgrade cleanup. Supports `$hygiene` and `$hygiene --model-upgrade`.71
- 10flow-gate-status Snowflake-Labs · DatabasesShow uncleared human gates for the active CocoFlow run. Usage: $flow gate-status71
- 11meter-refresh Snowflake-Labs · DatabasesRefresh CocoMeter chargeback facts. Usage: $meter refresh70
- 12lex Snowflake-Labs · DatabasesShow CocoLex project lexicon status.68
- 13lex-list Snowflake-Labs · DatabasesList CocoLex terms.65
- 14snowflake-create-iceberg-table Gyrus-Dev · DatabasesConsult Snowflake CREATE ICEBERG TABLE parameter reference before generating any CREATE ICEBERG TABLE DDL.49
- 15vision-guidance Snowflake-AI-Research · DatabasesImage understanding guidance for agents with vision enabled. Instructs agents to use read_file for viewing images directly instead of writing OpenCV/PIL code to parse them programmatically.49
- 16snowflake-naming-conventions Gyrus-Dev · DatabasesEnforces Snowflake object naming conventions before generating any DDL statement.48
- 17snowflake-create-database Gyrus-Dev · DatabasesConsult Snowflake CREATE DATABASE parameter reference before generating any CREATE DATABASE DDL.48
- 18snowflake-create-role Gyrus-Dev · DatabasesConsult Snowflake CREATE ROLE parameter reference before generating any CREATE ROLE DDL.48
- 19snowflake-create-database-role Gyrus-Dev · DatabasesConsult Snowflake CREATE DATABASE ROLE parameter reference before generating any CREATE DATABASE ROLE DDL.48
- 20snowflake-create-sequence Gyrus-Dev · DatabasesConsult Snowflake CREATE SEQUENCE parameter reference before generating any CREATE SEQUENCE DDL.48
- 21snowflake-create-image-repository Gyrus-Dev · DatabasesConsult Snowflake CREATE IMAGE REPOSITORY parameter reference before generating any CREATE IMAGE REPOSITORY DDL.48
- 22snowflake-create-packages-policy Gyrus-Dev · DatabasesConsult Snowflake CREATE PACKAGES POLICY parameter reference before generating any CREATE PACKAGES POLICY DDL.48
- 23snowflake-create-aggregation-policy Gyrus-Dev · DatabasesConsult Snowflake CREATE AGGREGATION POLICY parameter reference before generating any CREATE AGGREGATION POLICY DDL.48
- 24snowflake-create-password-policy Gyrus-Dev · DatabasesConsult Snowflake CREATE PASSWORD POLICY parameter reference before generating any CREATE PASSWORD POLICY DDL.48
- 25snowflake-create-tag Gyrus-Dev · DatabasesConsult Snowflake CREATE TAG parameter reference before generating any CREATE TAG DDL.48
- 26snowflake-create-file-format Gyrus-Dev · DatabasesConsult Snowflake CREATE FILE FORMAT parameter reference before generating any CREATE FILE FORMAT DDL.48
- 27snowflake-create-service Gyrus-Dev · DatabasesConsult Snowflake CREATE SERVICE parameter reference before generating any CREATE SERVICE DDL.48
- 28snowflake-create-schema Gyrus-Dev · DatabasesConsult Snowflake CREATE SCHEMA parameter reference before generating any CREATE SCHEMA DDL.48
- 29snowflake-create-replication-group Gyrus-Dev · DatabasesConsult Snowflake CREATE REPLICATION GROUP parameter reference before generating any CREATE REPLICATION GROUP DDL.48
- 30snowflake-create-view Gyrus-Dev · DatabasesConsult Snowflake CREATE VIEW parameter reference before generating any CREATE VIEW DDL.48
- 31next Snowflake-Labs · DatabasesShow post-install guidance for a Snowflake industry solution. Usage: $sf-solutions:next <solution-name>. Triggers: next steps, what to do next, post-install guidance, after install, next actions.40
- 32etl-aifirst Snowflake-Labs · DatabasesAI-First convert path for ETL platforms SnowConvert does not natively support. Identifies elements, hydrates IR, runs verification gates, and emits dbt output with honest degradation exit codes. Use when convert routes unsupported ETL to the AI-first migrator. Sibling of etl-stabilization (post-convert repair).36
- 33sandbox Snowflake-Labs · DatabasesPrivate AIMSBX catalogs for procedure tests (`createIsolatedSandbox`), on-demand private catalogs when a view/function needs fixture data reshaped, and shared source-catalog deploy for tables, views, functions, and (after tests) procedures (`deployCommonSandbox`). Triggers: createIsolatedSandbox, deployCommonSandbox, setup_sandbox, procedure sandbox, AIMSBX, make_testable.35
- 34effort-estimate Snowflake-Labs · DatabasesGenerates migration effort estimates by running `scai assessment effort-estimate`, which writes JSON for the assessment multi-report. Supports SQL Server and Redshift.35
- 35build-and-evaluate-msa Snowflake-Labs · DatabasesBuild a multiple-sequence alignment for an amino-acid sequence with MSA Search.32
- 36snowflake-best-practices hiddink-ai · DatabasesSnowflake best practices for cloud data warehouse design, query optimization, and cost management23
- 37snowflake-ddl Deekshithasiripurapu · DatabasesPlaybook for Snowflake DDL/DML, CREATE OR ALTER, dynamic tables, and MINUS data validation. Use when creating or modifying Snowflake database objects in snowflake/DDL/.21
- 38snowflake ThinkfleetAI · DatabasesQuery Snowflake data warehouse — execute SQL, manage warehouses, and query metadata via the SQL API.15
Questions
Is there an official Snowflake MCP server?
Check the publisher on each listing: servers published by Snowflake itself are the official ones. The most used Snowflake server here is Opentabs Plugin Snowflake by opentabs-dev.
How do I connect Snowflake to Claude?
Pick a server below, open its page and copy the install command for Claude Code, or the config block for Claude Desktop. Most Snowflake servers need an API key or token from your Snowflake account.