skills.rest
ValorInvestigator
ValorInvestigatorCOMMUNITY
Explore all skills by this author →
GitHub

gcloud-bigquery

Query BigQuery, GitHub, and local case law for Valor evidence.

1|Updated Feb 23, 2026
Search Tags:#data analysis#legal research#case law#github search#bigquery#vertex ai#evidence search
One-click install
npx skills add https://github.com/ValorInvestigator/claude-plugin-toolkit --skill gcloud-bigquery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gcloud-bigquery
Source: https://github.com/ValorInvestigator/claude-plugin-toolkit/tree/main/skills/gcloud-bigquery
Command: npx skills add https://github.com/ValorInvestigator/claude-plugin-toolkit --skill gcloud-bigquery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-auth, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Levi needs to answer questions about investigation data, legal research, and case evidence without manually searching scattered sources or defaulting to unsupported local files.

Core Features & Use Cases

  • Evidence search: Run Vertex AI on 15,554 BigQuery documents for natural language summaries with citations, covering people, drugs, documents, and events.
  • SQL queries: Execute BigQuery SQL for precise counts, schema exploration, data updates, and field-level lookups across the valorinvestigates dataset.
  • GitHub & case law research: Search ValorInvestigator repos for memos and legal arguments plus a local Oregon case-law database with holdings, citations, and context.
  • Session health & auth: Start each session with the startup health-check script to confirm service-account authentication and table availability before issuing queries.

Quick Start

Ask the skill to search the Valor evidence for every mention of Russell's visitation records.

Frequently Asked Questions about gcloud-bigquery

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

FAQPage Schema
How do I query BigQuery for legal evidence and case law research?▼

You can search BigQuery evidence using natural language through Vertex AI, which generates summaries with citations across 15,554 documents. Alternatively, execute direct BigQuery SQL queries for precise counts and field-level lookups across the valorinvestigates dataset.

Can I search GitHub repositories for legal memos and case arguments?▼

Yes, you can search GitHub repositories for legal memos and case arguments. The Skill queries ValorInvestigator repos to retrieve relevant documents and legal research directly within the investigations workspace.

Do I need a service account to run BigQuery SQL queries for investigations?▼

Yes, a service account is required to run BigQuery SQL queries for investigations. The Skill requires service-account authentication to securely access the valorinvestigates dataset and execute evidence searches.

What is the best way to find specific mentions of people or drugs in investigation documents?▼

The best way to find specific mentions of people or drugs in investigation documents is to use Vertex AI evidence search. It provides natural language summaries with citations across 15,554 BigQuery documents in the valorinvestigates dataset.

How do I verify my BigQuery session health before running evidence searches?▼

You verify BigQuery session health by running the startup health-check script. This confirms service-account authentication and validates table availability in the valorinvestigates dataset before issuing queries.

Does this approach work with a local Oregon case-law database?▼

Yes, this approach works with a local Oregon case-law database. The Skill uses local scripts to search the database for holdings, citations, and context, integrating results with BigQuery and GitHub evidence searches.

Related Skills

Explore More Legal & Compliance Skills→
VincentChong123VincentChong123

add-gchat

Register the Google Chat SDK adapter into the NanoClaw agent framework.

Community
Intermediate
fabioc-alohafabioc-aloha
1

Legal Compliance Skill

Conduct legal research, analyze contracts, and verify regulatory compliance.

Community
Advanced
alexchloualexchlou
2

case-brief

Create structured legal case briefs by extracting language from case texts.

Community
Intermediate
ssmleossmleo

bigquery-ai-ml

Run AI and machine learning functions for BigQuery SQL queries.

Community
Advanced