# Bigquery migration metadata extractor

> Bigquery migration metadata extractor is an open-source agent skill for databases. Extracts database catalog metadata and query logs from data warehouses by running the DWH migration extractor locally or on a temporary Goog. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/google/skills/tree/main/skills/cloud/bigquery-migration-metadata-extractor
- **Repository:** https://github.com/google/skills
- **GitHub stars:** 24,379
- **License:** Apache-2.0
- **Skill name:** bigquery-migration-metadata-extractor
- **Collection:** https://github.com/google/skills
- **Categories:** databases, files and documents
- **Listing updated:** 2026-11-17

## About

Extracts database catalog metadata and query logs from data warehouses by running the DWH migration extractor locally or on a temporary Google Cloud VM through the BigQuery Migration Cloud Extractor (credentials held in Secret Manager), and inspects extracted `.zip` archives to report object and volume statistics. Use when extracting database metadata or query logs from Snowflake, Redshift, Teradata, Oracle, PostgreSQL, SQL Server, Hive, etc., deciding between local and cloud (Cloud Extractor) extraction, or inspecting extracted dwh-migration-*.zip archives to print post-extraction statistics. Don't use for SQL dialect translation (use bigquery-migration-sql-translator), exporting table data to Parquet or CSV files (such as Snowflake `COPY INTO` unloads) or loading it into BigQuery (use the BigQuery Data Transfer Service or bigquery-basics), or validating migrated data.

## When your agent uses it

> Extracts database catalog metadata and query logs from data warehouses by running the DWH migration extractor locally or on a temporary Google Cloud VM through the BigQuery Migration Cloud Extractor (credentials held in Secret Manager), and inspects extracted `.zip` archives to report object and volume statistics. Use when extracting database metadata or query logs from Snowflake, Redshift, Teradata, Oracle, PostgreSQL, SQL Server, Hive, etc., deciding between local and cloud (Cloud Extractor) extraction, or inspecting extracted dwh-migration-*.zip archives to print post-extraction statistics. Don't use for SQL dialect translation (use bigquery-migration-sql-translator), exporting table data to Parquet or CSV files (such as Snowflake `COPY INTO` unloads) or loading it into BigQuery (use the BigQuery Data Transfer Service or bigquery-basics), or validating migrated data.

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Runs Python scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/bigquery-migration-metadata-extractor)
- [No network calls found in its scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/bigquery-migration-metadata-extractor)
- [License: Apache-2.0](https://github.com/google/skills/tree/HEAD/skills/cloud/bigquery-migration-metadata-extractor)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/bigquery-migration-metadata-extractor` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/bigquery-migration-metadata-extractor &&
cp -R "$tmp/skills/cloud/bigquery-migration-metadata-extractor" ~/.claude/skills/bigquery-migration-metadata-extractor &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/bigquery-migration-metadata-extractor` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/bigquery-migration-metadata-extractor` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/bigquery-migration-metadata-extractor &&
cp -R "$tmp/skills/cloud/bigquery-migration-metadata-extractor" ~/.agents/skills/bigquery-migration-metadata-extractor &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/bigquery-migration-metadata-extractor` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/bigquery-migration-metadata-extractor` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/bigquery-migration-metadata-extractor &&
cp -R "$tmp/skills/cloud/bigquery-migration-metadata-extractor" ~/.cursor/skills/bigquery-migration-metadata-extractor &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/bigquery-migration-metadata-extractor` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/google/skills.git --path skills/cloud/bigquery-migration-metadata-extractor
```

Or copy the folder to `~/.gemini/skills/bigquery-migration-metadata-extractor` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/bigquery-migration-metadata-extractor`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/bigquery-migration-metadata-extractor &&
cp -R "$tmp/skills/cloud/bigquery-migration-metadata-extractor" ~/.copilot/skills/bigquery-migration-metadata-extractor &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/bigquery-migration-metadata-extractor` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/google/skills.git
```

Then copy `skills/skills/cloud/bigquery-migration-metadata-extractor` into your agent's skills folder as `bigquery-migration-metadata-extractor`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Bigquery migration metadata extractor in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/bigquery-migration-metadata-extractor to use it in all your projects, or to .claude/skills/bigquery-migration-metadata-extractor in one project.

### Does Bigquery migration metadata extractor run scripts?

Yes. It runs Python scripts. No network calls were found in its scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Bigquery migration metadata extractor?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Bigquery migration metadata extractor?

The closest alternatives to Bigquery migration metadata extractor are DOCX, XLSX, PDF, Reviewing oracle to postgres migration and Convert PDF to md.

## Alternatives

- [DOCX](https://ai-powered.com/skills/docx-anthropics): DOCX is an agent skill for files and documents.
- [XLSX](https://ai-powered.com/skills/xlsx): XLSX is an agent skill for files and documents.
- [PDF](https://ai-powered.com/skills/pdf-anthropics): PDF is an agent skill for files and documents.
- [Reviewing oracle to postgres migration](https://ai-powered.com/skills/reviewing-oracle-to-postgres-migration): Reviewing oracle to postgres migration is an open-source agent skill for databases.
- [Convert PDF to md](https://ai-powered.com/skills/convert-pdf-to-md): Convert PDF to md is an open-source agent skill for files and documents.
- [Ssma console](https://ai-powered.com/skills/ssma-console): Ssma console is an open-source agent skill for databases.
- [Md to DOCX](https://ai-powered.com/skills/md-to-docx): Md to DOCX is an open-source agent skill for files and documents.
- [Migrating oracle to postgres data access code](https://ai-powered.com/skills/migrating-oracle-to-postgres-data-access-code): Migrating oracle to postgres data access code is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/bigquery-migration-metadata-extractor
