0.7.1pypi · mcp-bigquery · current release
Observed 2026-08-23T22:18:00.385Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2025-06-18.
{
"experimental": {},
"tools": {
"listChanged": false
}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
bq_describe_tableGet table schema, metadata, and statisticsInput schema{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"description": "The table ID"
},
"dataset_id": {
"type": "string",
"description": "The dataset ID"
},
"project_id": {
"type": "string",
"description": "GCP project ID (uses default if not provided)"
},
"format_output": {
"type": "boolean",
"description": "Whether to format schema as table string"
}
},
"required": [
"table_id",
"dataset_id"
]
} | — | — · — | — |
bq_dry_run_sqlPerform a dry-run of a BigQuery SQL query to get cost estimates and metadataInput schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "The SQL query to dry-run"
},
"params": {
"type": "object",
"description": "Optional query parameters (key-value pairs)",
"additionalProperties": true
},
"pricePerTiB": {
"type": "number",
"description": "Price per TiB for cost estimation (defaults to env var or 5.0)"
}
},
"required": [
"sql"
]
} | — | — · — | — |
bq_extract_dependenciesExtract table and column dependencies from BigQuery SQLInput schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "The SQL query to analyze"
},
"params": {
"type": "object",
"description": "Optional query parameters (key-value pairs)",
"additionalProperties": true
}
},
"required": [
"sql"
]
} | — | — · — | — |
bq_get_table_infoGet comprehensive table information including partitioning and clusteringInput schema{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"description": "The table ID"
},
"dataset_id": {
"type": "string",
"description": "The dataset ID"
},
"project_id": {
"type": "string",
"description": "GCP project ID (uses default if not provided)"
}
},
"required": [
"table_id",
"dataset_id"
]
} | — | — · — | — |
bq_list_datasetsList all datasets in the BigQuery projectInput schema{
"type": "object",
"properties": {
"project_id": {
"type": "string",
"description": "GCP project ID (uses default if not provided)"
},
"max_results": {
"type": "integer",
"description": "Maximum number of datasets to return"
}
}
} | — | — · — | — |
bq_list_tablesList all tables in a BigQuery dataset with metadataInput schema{
"type": "object",
"properties": {
"dataset_id": {
"type": "string",
"description": "The dataset ID"
},
"project_id": {
"type": "string",
"description": "GCP project ID (uses default if not provided)"
},
"max_results": {
"type": "integer",
"description": "Maximum number of tables"
},
"table_type_filter": {
"type": "array",
"items": {
"type": "string"
},
"description": "Filter by table types (TABLE, VIEW, EXTERNAL, MATERIALIZED_VIEW)"
}
},
"required": [
"dataset_id"
]
} | — | — · — | — |
bq_preview_tableGet a preview of table data without running a query job (cost-free)Input schema{
"type": "object",
"properties": {
"dataset_id": {
"type": "string",
"description": "The dataset ID"
},
"table_id": {
"type": "string",
"description": "The table ID"
},
"project_id": {
"type": "string",
"description": "GCP project ID (uses default if not provided)"
},
"max_results": {
"type": "integer",
"description": "Maximum number of rows to preview (default: 5, hard limit: 10)"
}
},
"required": [
"dataset_id",
"table_id"
]
} | — | — · — | — |
bq_validate_query_syntaxEnhanced syntax validation with detailed error reportingInput schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "The SQL query to validate"
},
"params": {
"type": "object",
"description": "Optional query parameters (key-value pairs)",
"additionalProperties": true
}
},
"required": [
"sql"
]
} | — | — · — | — |
bq_validate_sqlValidate BigQuery SQL syntax without executing the queryInput schema{
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "The SQL query to validate"
},
"params": {
"type": "object",
"description": "Optional query parameters (key-value pairs)",
"additionalProperties": true
}
},
"required": [
"sql"
]
} | — | — · — | — |