bigquery-graph

Generates GQL queries and property graph DDL for BigQuery graph analytics.

1|Updated Mar 19, 2026
One-click install
npx skills add https://github.com/tottenjordan/me-skittles --skill bigquery-graph-tottenjordan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-graph
Source: https://github.com/tottenjordan/me-skittles/tree/main/gemini/bigquery-graph
Command: npx skills add https://github.com/tottenjordan/me-skittles --skill bigquery-graph-tottenjordan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Writing correct BigQuery graph queries and property graph schemas requires deep knowledge of GQL syntax, GRAPH_TABLE integration, GRAPH_EXPAND semantics, and schema design pitfalls like column collisions and unsupported topologies. This Skill encodes those rules so generated queries and DDL work correctly the first time. ## Core Features & Use Cases - GQL Query Generation: Produces BigQuery GoogleSQL GQL queries with correct pattern matching, path variables, quantifiers, and output formatting for visualization or tabular results. - Semantic Graph Querying: Guides use of the GRAPH_EXPAND TVF and the mandatory AGG() function for measure columns, avoiding common NOT_FOUND and measure errors. - Schema DDL Advisory: Helps design CREATE PROPERTY GRAPH statements with scoped properties, safe aliases, PK/FK constraints, and semantic measures while validating tree-topology limitations. - Use Case: Ask the agent to find the shortest transfer path between two accounts in a financial graph, and it generates a valid ANY SHORTEST GQL query with TO_JSON output and a LIMIT clause. ## Quick Start Ask the agent to write a GQL query that finds all accounts connected to a given person within three hops in your BigQuery property graph.

Frequently Asked Questions about bigquery-graph

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

FAQPage Schema
How do I write GQL queries in BigQuery?▼

BigQuery GQL queries use MATCH for graph pattern matching, FILTER for conditions, and RETURN for projection, executed against a property graph. Use standalone GQL for pure graph traversal and GRAPH_TABLE when you need SQL aggregation or joins with relational tables.

How do I create a property graph in BigQuery?▼

Use CREATE PROPERTY GRAPH DDL with NODE TABLES and EDGE TABLES clauses mapping existing BigQuery tables. Define KEY columns, SOURCE KEY and DESTINATION KEY references for edges, and scope exposed columns with PROPERTIES (col1, col2) for better performance.

Can I use Cypher instead of GQL in BigQuery?▼

No, BigQuery only supports the GoogleSQL GQL standard, which implements the ISO GQL specification. Cypher queries are not supported and must never be generated; all graph queries must use BigQuery GQL syntax.

Why does my GRAPH_EXPAND query fail with a measure column error?▼

Measure columns cannot be selected directly and must be wrapped in the AGG() function, such as AGG(Order_total_amount). SELECT * also fails on graphs with measures, so explicitly list dimension columns or use EXCEPT to exclude measures.

What graph topologies does GRAPH_EXPAND support?▼

GRAPH_EXPAND requires the graph to form a valid tree structure. Disconnected graphs, directed cycles, self-loops, and convergent diamond paths are unsupported; use separate GRAPH_EXPAND calls or standard GQL pattern matching as workarounds.