# BigQuery Migration Service MCP > Google Cloud managed MCP server for BigQuery Migration Service. Exact tool names and accessible operations depend on the published server reference and configured Google Cloud permissions. Canonical: https://www.mcpfolio.com/servers/google-cloud-bigquery-migration-service Last updated: 2026-10-28 ## Catalog record - Publisher: Google Cloud - Categories: productivity, database, cloud-service, cloud-storage ## Website https://docs.cloud.google.com/bigquery/docs/reference/migration/mcp ## Transports Streamable HTTP ## Authentication Google Cloud authentication: OAuth 2.0 using Application Default Credentials (ADC) in supported Google clients, or a client OAuth ID/secret or bearer token in compatible third-party clients. The principal needs mcp.tools.call plus the underlying product permissions; API key authentication is only available for services that explicitly support it. ## Tools - **translate_query**: Translates a single SQL query or script into BigQuery SQL. The translation runs asynchronously. Use the get_translation tool with the returned translation ID to poll its state until it is SUCCEEDED or FAILED . Wait at least two seconds before rechecking the state. To translate multiple queries, use the translate_batch_queries tool instead. A SUCCEEDED state means the translator finished, not that the output is correct. Check translation_logs before using the output. Entries with severity ERROR mark parts of the output that are best effort. RelationNotFound , AttributeNotFound and MissingMetadataError mean the translator didn't know the schema of a referenced table or column. Unresolved types can appear in the output as ERROR_TYPE(...) or Error , which is not valid BigQuery SQL. To fix the error, provide the schema by using a metadata .ZIP file generated using the BigQuery Migration Service metadata extractor. Upload the file to Cloud Storage and pass the path to the file in metadata_file_path . If the user did not supply a metadata file, ask for it before guessing. Only when no metadata can be provided, use generate_ddl_suggestion to infer approximate DDL from the query. NoSuchFunction means a function the translator couldn't map was copied into the output verbatim, wrapped in backticks. This query should be rewritten manually. The output isn't validated against BigQuery so it must be validated by using a BigQuery dry run, before it is used. - **get_translation**: Gets the SQL translation for a given translation ID. If the state is not yet SUCCEEDED or FAILED , wait at least two seconds before rechecking the state. When it is SUCCEEDED , check translation_logs for entries with severity ERROR before using translated_query . For information on what the errors mean and how to resolve them, see translate_query . - **explain_translation**: Explains the SQL translation for a given translation ID started by translate_query , what was changed between the source and the translated query, and why it was changed. Use it to understand the translation and its WARNING or ERROR logs. It doesn't change the translated query. - **generate_ddl_suggestion**: Suggests Data Definition Language (DDL) statements for an input query. For example, CREATE TABLE or CREATE VIEW . The generated DDL provides schema definitions for tables and views that are used in the query. To get DDL suggestions, call this tool, and then use the fetch_ddl_suggestion tool with the returned suggestion ID to poll its state until it is SUCCEEDED or FAILED and retrieve the DDL. Wait at least two seconds before rechecking the state. You can then prepend the retrieved DDL to the original input query and translate it again to improve translation quality. Use this as a fallback when no metadata .ZIP file from the source system is available. The suggested columns and types are inferred from how the query uses them, so they are approximate and may not cover every object. Prefer a metadata .ZIP file passed in metadata_file_path of translate_query for exact results, and ask the user for one before falling back to suggestions. Prepend the suggested DDL to the input query and re-translate. Then, remove the prepended DDL statements such as CREATE TABLE or CREATE VIEW from the final query, and show the assumed schema to the user for review. - **fetch_ddl_suggestion**: Fetches the DDL suggestion for a given suggestion ID. If the state is not yet SUCCEEDED or FAILED , wait at least two seconds before rechecking the state. The DDL is in suggestion.suggestion_content . For instructions on using it, see generate_ddl_suggestion . - **translate_batch_queries**: Translates a batch of SQL queries stored in Cloud Storage. Before calling this tool, use gcloud storage rsync to stage all input SQL files and any metadata zip or YAML configuration files in Cloud Storage. Pass the path to the files in source_base_uri . If directories are reused between runs, wipe target_base_uri first so that outputs of a previous run are not mixed with the new ones. The translation runs asynchronously. Use the fetch_batch_translation tool with the returned translation ID to poll its state until it is SUCCEEDED or FAILED . Wait at least 10 seconds before rechecking the state. - **fetch_batch_translation**: Retrieves a batch translation workflow's state and logs. If the state is not yet SUCCEEDED or FAILED , wait at least 10 seconds before rechecking the state. When it has finished, use gcloud storage rsync to download the outputs from target_base_uri . Review any translation_logs entries with severity ERROR . These indicate files where the translation is best effort. RelationNotFound and AttributeNotFound mean the schema of a referenced table or column was missing. Provide a metadata zip generated with the BigQuery Migration Service metadata extractor, and ask the user for one if none was supplied. Use generate_batch_ddl_suggestion when no metadata can be provided. - **generate_batch_ddl_suggestion**: Generates Data Definition Language (DDL) suggestions for a batch of queries stored in Cloud Storage. This is a fallback for when no metadata .ZIP file is available from the source system. The suggested columns and types are inferred from how the queries use them, so they are approximate. The suggestion runs asynchronously. Use the fetch_batch_ddl_suggestion tool with the returned suggestion ID to poll its state until it is SUCCEEDED or FAILED . Wait at least 10 seconds before rechecking the state. - **fetch_batch_ddl_suggestion**: Retrieves a batch DDL suggestion workflow's state and logs. If the state is not yet SUCCEEDED or FAILED , wait at least 10 seconds before rechecking the state. When it has finished, download the generated DDL from suggestion.cloud_storage_uri , and ask the user to review it. If the user accepts it, upload it as plain .sql files into a directory under source_base_uri . Don't zip the files. .zip is reserved for metadata extractor output. After uploading the files run translate_batch_queries again. - **translate_metadata**: Translates a metadata .ZIP file into Data Definition Language (DDL) statements and table mappings that are written to target_base_uri . The metadata file is generated by the BigQuery Migration Service metadata extractor and should be uploaded to Cloud Storage. The translation runs asynchronously. Use the fetch_batch_translation tool with the returned translation ID to poll its state until it is SUCCEEDED or FAILED . Wait at least 10 seconds before rechecking the state. If it fails, read the logs returned by fetch_batch_translation to diagnose the issue. After it succeeds, read the results from target_base_uri . ## Sources - [official_server_catalog](https://docs.cloud.google.com/mcp/supported-products) - [official_setup_guide](https://docs.cloud.google.com/mcp/configure-mcp-ai-application) - [official_authentication_guide](https://docs.cloud.google.com/mcp/authenticate-mcp) - [official_tool_reference](https://docs.cloud.google.com/bigquery/docs/reference/migration/mcp) - [official_setup_and_quota_guide](https://docs.cloud.google.com/bigquery/docs/use-bigquery-migration-mcp) ## Setup Use the interactive setup panel on [the detail page](https://www.mcpfolio.com/servers/google-cloud-bigquery-migration-service) to view instructions for each supported client.