# On dbt with Snowflake or Databricks, six servers cover the stack, and they split SQL, models and semantics differently

SITUATION, read 10 Nov 2026

**The short answer.** An analytics engineering team on dbt with Snowflake or Databricks has six servers to read: the dbt MCP Server, three for Snowflake and two for Databricks. The checks below cover which ones run SQL, which read models and the semantic layer, how each signs in, and which are deprecated, read 10 Nov 2026.

A dbt team wires an agent to two places: the dbt project (models, tests, lineage, metrics) and the warehouse that runs it. The dbt MCP Server covers the first; the warehouse servers cover the second.

Two of the six carry a deprecation notice in their own README: the Snowflake Labs server and the Databricks Labs Unity Catalog server. Both point to the vendor's managed server.

## What to check

| Check | The field or fact that answers it |
| --- | --- |
| Which server runs SQL, and as whom? | Auth and Access fields; SQL tool names |
| Which server reads dbt models, tests and column lineage? | The dbt MCP Server's tool names and lineage facts |
| Is the server deprecated or moved? | Status field |
| Hosted or local? | Transport field |

## The published facts, for the 9 servers in scope

| Server | Kind | Transport | Auth | Access | Status |
| --- | --- | --- | --- | --- | --- |
| [Amazon Redshift MCP Server (AWS Labs)](/servers/awslabs-redshift-mcp-server/) | Official, Labs org | Local (stdio) | AWS credentials (profile/env) with IAM and Redshift Data API; database user privileges. | Configurable | Exists in awslabs/mcp; PyPI 0.1.3 uploaded 9 Nov 2026 (read 10 Nov 2026). |
| [BigQuery remote MCP server](/servers/bigquery-remote-mcp/) | Official | Remote (hosted) | OAuth 2.0 with IAM (Google Cloud identities, OAuth client, or agent identity). | Configurable | Exists; Google-managed endpoint, reference page last updated 3 Nov 2026 (read 10 Nov 2026). |
| [MCP Toolbox for Databases (BigQuery tools)](/servers/mcp-toolbox-bigquery/) | Official | Remote and local | Application Default Credentials, client OAuth token forwarding, or service account impersonation. | Configurable | Repo googleapis/genai-toolbox now lives at googleapis/mcp-toolbox (read 10 Nov 2026); BigQuery tools documented there. |
| [Databricks Labs MCP servers](/servers/databrickslabs-mcp/) | Official, Labs org | Remote and local | Databricks CLI-style credentials; Unity Catalog permissions. | Not stated in the source read | Exists; README marks Unity Catalog server deprecated in favor of managed MCP servers; last push 26 Oct 2026 (GitHub API); no tagged release read. |
| [Databricks managed MCP servers](/servers/databricks-managed-mcp/) | Official | Remote (hosted) | Databricks workspace sign-in; caller's Unity Catalog permissions; Unity Gateway grants and policies. | Configurable | Documented by Databricks as Databricks-provided MCPs (read 10 Nov 2026); no versioned release stream found. |
| [dbt MCP Server](/servers/dbt-mcp/) | Official | Remote and local | dbt service/personal token and environment IDs for platform tools; OAuth or token per docs; local dbt project for CLI tools. | Configurable | Exists, v2.10.1 on 3 Nov 2026 (PyPI and GitHub). |
| [mcp-snowflake-server (community)](/servers/isaacwasserman-mcp-snowflake-server/) | Community | Local (stdio) | Snowflake user credentials (password, private key, external browser) or connections.toml. | Configurable | Exists as a community server; PyPI 0.4.0 dated 10 Apr 2025, GitHub pushed 7 Oct 2025 (GitHub API). |
| [Snowflake Labs MCP Server](/servers/snowflake-labs-mcp/) | Official, Labs org | Remote and local | Snowflake Python connector: password/PAT, key pair, OAuth, SSO, MFA; honors the connection role's RBAC. | Configurable | Exists, but the README states it is deprecated and no longer maintained and points to the Snowflake-managed MCP server (read 10 Nov 2026). |
| [Snowflake-managed MCP server](/servers/snowflake-managed-mcp/) | Official | Remote (hosted) | Snowflake OAuth (default) or External OAuth; PAT supported; RBAC per MCP server and per tool. | Configurable | Documented by Snowflake as the Snowflake-managed MCP server (read 10 Nov 2026); the Snowflake-Labs repository points users here. |

Filed by data tool, read 10 Nov 2026. Scope: warehouses, transformation.

## What each server documents on publisher and releases

