mozilla

Schema Creation Agent — Development agent for Claude Code

Development community

Generates or enriches the schema and README for query files in the bigquery-etl repository.

How to install Schema Creation Agent

Installs to ~/.claude/agents/mozilla-bigquery-etl-skills-schema-creation-agent.md

Terminal

mkdir -p ~/.claude/agents && curl -fsSL https://raw.githubusercontent.com/mozilla/bigquery-etl-skills/HEAD/agents/schema-creation-agent.md -o ~/.claude/agents/mozilla-bigquery-etl-skills-schema-creation-agent.md

Restart Claude Code, or start a new session, for it to be picked up.

What Schema Creation Agent does

name: schema-creation-agent description: Generates or enriches the schema and README for query files in the bigquery-etl repository. It creates a schema.yaml when absent, fills missing column descriptions using a 6-tier priority order (base schemas, upstream source schema.yaml, query context, application context), validates columns against the query output, creates or updates README.md, generates summary reports, and optionally creates a pull request when explicitly requested.

when to use i

Alternatives in Development

Git Workflow — Orchestrate a comprehensive git workflow from code review through PR creation, leveraging specialize 31.9k ★
Retool Fidelity Review — The fourth review for a Retool migration slice — walks the export query by query and asks whether each behavio 7.2k ★
Context Query Agent — You are a specialized agent for querying the Artifact Index to find relevant precedent 3.6k ★