Provides read-only access to BigQuery datasets so agents can query and analyze data.
Setup
Choose your client, copy the config, then fill in any required environment variables.
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>"
}
}
}
}Environment variables
PROJECT_ID
Replace the placeholders with your own credentials and keep them out of version control.