- [Amazon Redshift MCP Server (AWS Labs)](/servers/awslabs-redshift-mcp-server/): The server lives in the awslabs/mcp repository and PyPI lists author Amazon Web Services; awslabs.redshift-mcp-server 0.1.3 was uploaded 9 Nov 2026. README calls it a server to discover, explore and query Redshift clusters and serverless workgroups.
- [BigQuery remote MCP server](/servers/bigquery-remote-mcp/): Google documents a BigQuery remote MCP server, enabled when the BigQuery API is enabled. The reference page for bigquery.googleapis.com MCP shows Last updated 3 Nov 2026 UTC; no semantic version is published.
- [MCP Toolbox for Databases (BigQuery tools)](/servers/mcp-toolbox-bigquery/): MCP Toolbox for Databases is an open source MCP server in the googleapis organization (formerly genai-toolbox) with a BigQuery prebuilt config. The latest GitHub release is v1.16.0, whose release timestamp on the page is 5 Nov 2026.
- [Databricks Labs MCP servers](/servers/databrickslabs-mcp/): Databrickslabs/mcp is a Databricks Labs repository whose README calls the Unity Catalog server deprecated in favor of Managed MCP servers. The repo has no GitHub release entries read; GitHub API shows last push 26 Oct 2026 and no archive flag.
- [Databricks managed MCP servers](/servers/databricks-managed-mcp/): Databricks documents Databricks-provided MCPs in the system.ai schema, with no server to host or register; the page was last updated Nov 9, 2026. Genie One MCP is generally available while dbsql, sandbox and web_search require the Unity Gateway beta.
- [dbt MCP Server](/servers/dbt-mcp/): dbt Labs publishes dbt-mcp; the latest GitHub release is v2.10.1, whose release timestamp on the page is 3 Nov 2026 (PyPI also 3 Nov 2026). dbt Labs documents the MCP server on docs.getdbt.com and ships it as self-hosted or remote.
- [mcp-snowflake-server (community)](/servers/isaacwasserman-mcp-snowflake-server/): The server is a community project by isaacwasserman, not published by Snowflake; license is GPL-3.0 per GitHub API. PyPI lists mcp-snowflake-server 0.4.0 uploaded 10 Apr 2025; the GitHub repo was last pushed 7 Oct 2025.
- [Snowflake Labs MCP Server](/servers/snowflake-labs-mcp/): Snowflake Labs marks its Snowflake-Labs/mcp repository as deprecated and unmaintained, pointing users to the official Snowflake MCP server. The latest PyPI/GitHub release of snowflake-labs-mcp is v1.4.2, published 15 May 2026 and titled as the release that starts deprecation. PyPI lists snowflake-labs-mcp 1.4.2 uploaded 15 May 2026 by Snowflake Labs authors.
- [Snowflake-managed MCP server](/servers/snowflake-managed-mcp/): Snowflake documents a Snowflake-managed MCP server that lets agents retrieve data from Snowflake accounts without deploying separate infrastructure. The docs state support for MCP protocol revision 25 Nov 2025; no semantic version number or release date is published on the page.

## Other situations

- [A data platform lead whose analysts no longer trust the dashboards](/situations/untrusted-dashboards/)
- [A company putting AI agents on its data this year](/situations/agents-this-year/)
- [A governance lead who must show where a regulated field flows](/situations/regulated-field/)
- [A BI team with thousands of reports and no map of what feeds them](/situations/bi-sprawl/)

## Sources

- pypi.org/pypi/awslabs.redshift-mcp-server/json: https://pypi.org/pypi/awslabs.redshift-mcp-server/json (read 10 Nov 2026)
- raw.githubusercontent.com/awslabs/mcp/main/src/redshift-mcp-server/README.md: https://raw.githubusercontent.com/awslabs/mcp/main/src/redshift-mcp-server/README.md (read 10 Nov 2026)
- docs.cloud.google.com/bigquery/docs/use-bigquery-mcp: https://docs.cloud.google.com/bigquery/docs/use-bigquery-mcp (read 10 Nov 2026)
- docs.cloud.google.com/bigquery/docs/reference/mcp: https://docs.cloud.google.com/bigquery/docs/reference/mcp (read 10 Nov 2026)
- raw.githubusercontent.com/googleapis/mcp-toolbox/main/README.md: https://raw.githubusercontent.com/googleapis/mcp-toolbox/main/README.md (read 10 Nov 2026)
- github.com/googleapis/mcp-toolbox/releases: https://github.com/googleapis/mcp-toolbox/releases (read 10 Nov 2026)
- raw.githubusercontent.com/databrickslabs/mcp/master/README.md: https://raw.githubusercontent.com/databrickslabs/mcp/master/README.md (read 10 Nov 2026)
- docs.databricks.com/aws/en/generative-ai/mcp/managed-mcp: https://docs.databricks.com/aws/en/generative-ai/mcp/managed-mcp (read 10 Nov 2026)
- github.com/dbt-labs/dbt-mcp/releases: https://github.com/dbt-labs/dbt-mcp/releases (read 10 Nov 2026)
- docs.getdbt.com/docs/dbt-ai/about-mcp: https://docs.getdbt.com/docs/dbt-ai/about-mcp (read 10 Nov 2026)
- raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md: https://raw.githubusercontent.com/isaacwasserman/mcp-snowflake-server/main/README.md (read 10 Nov 2026)
- pypi.org/pypi/mcp-snowflake-server/json: https://pypi.org/pypi/mcp-snowflake-server/json (read 10 Nov 2026)
- raw.githubusercontent.com/Snowflake-Labs/mcp/main/README.md: https://raw.githubusercontent.com/Snowflake-Labs/mcp/main/README.md (read 10 Nov 2026)
- github.com/Snowflake-Labs/mcp/releases: https://github.com/Snowflake-Labs/mcp/releases (read 10 Nov 2026)
- pypi.org/pypi/snowflake-labs-mcp/json: https://pypi.org/pypi/snowflake-labs-mcp/json (read 10 Nov 2026)
- docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp: https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-agents-mcp (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datamcpservers.com/situations/dbt-warehouse/
