# bigquery-schema-design

> Use when designing BigQuery table schemas, choosing partitioning or clustering strategies, deciding between nested/repe…

Use when designing BigQuery table schemas, choosing partitioning or clustering strategies, deciding between nested/repeated fields vs flat schemas, selecting table types (native, external, views, materialized views), choosing data types, or planning denormalization. Triggers on: "partition", "cluster", "STRUCT", "ARRAY", "nested fields", "table design", "schema", "materialized view", "external table", "denormalize", "data type", "TIMESTAMP vs DATETIME".

- Type: Skill
- Made by: justvinhhere
- Category: Databases
- Formats: Skills
- Version: ef568cc
- Source: https://github.com/justvinhhere/bigquery-expert/tree/HEAD/skills/bigquery-schema-design
- Page: https://pluginboard.ai/skills/bigquery-schema-design-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-schema-design 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-schema-design

### Claude

In Claude (web or desktop): Download the bigquery-schema-design 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-schema-design

### Gemini

In Gemini: Download the bigquery-schema-design 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-schema-design

### GitHub Copilot

Run in your terminal:

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

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

### Cursor

Run in your terminal:

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

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

### Claude Code

Run in your terminal:

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

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

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-schema-design ~/.agents/skills/bigquery-schema-design
```

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

### Antigravity

In Antigravity: Copy the bigquery-schema-design 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-schema-design

### Gemini CLI

Run in your terminal:

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

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

### Replit

Run in your terminal:

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

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

### OpenClaw

Run in your terminal:

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

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

### OpenCode

Run in your terminal:

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

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

### Hermes Agent

Run in your terminal:

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

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

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