# bigquery-features

> Use when asking about BigQuery-specific features, syntax, or capabilities including: STRUCT/ARRAY/UNNEST patterns, MERG…

Use when asking about BigQuery-specific features, syntax, or capabilities including: STRUCT/ARRAY/UNNEST patterns, MERGE statements, BigQuery scripting (DECLARE, IF, LOOP, BEGIN/END), scheduled queries, remote functions, JSON functions, approximate aggregation (APPROX_COUNT_DISTINCT, HLL_COUNT), geography/GIS functions, BigQuery ML (CREATE MODEL), search indexes, vector search, or BI Engine. Triggers on: "UNNEST", "STRUCT", "ARRAY", "MERGE", "DECLARE", "scripting", "scheduled query", "remote function", "JSON_EXTRACT", "APPROX_COUNT", "HLL", "ST_", "CREATE MODEL", "BQML", "search index", "vector search", "BI Engine".

- Type: Skill
- Made by: justvinhhere
- Category: Databases
- Formats: Skills
- Version: ed74590
- Source: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features
- Page: https://pluginboard.ai/skills/bigquery-features-justvinhhere

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the bigquery-features folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Claude

In Claude (web or desktop): Download the bigquery-features folder and zip the folder itself, then upload it in Customize → Skills.

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Gemini

In Gemini: Download the bigquery-features folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### GitHub Copilot

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.copilot/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Cursor

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.cursor/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Claude Code

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.claude/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

Or all of BigQuery Expert, in Claude Code:

```text
/plugin marketplace add justvinhhere/bigquery-expert
/plugin install bigquery-expert@justvinhhere-bigquery-expert
```

### Codex

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.agents/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Antigravity

In Antigravity: Copy the bigquery-features folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Gemini CLI

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.gemini/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Replit

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features .agents/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### OpenClaw

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.openclaw/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### OpenCode

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.config/opencode/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

### Hermes Agent

Run in your terminal:

```shell
npx -y degit justvinhhere/bigquery-expert/skills/bigquery-features ~/.hermes/skills/bigquery-features
```

View the folder on GitHub: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-features

---
From Pluginboard (https://pluginboard.ai).