Provides read-only access to BigQuery datasets so agents can query and analyze data.
接入配置
选择客户端，复制配置，再按项目文档补齐环境变量。
claude mcp add bigquery --env PROJECT_ID='<PROJECT_ID>' -- npx -y @ergut/mcp-bigquery-server --project-id '{{config.PROJECT_ID}}' --location '{{config.LOCATION}}' '{{config.KEY_FILE_ARG}}'~/.codex/config.toml
[mcp_servers.bigquery]
command = "npx"
args = ["-y", "@ergut/mcp-bigquery-server", "--project-id", "{{config.PROJECT_ID}}", "--location", "{{config.LOCATION}}", "{{config.KEY_FILE_ARG}}"]
env = { PROJECT_ID = "<PROJECT_ID>" }
# codex mcp add bigquery --env PROJECT_ID='<PROJECT_ID>' -- npx -y @ergut/mcp-bigquery-server --project-id '{{config.PROJECT_ID}}' --location '{{config.LOCATION}}' '{{config.KEY_FILE_ARG}}'~/.cursor/mcp.json
{
"mcpServers": {
"bigquery": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id",
"{{config.PROJECT_ID}}",
"--location",
"{{config.LOCATION}}",
"{{config.KEY_FILE_ARG}}"
],
"env": {
"PROJECT_ID": "<PROJECT_ID>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"bigquery": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id",
"{{config.PROJECT_ID}}",
"--location",
"{{config.LOCATION}}",
"{{config.KEY_FILE_ARG}}"
],
"env": {
"PROJECT_ID": "<PROJECT_ID>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"bigquery": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id",
"{{config.PROJECT_ID}}",
"--location",
"{{config.LOCATION}}",
"{{config.KEY_FILE_ARG}}"
],
"env": {
"PROJECT_ID": "<PROJECT_ID>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"bigquery": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id",
"{{config.PROJECT_ID}}",
"--location",
"{{config.LOCATION}}",
"{{config.KEY_FILE_ARG}}"
],
"env": {
"PROJECT_ID": "<PROJECT_ID>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"bigquery": {
"command": "npx",
"args": [
"-y",
"@ergut/mcp-bigquery-server",
"--project-id",
"{{config.PROJECT_ID}}",
"--location",
"{{config.LOCATION}}",
"{{config.KEY_FILE_ARG}}"
],
"env": {
"PROJECT_ID": "<PROJECT_ID>"
}
}
}
}需要的环境变量
PROJECT_ID
把占位值换成你自己的密钥；不要把密钥提交到代码仓库。