Loading...
This MCP server enables LLMs to query BigQuery data using natural language, providing a secure read-only interface for data analysis and exploration.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
This MCP server enables LLMs to query BigQuery data using natural language, providing a secure read-only interface for data analysis and exploration.
This server is generally safe for querying BigQuery data due to its read-only nature and query limits. However, it's crucial to secure the service account and monitor query activity to prevent unauthorized access or data leakage.
Query performance depends on the complexity of the query and the size of the data being processed. Consider optimizing queries for better performance.
BigQuery charges for query processing based on the amount of data scanned. Monitor query costs to avoid unexpected charges.
npx @smithery/cli install @ergut/mcp-bigquery-server --client claude{
"mcpServers": {
"bigquery": {
"command": "node",
"args": [
"/path/to/your/clone/mcp-bigquery-server/dist/index.js",
"--project-id",
"your-project-id",
"--location",
"us-central1",
"--key-file",
"/path/to/service-account-key.json"
]
}
}
}BigQuery QueryExecutes SQL queries against BigQuery datasets based on natural language input.
Queries are read-only and limited to 1GB of processing.
Dataset Schema ExplorationAllows browsing and understanding the structure of BigQuery datasets, including tables and views.
Provides read-only access to dataset metadata.
OAuth|Token
cloud
roles/bigquery.userroles/bigquery.dataViewerroles/bigquery.jobUserThis server is generally safe for querying BigQuery data due to its read-only nature and query limits. However, it's crucial to secure the service account and monitor query activity to prevent unauthorized access or data leakage.
The server operates in read-only mode, preventing any modifications to the underlying data. Autonomy is limited by the 1GB query size limit.
Production Tip
Use a dedicated service account with minimal permissions to limit the potential impact of security breaches.
MCP is a standard for enabling LLMs to interact with external data sources like databases.
The service account needs either `roles/bigquery.user` or both `roles/bigquery.dataViewer` and `roles/bigquery.jobUser`.
The query size limit is 1GB by default.
Currently, MCP support is only available in Claude Desktop (developer preview).
Store the key file securely and never commit it to version control. Use environment variables or a secrets manager to manage the key.
The query will be terminated, and an error message will be returned to the client.
Yes, the server can be customized and extended by modifying the code and adding new features.