AI Knowledge Hub
Menu

Adtech / Analytics Engineering

Analyst Co-pilot (BigQuery + Redshift)

Assist analysts with safe SQL drafting, metric validation, and stakeholder-ready summaries across BigQuery and Redshift.

DocumentationAgent instructionsRequirements & limits

Use when an analyst question needs safe SQL drafting, metric validation, and stakeholder-ready findings across BigQuery or Redshift.

Inputs

  • schema_context
  • business_question
  • date_range
  • dialect (bigquery|redshift)

Outputs

  • SQL draft
  • Metric logic notes
  • Stakeholder summary

Before you begin

  • Reading and copying the procedure require no terminal setup. Check requirements for any packaged programs separately.

Try this first

Read the procedure and supply its documented inputs. Use the full text in an agent app or chat that supports pasted instructions, following that host's guidance.

Limits for this step
  • Instruction package only; it does not provide or authorize an executable runtime capability.
  • Safe for read-only analysis and SQL drafting; require human approval before executing queries against production warehouses.
  • Packaged programs have independent setup and verification requirements. Reading or copying this procedure does not verify their execution.
Read full instructionsHide full instructionsSKILL.md · v0.1.0

Analyst Co-pilot on BigQuery/Redshift

When to use

Use for ad-hoc analysis requests, KPI deep-dives, anomaly investigation, and reporting support.

Inputs required

  • schema_context
  • business_question
  • date_range
  • dialect (bigquery|redshift)

Workflow

  1. Clarify the business question and target metric.
  2. Draft SQL with explicit assumptions.
  3. Validate metric logic and join safety.
  4. Summarize findings and caveats.

Output format

  • SQL draft
  • logic notes and assumptions
  • quality checks run
  • stakeholder summary

Guardrails

  • Avoid destructive SQL.
  • Require explicit confirmation before write operations.
  • Mark confidence limits when source coverage is partial.
View file metadata
---
name: analyst-copilot-bigquery-redshift
description: Assist analysts with BigQuery/Redshift exploration, query drafting, metric validation, and stakeholder-ready summaries.
---

Summary sources · Catalogue metadata, skill.yaml, SKILL.md · v0.1.0 · Release package

Install instruction files

These commands copy guidance into the selected runtime directories. Confirm that your agent app discovers it. Any packaged programs need separate setup and verification.

Install (Codex)

./bin/skills-hub install adtech/[email protected] --runtime codex

Install (Claude)

./bin/skills-hub install adtech/[email protected] --runtime claude

Install (Generic)

./bin/skills-hub install adtech/[email protected] --runtime generic --target ./my-agent/skills

How You Can Use This

Documentation

Resource form: Agent instructions

Read or copy the guidance. Any packaged programs have separate execution requirements and evidence.

First run: Read SKILL.md and follow the documented workflow.

Current limits

  • Instruction package only; it does not provide or authorize an executable runtime capability.

Packaged executable helpers

Each program has its own setup requirements and operational evidence. Reading or copying the instructions does not verify these programs.

scripts/query_safety_check.py · Not verified · Local program

First run: printf 'SELECT 1' | python3 scripts/query_safety_check.py

  • Packaged helper exists, but current clean-client executable evidence is not recorded.
What installation and verification mean
File installation
Places package files and generated configuration in the selected directories.
Native discovery
Your agent app finds and accepts the instructions, tools or plugin registrations.
Mock execution
Exercises sample fixtures. Connected data and provider effects need a separate check.
Connected operation
Requires current configuration, provider authentication, scoped permissions and a successful operation in your intended environment.

Declared compatibility

Compatibility unknown: versions and capabilities have not been declared.

Classification: declared

Technical details and release files

Operational Summary

Execution mode: read-only-local-inspection

Approval boundary: Safe for read-only analysis and SQL drafting; require human approval before executing queries against production warehouses.

Review and lifecycle

Review maturity: Experimental

Security review declaration: Not declared

Lifecycle: Active

These release declarations are separate from evidence that a workflow operates in your environment.

Runtime & Dependencies

ID: adtech/analyst-copilot-bigquery-redshift

Tags: sql, analytics, bigquery, redshift

Runtimes: codex, claude, generic

Tool dependencies: 1

API dependencies: 0

Dependencies

Tools: python3

APIs: Not documented

Outputs

  • SQL draft
  • Metric logic notes
  • Stakeholder summary