Best MCP Servers for Data Warehouses (Snowflake, BigQuery, DuckDB) (2026)
Cloud analytics platforms through MCP: two Snowflake servers, two BigQuery servers, DuckDB for local OLAP, and gateways like Centralmind and Legion that put warehouses behind the same endpoint as your operational databases.
This page collects the 7 MCP servers in our directory that genuinely cover data warehouses (snowflake, bigquery, duckdb) — together they have 1,518 GitHub stars, and 0 of them run as hosted services you can connect to without installing anything. The highest-rated options are centralmind/gateway, Snowflake-Labs/mcp, isaacwasserman/mcp-snowflake-server.
How to choose
Use a native server (Snowflake Labs, BigQuery) for one warehouse; use DuckDB MCP to analyze local files fast; use a gateway when analysts and agents hit several stores.
centralmind/gateway
by centralmind
🏎️ 🏠 🍎 🪟 - MCP and MCP SSE Server that automatically generate API based on database schema and data. Supports PostgreSQL, Clickhouse, MySQL, Snowflake, BigQuery, Supabase
npx -y centralmind-gatewaySnowflake-Labs/mcp
by Snowflake-Labs
🐍 ☁️ - Open-source MCP server for Snowflake from official Snowflake-Labs supports prompting Cortex Agents, querying structured & unstructured data, object management, SQL execution, semantic view que
npx -y @modelcontextprotocol/inspectorisaacwasserman/mcp-snowflake-server
by isaacwasserman
🐍 ☁️ - Snowflake integration implementing read and (optional) write operations as well as insight tracking
npx -y -y @smithery/cliktanaka101/mcp-server-duckdb
by ktanaka101
🐍 🏠 - DuckDB database integration with schema inspection and query capabilities
npx -y -y @smithery/cliergut/mcp-bigquery-server
by ergut
📇 ☁️ - Server implementation for Google BigQuery integration that enables direct BigQuery database access and querying capabilities
npx -y @ergut/mcp-bigquery-serverLucasHild/mcp-server-bigquery
by LucasHild
🐍 ☁️ - BigQuery database integration with schema inspection and query capabilities
npx -y -y @smithery/cliTheRaLabs/legion-mcp
by TheRaLabs
🐍 🏠 Universal database MCP server supporting multiple database types including PostgreSQL, Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, BigQuery, Oracle DB, and SQLite.
npx -y @modelcontextprotocol/inspectorFrequently asked questions
What is the most popular MCP server for Data Warehouses (Snowflake, BigQuery, DuckDB)?
centralmind/gateway leads this list with 528 GitHub stars. 🏎️ 🏠 🍎 🪟 - MCP and MCP SSE Server that automatically generate API based on database schema and data. Supports PostgreSQL, Clickhouse, MySQL, Snowflake, BigQuery, Supabase
Are these Data Warehouses (Snowflake, BigQuery, DuckDB) MCP servers free to use?
7 of the 7 servers here publish a license in the directory (Apache-2.0, GPL-3.0, MIT). 0 of them run as hosted services you can connect to remotely; the rest you install and run yourself. Hosted services may have their own pricing.
How do I choose an MCP server for Data Warehouses (Snowflake, BigQuery, DuckDB)?
Use a native server (Snowflake Labs, BigQuery) for one warehouse; use DuckDB MCP to analyze local files fast; use a gateway when analysts and agents hit several stores.