bigquery-migration-sql-translator
This Google skill helps an agent move SQL from Teradata, Oracle, Redshift, Snowflake, SparkSQL or HiveQL to BigQuery GoogleSQL through the BigQuery Migration Service and its remote MCP server.
What the skill teaches
This Google skill helps an agent move SQL from Teradata, Oracle, Redshift, Snowflake, SparkSQL or HiveQL to BigQuery GoogleSQL through the BigQuery Migration Service and its remote MCP server. It lists the setup first: a billing-enabled project, the Migration API turned on, roles for MCP tool use, migration editing and Cloud Storage access, and an MCP connection whose setup is described for Claude, Cursor, Gemini CLI and VS Code. It then covers interactive translation of single queries, batch translation of files staged in Cloud Storage, triage of compiler errors, YAML translation settings and dialect-specific pitfalls. It comes with config examples, JSON schemas and a Python template.
Capabilities
- Translate legacy SQL queries to BigQuery GoogleSQL
- Run batch translation of files staged in Cloud Storage
- Configure YAML translation settings
- Resolve translation errors by dialect
Install
- Run this to add it to Any client:
npx skills add google/skills
What's inside
- assets/python_embedded_sql_migrator_template.py
- assets/translation_config_examples/environment_example.yaml
- assets/translation_config_examples/experimental_input_formats_example.yaml
- assets/translation_config_examples/experimental_metadata_example.yaml
- assets/translation_config_examples/experimental_object_rewriter_example.yaml
- assets/translation_config_examples/experimental_optimizer_example.yaml
- assets/translation_config_examples/experimental_statement_rewriter_example.yaml
- assets/translation_config_examples/input_formats_example.yaml
- assets/translation_config_examples/metadata_example.yaml
- assets/translation_config_examples/object_rewriter_example.yaml
- assets/translation_config_examples/optimizer_example.yaml
- assets/translation_config_examples/statement_rewriter_example.yaml
- assets/translation_config_schemas/environment.json
- assets/translation_config_schemas/experimental_input_formats.json
- assets/translation_config_schemas/experimental_metadata.json
- assets/translation_config_schemas/experimental_object_rewriter.json
- assets/translation_config_schemas/experimental_optimizer.json
- assets/translation_config_schemas/experimental_statement_rewriter.json
- assets/translation_config_schemas/input_formats.json
- assets/translation_config_schemas/metadata.json
- assets/translation_config_schemas/object_rewriter.json
- assets/translation_config_schemas/optimizer.json
- assets/translation_config_schemas/statement_rewriter.json
- assets/translation_config_schemas/transpiler_config_spec.json
- references/attribution.md
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | BigQuery | |
| Publisher | source | |
| Official status | Officialpublished in Google's own GitHub organisation; Google develops BigQuery | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 11, 202623,842 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
More from Google
81 servers · 73 skills
- MCP Toolbox for Databases (MCP server)
- Storage MCP Server (MCP server)
- gcloud MCP Server (MCP server)
- Google Cloud Observability MCP Server (MCP server)
- google-cloud-recipe-auth (Skill)
- google-cloud-recipe-onboarding (Skill)
Badge for your README
Maintain this project? Add a badge that links to this page.
[](https://kitbay.app/skills/google-bigquery-migration-sql-translator/)
Sources
- Skill file (SKILL.md)github.com/google/skillsNov 10, 2026
- README (README.md)github.com/google/skills · Backs: Official statusNov 12, 2026
- Licence file (LICENSE)github.com/google/skills · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/google/skills · Backs: Publisher, Activity, LicenceNov 11, 2026
- Folder in the repository (bigquery-migration-sql-translator)github.com/google/skills · Backs: Includes scriptsNov 10, 2026