{"type":"mcp_server","name":"mcp-server-bigquery","description":"This repository provides a Model Context Protocol (MCP) server for accessing BigQuery, enabling LLMs to inspect schemas and execute SQL queries. It supports listing tables, describing schemas, and running queries","category":"Database","language":"Python","stars":127,"forks":5,"owner":"LucasHild","github_url":"https://github.com/LucasHild/mcp-server-bigquery","homepage":null,"setup":"## Setup\n\n### Install\n\n#### Installing via Smithery\n\nTo install BigQuery Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp-server-bigquery):\n\n```bash\nnpx -y @smithery/cli install mcp-server-bigquery --client claude\n```\n\n#### Claude Desktop\n\nOn MacOS: `~/Library/Application\\ Support/Claude/claude_desktop_config.json`\nOn Windows: `%APPDATA%/Claude/claude_desktop_config.json`\n\n##### Development/Unpublished Servers Configuration</summary>\n\n```json\n\"mcpServers\": {\n  \"bigquery\": {\n    \"command\": \"uv\",\n    \"args\": [\n      \"--directory\",\n      \"{{PATH_TO_REPO}}\",\n      \"run\",\n      \"mcp-server-bigquery\",\n      \"--project\",\n      \"{{GCP_PROJECT_ID}}\",\n      \"--location\",\n      \"{{GCP_LOCATION}}\"\n    ]\n  }\n}\n```\n\n##### Published Servers Configuration\n\n```json\n\"mcpServers\": {\n  \"bigquery\": {\n    \"command\": \"uvx\",\n    \"args\": [\n      \"mcp-server-bigquery\",\n      \"--project\",\n      \"{{GCP_PROJECT_ID}}\",\n      \"--location\",\n      \"{{GCP_LOCATION}}\"\n    ]\n  }\n}\n```\n\nReplace `{{PATH_TO_REPO}}`, `{{GCP_PROJECT_ID}}`, and `{{GCP_LOCATION}}` with the appropriate values.","tools":"## Available Tools\n\n\t\t1. `execute-query` (Executes a SQL query using BigQuery dialect)\n\t\t2. `list-tables` (Lists all tables in the BigQuery database)\n\t\t3. `describe-table` (Describes the schema of a specific table)","faq":null,"created_at":"2024-12-03T18:09:19+00:00","updated_at":"2025-03-28T20:28:48+00:00","source_url":"https://model-context-protocol.com/servers/mcp-server-bigquery-access-schemas-queries","related_articles":[]}