BigQuery Data Platform
mcpkey · packageio.github.deBilla/data-platform-mcp · v0.4.0
Read-only BigQuery tools for plain-language data questions, with a cost gate on every query
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
#!/usr/bin/env bash # data-platform (io.github.deBilla/data-platform-mcp), recipe baremetal (generated). # Generated by Hub for toolset "my-agent"; started by mcp-my-agent-data-platform.service. set -euo pipefail export HOST=127.0.0.1 PORT=8101 exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- uvx data-platform-mcp==0.4.0 [Unit] Description=MCP server data-platform (toolset my-agent), generated by Hub After=network-online.target Wants=network-online.target [Service] Type=simple User=mcp Group=mcp EnvironmentFile=/etc/mcp/my-agent.env Environment=HOME=/var/lib/mcp/data-platform WorkingDirectory=/var/lib/mcp/data-platform ExecStart=/opt/mcp/my-agent/bin/data-platform.sh Restart=on-failure RestartSec=5 NoNewPrivileges=true ProtectSystem=strict ProtectHome=true PrivateTmp=true ReadWritePaths=/var/lib/mcp/data-platform [Install] WantedBy=multi-user.target
generated from the record, not tested yet
docker run --rm -p 127.0.0.1:8101:8000 -e BQ_MCP_ENVIRONMENTS -e BQ_MCP_DEFAULT_ENVIRONMENT -e BQ_MCP_CONFIG -e BQ_IMPERSONATE_SERVICE_ACCOUNT -e BQ_PROJECT -e BQ_LOCATION -e BQ_CODE_ASSET_LOCATION -e BQ_DATASET_ALLOWLIST -e BQ_WARN_BYTES -e BQ_MAX_BYTES_BILLED -e BQ_MCP_AUDIT_LOG ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx data-platform-mcp==0.4.0'
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T05:28:14+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
# cp .env.example .env # fill the ${VAR}s
# docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
data-platform:
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
command:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx data-platform-mcp==0.4.0
ports:
- 127.0.0.1:8101:8000
volumes:
- uv-cache:/root/.cache/uv
healthcheck:
test:
- CMD
- python3
- -c
- import urllib.request; urllib.request.urlopen('http://127.0.0.1:8000/status')
interval: 30s
timeout: 5s
retries: 5
start_period: 2m
restart: unless-stopped
environment:
BQ_MCP_ENVIRONMENTS: ${BQ_MCP_ENVIRONMENTS}
BQ_MCP_DEFAULT_ENVIRONMENT: ${BQ_MCP_DEFAULT_ENVIRONMENT}
BQ_MCP_CONFIG: ${BQ_MCP_CONFIG}
BQ_IMPERSONATE_SERVICE_ACCOUNT: ${BQ_IMPERSONATE_SERVICE_ACCOUNT}
BQ_PROJECT: ${BQ_PROJECT}
BQ_LOCATION: ${BQ_LOCATION}
BQ_CODE_ASSET_LOCATION: ${BQ_CODE_ASSET_LOCATION}
BQ_DATASET_ALLOWLIST: ${BQ_DATASET_ALLOWLIST}
BQ_WARN_BYTES: ${BQ_WARN_BYTES}
BQ_MAX_BYTES_BILLED: ${BQ_MAX_BYTES_BILLED}
BQ_MCP_AUDIT_LOG: ${BQ_MCP_AUDIT_LOG}
volumes:
npm-cache: {}
uv-cache: {}
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T05:28:14+00:00).
# kubectl create namespace mcp
# kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
# kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: data-platform
namespace: mcp
labels: &id001
app: data-platform
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: data-platform
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: BQ_MCP_ENVIRONMENTS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_ENVIRONMENTS
- name: BQ_MCP_DEFAULT_ENVIRONMENT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_DEFAULT_ENVIRONMENT
- name: BQ_MCP_CONFIG
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_CONFIG
- name: BQ_IMPERSONATE_SERVICE_ACCOUNT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_IMPERSONATE_SERVICE_ACCOUNT
- name: BQ_PROJECT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_PROJECT
- name: BQ_LOCATION
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_LOCATION
- name: BQ_CODE_ASSET_LOCATION
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_CODE_ASSET_LOCATION
- name: BQ_DATASET_ALLOWLIST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_DATASET_ALLOWLIST
- name: BQ_WARN_BYTES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_WARN_BYTES
- name: BQ_MAX_BYTES_BILLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MAX_BYTES_BILLED
- name: BQ_MCP_AUDIT_LOG
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_AUDIT_LOG
command:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx data-platform-mcp==0.4.0
readinessProbe:
httpGet:
path: /status
port: http
initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
name: data-platform
namespace: mcp
spec:
selector:
app: data-platform
ports:
- port: 8000
targetPort: http
name: http
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T05:28:14+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
data-platform:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: data-platform
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: BQ_MCP_ENVIRONMENTS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_ENVIRONMENTS
- name: BQ_MCP_DEFAULT_ENVIRONMENT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_DEFAULT_ENVIRONMENT
- name: BQ_MCP_CONFIG
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_CONFIG
- name: BQ_IMPERSONATE_SERVICE_ACCOUNT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_IMPERSONATE_SERVICE_ACCOUNT
- name: BQ_PROJECT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_PROJECT
- name: BQ_LOCATION
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_LOCATION
- name: BQ_CODE_ASSET_LOCATION
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_CODE_ASSET_LOCATION
- name: BQ_DATASET_ALLOWLIST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_DATASET_ALLOWLIST
- name: BQ_WARN_BYTES
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_WARN_BYTES
- name: BQ_MAX_BYTES_BILLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MAX_BYTES_BILLED
- name: BQ_MCP_AUDIT_LOG
valueFrom:
secretKeyRef:
name: mcp-credentials
key: BQ_MCP_AUDIT_LOG
command:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx data-platform-mcp==0.4.0
readinessProbe:
httpGet:
path: /status
port: http
initialDelaySeconds: 10
# helm install my-agent helm/my-agent -n mcp
in the cloud
one click: the provider's deploy form opens filled in, in your own account- koyeb
-
The form opens with CHANGE_ME for each value you supply: BQ_MCP_ENVIRONMENTS, BQ_MCP_DEFAULT_ENVIRONMENT, BQ_MCP_CONFIG, BQ_IMPERSONATE_SERVICE_ACCOUNT, BQ_PROJECT, BQ_LOCATION, BQ_CODE_ASSET_LOCATION, BQ_DATASET_ALLOWLIST, BQ_WARN_BYTES, BQ_MAX_BYTES_BILLED, BQ_MCP_AUDIT_LOG. Fill them in before you deploy.
Clients connect to the service's https://…koyeb.app address plus /mcp.
- azure
-
A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.
connect to it
copy what your client needsuvx data-platform-mcp==0.4.0 # env: BQ_MCP_ENVIRONMENTS, BQ_MCP_DEFAULT_ENVIRONMENT, BQ_MCP_CONFIG, BQ_IMPERSONATE_SERVICE_ACCOUNT, BQ_PROJECT, BQ_LOCATION, BQ_CODE_ASSET_LOCATION, BQ_DATASET_ALLOWLIST, BQ_WARN_BYTES, BQ_MAX_BYTES_BILLED, BQ_MCP_AUDIT_LOG
{
"mcpServers": {
"data-platform": {
"command": "uvx",
"args": [
"data-platform-mcp==0.4.0"
],
"env": {
"BQ_MCP_ENVIRONMENTS": "${BQ_MCP_ENVIRONMENTS}",
"BQ_MCP_DEFAULT_ENVIRONMENT": "${BQ_MCP_DEFAULT_ENVIRONMENT}",
"BQ_MCP_CONFIG": "${BQ_MCP_CONFIG}",
"BQ_IMPERSONATE_SERVICE_ACCOUNT": "${BQ_IMPERSONATE_SERVICE_ACCOUNT}",
"BQ_PROJECT": "${BQ_PROJECT}",
"BQ_LOCATION": "${BQ_LOCATION}",
"BQ_CODE_ASSET_LOCATION": "${BQ_CODE_ASSET_LOCATION}",
"BQ_DATASET_ALLOWLIST": "${BQ_DATASET_ALLOWLIST}",
"BQ_WARN_BYTES": "${BQ_WARN_BYTES}",
"BQ_MAX_BYTES_BILLED": "${BQ_MAX_BYTES_BILLED}",
"BQ_MCP_AUDIT_LOG": "${BQ_MCP_AUDIT_LOG}"
}
}
}
}
#!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add data-platform -e "BQ_MCP_ENVIRONMENTS=${BQ_MCP_ENVIRONMENTS}" -e "BQ_MCP_DEFAULT_ENVIRONMENT=${BQ_MCP_DEFAULT_ENVIRONMENT}" -e "BQ_MCP_CONFIG=${BQ_MCP_CONFIG}" -e "BQ_IMPERSONATE_SERVICE_ACCOUNT=${BQ_IMPERSONATE_SERVICE_ACCOUNT}" -e "BQ_PROJECT=${BQ_PROJECT}" -e "BQ_LOCATION=${BQ_LOCATION}" -e "BQ_CODE_ASSET_LOCATION=${BQ_CODE_ASSET_LOCATION}" -e "BQ_DATASET_ALLOWLIST=${BQ_DATASET_ALLOWLIST}" -e "BQ_WARN_BYTES=${BQ_WARN_BYTES}" -e "BQ_MAX_BYTES_BILLED=${BQ_MAX_BYTES_BILLED}" -e "BQ_MCP_AUDIT_LOG=${BQ_MCP_AUDIT_LOG}" -- uvx data-platform-mcp==0.4.0
{
"mcpServers": {
"data-platform": {
"command": "uvx",
"args": [
"data-platform-mcp==0.4.0"
],
"env": {
"BQ_MCP_ENVIRONMENTS": "${BQ_MCP_ENVIRONMENTS}",
"BQ_MCP_DEFAULT_ENVIRONMENT": "${BQ_MCP_DEFAULT_ENVIRONMENT}",
"BQ_MCP_CONFIG": "${BQ_MCP_CONFIG}",
"BQ_IMPERSONATE_SERVICE_ACCOUNT": "${BQ_IMPERSONATE_SERVICE_ACCOUNT}",
"BQ_PROJECT": "${BQ_PROJECT}",
"BQ_LOCATION": "${BQ_LOCATION}",
"BQ_CODE_ASSET_LOCATION": "${BQ_CODE_ASSET_LOCATION}",
"BQ_DATASET_ALLOWLIST": "${BQ_DATASET_ALLOWLIST}",
"BQ_WARN_BYTES": "${BQ_WARN_BYTES}",
"BQ_MAX_BYTES_BILLED": "${BQ_MAX_BYTES_BILLED}",
"BQ_MCP_AUDIT_LOG": "${BQ_MCP_AUDIT_LOG}"
}
}
}
}
{
"servers": {
"data-platform": {
"type": "stdio",
"command": "uvx",
"args": [
"data-platform-mcp==0.4.0"
],
"env": {
"BQ_MCP_ENVIRONMENTS": "${BQ_MCP_ENVIRONMENTS}",
"BQ_MCP_DEFAULT_ENVIRONMENT": "${BQ_MCP_DEFAULT_ENVIRONMENT}",
"BQ_MCP_CONFIG": "${BQ_MCP_CONFIG}",
"BQ_IMPERSONATE_SERVICE_ACCOUNT": "${BQ_IMPERSONATE_SERVICE_ACCOUNT}",
"BQ_PROJECT": "${BQ_PROJECT}",
"BQ_LOCATION": "${BQ_LOCATION}",
"BQ_CODE_ASSET_LOCATION": "${BQ_CODE_ASSET_LOCATION}",
"BQ_DATASET_ALLOWLIST": "${BQ_DATASET_ALLOWLIST}",
"BQ_WARN_BYTES": "${BQ_WARN_BYTES}",
"BQ_MAX_BYTES_BILLED": "${BQ_MAX_BYTES_BILLED}",
"BQ_MCP_AUDIT_LOG": "${BQ_MCP_AUDIT_LOG}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.deBilla/data-platform-mcp
- not probed yet: tools unpinned, ingest lists them
tools
Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.