bi-cloud-run-mcp-servers
Verified Safeby yummysuperapp
Overview
Provides AI assistants (like Claude) with access to dbt models, metrics, and BigQuery data via an MCP server deployed on Google Cloud Run.
Installation
docker run --rm -p 8080:8080 --env-file .env.production --name dbt-mcp-local dbt-mcp-server:localEnvironment Variables
- PROJECT_ID
- REGION
- DBT_PROD_ENV_ID
- DBT_USER_ID
- DBT_TOKEN
- GITHUB_TOKEN
- GOOGLE_APPLICATION_CREDENTIALS_JSON
Security Notes
The project demonstrates strong security practices, emphasizing avoiding hardcoded credentials by using environment variables, GitHub Secrets, and Cloud Run Secret Manager. It provides clear documentation and setup guides for secure configuration, including proper `.gitignore` usage and separate service accounts for least privilege. The default `--allow-unauthenticated` for Cloud Run requires user attention for production hardening, but instructions to disable it are provided.
Similar Servers
context-portal
Manages structured project context for AI assistants and developer tools, enabling Retrieval Augmented Generation (RAG) and prompt caching within IDEs.
dbt-mcp
Provides a Model Context Protocol (MCP) server that exposes various dbt-related functionalities (CLI, Semantic Layer, Discovery, Admin API, Code Generation, LSP) as tools for AI agents to interact with dbt projects in Core, Fusion, and Platform environments.
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
dbt-core-mcp
A Model Context Protocol (MCP) server that empowers AI assistants (like Copilot) to interact with and manage dbt projects. It enables natural language control over dbt operations, providing project metadata, lineage, impact analysis, SQL query execution, and intelligent build/test workflows, all while respecting the user's local dbt environment.