MCP Servers / database / BigQuery

BigQuery

JSON →
none5database

Access Google BigQuery to understand dataset structures and execute SQL queries.

Install
How to run this server
[ { "cmd": "npx @modelcontextprotocol/inspector", "imports": [] } ]
server path: bigquery-4
Tools
What this server exposes
query
Execute read-only (SELECT) BigQuery SQL queries with configurable maximum results and bytes billed, and security checks to prevent non-SELECT queries
list_all_datasets
List all datasets in the project, returning an array of dataset IDs
list_all_tables_with_dataset
List all tables in a specific dataset with their schemas, requiring a datasetId parameter, and returning table IDs, schemas, time partitioning information, and descriptions
get_table_information
Get table schema and sample data (up to 20 rows) with support for partitioned tables and partition filters, including warnings for queries on partitioned tables without filters
dry_run_query
Check query validity and estimate cost without execution, returning processing size and estimated cost
Configuration
Environment & auth
authnone
Resources