bigquery-ai-ml

Run AI and machine learning functions for BigQuery SQL queries.

Updated Jul 4, 2026
One-click install
npx skills add https://github.com/ssmleo/govfolio --skill bigquery-ai-ml-ssmleo
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bigquery-ai-ml
Source: https://github.com/ssmleo/govfolio/tree/main/.agents/skills/bigquery-ai-ml
Command: npx skills add https://github.com/ssmleo/govfolio --skill bigquery-ai-ml-ssmleo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of integrating advanced analytics, including time-series forecasting, anomaly detection, and generative AI capabilities directly within BigQuery queries.

Core Features & Use Cases

  • Time-Series Forecasting: Perform advanced forecasting without custom training using built-in functions.
  • Anomaly Detection: Detect deviations in time series data with pre-trained models.
  • Generative AI: Generate text and content using Gemini models directly within SQL queries.
  • Use Case: Use this Skill to analyze financial data, predict sales trends, and create custom reports.

Quick Start

Run the query 'SELECT * FROM AI.FORECAST (...)'. Replace the query parameters with your specific data.

Frequently Asked Questions about bigquery-ai-ml

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run time-series forecasting directly in BigQuery?

Run time-series forecasting in BigQuery by executing SQL queries like 'SELECT * FROM AI.FORECAST(...)', using built-in functions to analyze data and predict trends without custom model training.

Can I use generative AI models within my BigQuery SQL queries?

Yes, you can use generative AI within BigQuery SQL queries by leveraging integrated Gemini models to generate text and content directly from your database environment.

How do I detect anomalies in time series data using BigQuery?

Detect anomalies in time series data using BigQuery by applying pre-trained models to identify deviations in your datasets directly through standard SQL query functions.

Do I need Vertex AI access to use BigQuery machine learning functions?

Yes, you need access to Vertex AI in addition to BigQuery to utilize the suite of AI and machine learning functions, including generative AI and forecasting capabilities.

What is the best way to predict sales trends using BigQuery without training a custom model?

The best way to predict sales trends without custom training is using BigQuery's built-in AI.FORECAST function, which leverages pre-trained models for advanced time-series forecasting.