BigQuery plugins

Build production-ready data pipelines with Apache Airflow and dbt, manage scalable data warehouses, and implement vector search and RAG systems using embedding models and vector databases.

Perform business analysis workflows — KPI frameworks, predictive models, real-time dashboards, TAM/SAM/SOM calculations, and multi-year financial modeling for startups — using Python, SQL, and cloud data warehouses like Snowflake and BigQuery.

Build and manage end-to-end data analytics workflows: implement A/B testing with statistical rigor, design reliable analytics tracking, create interactive D3.js visualizations, architect scalable database schemas, and optimize SQL for cloud-native databases.

Automate finance and accounting workflows including journal entries, account reconciliations, financial statement generation, variance analysis, and SOX 404 compliance testing, with integrations to BigQuery, Slack, and Benchling for querying financial and scientific data.

Write and optimize SQL across data warehouses, profile datasets, and generate interactive dashboards or publication-quality charts from queries or files. Automates data analysis with natural language queries and connects to analytics platforms like Amplitude and Hex.

Scaffold, develop, evaluate, deploy, and monitor AI agents using Google ADK (Agent Development Kit). Manage the full agent lifecycle from project scaffolding to production deployment on GCP with CI/CD, infrastructure as code, and observability.

Run 80+ bioinformatics workflows locally — pharmacogenomics, GWAS, single-cell RNA-seq, ancestry, metagenomics, variant annotation, protein structure prediction, and clinical reporting — with deterministic Python execution, reproducibility bundles, and privacy-preserving local computation.

Accelerate website creation and optimization with 103 structured skills spanning research, brand strategy, design, content, SEO, analytics, performance, security, and deployment—each providing expert-level prompts for tasks like auditing accessibility, fixing Core Web Vitals, conducting competitive analysis, running experiments, and managing incident response.

Manage the full Airflow data engineering lifecycle: author, test, debug, and deploy DAGs; profile and query data warehouses; trace lineage; migrate between Airflow versions; and manage local and production deployments via the Astro CLI.

Run a full digital marketing agency from Claude Code — plan campaigns, execute paid/SEO/email/social, audit performance, manage brands, and generate client deliverables across 158 skills and 25 agents.

Manage AWS data lake and analytics workflows: create and manage S3 Tables (Iceberg), import data from databases and S3, query with Athena, manage Glue connections and catalogs, and store/query vector embeddings with S3 Vectors.

Guides data engineering projects through a structured Spec-Driven Development workflow with 58 specialized agents for pipeline design, schema modeling, SQL optimization, data quality, lakehouse architecture, and AI/ML infrastructure. Generates visual diagrams, HTML documentation, code reviews, and git-aware status reports.

Build and orchestrate GCP data pipelines using natural language — architect dbt, Dataform, Spark, BigQuery, and Cloud Composer workflows, profile and transform data with Dataplex, and query BigQuery, Spanner, AlloyDB, and Cloud SQL databases.

Build cost-safe geospatial SQL queries for BigQuery, Snowflake, Wherobots, and Postgres by discovering database schemas, enforcing mandatory dry-runs, and rendering results on an interactive map.

Draft, analyze, and file USPTO, EPO, and PCT patent applications from invention disclosures. Conduct prior art searches across 100M+ patents via BigQuery, assess patentability and compliance (35 USC, EPC, MPEP), generate patent-style technical diagrams, and prepare IDS documents—all within Claude Code.

Profile, analyze, and QA data workflows across multiple SQL dialects — craft optimized queries, apply statistical methods, profile unfamiliar datasets, and catch common analysis pitfalls with a reproducible quality checklist.

Query BigQuery datasets, retrieve table metadata, and generate analytical insights including time-series forecasting and contribution analysis using standard SQL and BigQuery AI/ML functions.

Generate forecasting datasets and fine-tune models using the Lightningrod Python SDK. Create seed data from BigQuery public datasets, local files, or web searches; build SFT and GRPO training data; track experiments; and run transform pipelines for forecasting model development.

Build high-quality computer vision datasets and models with FiftyOne: import/export datasets, run inference, evaluate predictions, find duplicates, visualize embeddings, and develop custom plugins — all from within Claude.

Orchestrate multi-platform marketing campaigns from Claude using the Hyper MCP — manage paid ads on Google, Meta, TikTok, Pinterest, Amazon, LinkedIn, plus organic social, SEO research, email outreach, competitor analysis, ad creative generation, and analytics integrations.

Query, model, and govern a Honeydew semantic layer from your code editor: define entities and metrics from Snowflake, Databricks, or BigQuery sources, build relationships and calculated attributes, validate models with execution tests, and manage workspace branches and pull requests.

Acquire, clean, compute, and visualize football data from multiple providers (StatsBomb, FBref, Wyscout, etc.) with built-in analytics skills, code review agents, and a searchable MCP documentation server.

Send Claude Code hook traces to BigQuery Agent Analytics for observability and monitoring of agent events across the full lifecycle.

Control SAP Datasphere via natural language to explore catalogs and schemas, design semantic models and views, build and optimize ETL flows and task chains, connect diverse data sources, migrate from BW/4HANA, govern metadata and security, activate business content, automate admin via CLI, and troubleshoot pipelines.

Generate optimized SQL queries from natural language for BigQuery, PostgreSQL, MySQL, and Snowflake; perform cohort analysis on CSV/Excel user data to compute retention rates, visualize trends, and detect anomalies; evaluate A/B tests with statistical significance, confidence intervals, and launch recommendations.

Delegate specialized development tasks to AI subagents that architect features with Mermaid diagrams and checklists, generate PRDs and specs, query SQL/BigQuery for data analysis, implement precise code from tasks.md, debug errors with root cause fixes, proactively review git diffs for quality/security, and analyze codebases for project guidance files.

Design AWS and GCP infrastructure using Terraform and Ansible patterns, build data pipelines with dbt and SQLMesh, generate and manage RFCs plus technical specs in Markdown, and automate local dev setups including direnv, git worktrees, and port allocations for Docker services.

Integrates Slack, Microsoft 365, Notion, BigQuery, and Benchling into a single MCP server to automate Dutch tax workflows — intake, return preparation, audits, and objection letters — with official source verification for individuals, freelancers, and corporations.

Analyze data, explore schemas, build insights, and run forecasts using AI agents on the Altertable platform, with support for DuckDB, Snowflake, BigQuery, and more.