takada-at/bq_mcp_server
If you are the rightful owner of bq_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This is a Python-based MCP server designed to interface with Google Cloud BigQuery, providing metadata management, secure query execution, and compliance with the Model Context Protocol.
Tools
Functions exposed to the LLM to take actions
get_datasets
Retrieves a list of all datasets.
get_tables
Retrieves all tables within a specified dataset.
search_metadata
Searches metadata for datasets, tables, and columns.
execute_query
Safely executes BigQuery SQL queries with automatic LIMIT clause insertion and cost control.
check_query_scan_amount
Retrieves the scan amount for BigQuery SQL queries.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client