Schema | bq_mcp_server

bq_mcp_server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`PROJECT_IDS`	Yes	Comma-separated list of GCP project IDs

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
get_datasetsA	Get list of all datasets
get_tablesC	Get list of all tables in a dataset
search_metadataC	Search metadata for datasets, tables, and columns
check_query_scan_amountA	`Check the scan amount of a BigQuery SQL query using dry-run without executing it. Args: sql: The SQL query to check project_id: Optional project ID to use for the query (defaults to first configured project)`
execute_queryA	`Execute BigQuery SQL with automatic safety checks and LIMIT clause management. Args: sql: The SQL query to execute project_id: Optional project ID to use for the query (defaults to first configured project)`
save_query_resultA	`Execute BigQuery SQL and save results to a local file. Args: sql: The SQL query to execute output_path: Path where to save the results format: Output format - 'csv' or 'jsonl' (defaults to 'csv') project_id: Optional project ID to use for the query (defaults to first configured project) include_header: Include header row in CSV output (ignored for JSONL, defaults to True)`

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/takada-at/bq_mcp_server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server