Overview
The BigQuery MCP server is a Model Context Protocol server that provides access to Google BigQuery, allowing large language models (LLMs) to inspect database schemas and execute SQL queries.
To use the server, configure it with your GCP project ID and location, then execute SQL queries or list tables using the provided tools.
- Execute SQL queries using BigQuery dialect. - List all tables in the BigQuery database. - Describe the schema of specific tables.
- Data analysis and reporting using SQL queries.
- Schema inspection for understanding database structure.
- Integration with LLMs for enhanced data querying capabilities.
Add to your AI client
Use these steps to connect BigQuery MCP server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.
Cursor
Add this to your .cursor/mcp.json file in your project root, then restart Cursor.
.cursor/mcp.json
{
"mcpServers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}Claude Desktop
Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)
{
"mcpServers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}Claude Code
Add this to your project's .mcp.json file. Claude Code will detect it automatically.
.mcp.json (project root)
{
"mcpServers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}VS Code (Copilot)
Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.
.vscode/mcp.json
{
"servers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}Windsurf
Add this to your Windsurf MCP config file, then restart Windsurf.
~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}Cline
Open Cline settings, navigate to MCP Servers, and add this server configuration.
Cline MCP Settings (via UI)
{
"mcpServers": {
"lucashild-mcp-server-bigquery-mcp-mirror": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-lucashild-mcp-server-bigquery-mcp-mirror"
]
}
}
}FAQ
What is required to run the server?
You need to provide the GCP project ID and location.
Can I specify which datasets to consider?
Yes, you can specify datasets using the `--dataset` argument.
How do I install the server?
Follow the quickstart guide to install and configure the server on your machine.