Agent skill

Bigquery Patent Search

by RobThePCGuy in RobThePCGuy/Claude-Patent-Creator

Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval

MITAuto-check: notesLegal & Compliance

Install Bigquery Patent Search

skills CLI
$ npx skills add RobThePCGuy/Claude-Patent-Creator --skill bigquery-patent-search -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install RobThePCGuy/Claude-Patent-Creator bigquery-patent-search --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/RobThePCGuy/Claude-Patent-Creator.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/bigquery-patent-search .claude/skills/bigquery-patent-search && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
bigquery-patent-search
GitHub stars
196
Token cost
~1.4k tokens
SKILL.md length
423 words
Files
1
Skills in repo
17
Repo updated
First seen
Licence
MIT

At a glance

Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval

  • Works in 3 steps: Keyword Search across 100M+ patents → CPC Classification Search → Patent Details Retrieval
  • Tasks that involve Intellectual property
  • SKILL.md covers When to Use, What This Skill Does, Required Setup and How to Use, plus 8 more sections
  • Calls gcloud and python; reaches cloud.google.com

What it does

Bigquery Patent Search is an agent skill from RobThePCGuy/Claude-Patent-Creator. Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval

Its SKILL.md is about 1.4k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Legal & Compliance, covering Intellectual property and Data warehousing. It works with Google BigQuery and Google Cloud. The repository describes itself as: USPTO patent creation system with MCP server + Claude Code plugin. Hybrid RAG search over MPEP/USC/CFR, BigQuery access to 76M+ patents, automated 35 USC 112 compliance checks… The licence is MIT.

When your agent uses it

  • Tasks that involve Intellectual property
  • Tasks that involve Data warehousing

Example prompts

  • “/bigquery-patent-search”

Requirements

  • Python 3

Workflow steps

3 steps, taken from the first numbered list in SKILL.md.

  1. Keyword Search across 100M+ patents
  2. CPC Classification Search
  3. Patent Details Retrieval

What it can do on your machine

Read from SKILL.md and the folder at commit a089731. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • gcloud
    • python

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • cloud.google.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Bigquery Patent Search loads about 1.4k tokens when it runs. Until then it costs about 45 tokens; SKILL.md has 423 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~45
When it runs · the whole SKILL.md, loaded when a task matches
~1.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

  • NoteMentions a .env fileSKILL.md:65
    Set in `.env` file: `GOOGLE_CLOUD_PROJECT=your-project-id`

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from RobThePCGuy/Claude-Patent-Creator at commit a089731, republished under its MIT licence (© RobThePCGuy). 423 words, ~1,423 tokens.

Download SKILL.mdSave it as .claude/skills/bigquery-patent-search/SKILL.md (or your agent's skills folder).
name
bigquery-patent-search
description
Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval
tools
Bash, Read, Write
model
sonnet

BigQuery Patent Search Skill

Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery.

When to Use

Invoke this skill when users ask to:

  • Search for prior art patents
  • Find patents in a specific technology area
  • Search by CPC classification code
  • Look up patent details by publication number
  • Conduct freedom-to-operate searches
  • Research patent landscapes

What This Skill Does

Provides access to Google's public patent dataset:

  1. Keyword Search across 100M+ patents:

    • Full-text search of titles, abstracts, claims
    • Filter by country (US, EP, JP, CN, etc.)
    • Filter by filing/grant date ranges
    • Fast cloud-based queries (< 5 seconds)
  2. CPC Classification Search:

    • Search by CPC code (e.g., "G06F16/", "H04L29/06")
    • Browse patent classifications
    • Find patents in specific technical domains
  3. Patent Details Retrieval:

    • Get full patent text by publication number
    • Access title, abstract, claims, description
    • View CPC codes, inventors, assignees
    • See filing and grant dates

Required Setup

This skill requires Google Cloud authentication:

Prerequisites:

  1. Google Cloud Project (free to create)
  2. BigQuery API enabled (free for reasonable usage)
  3. Application Default Credentials configured

Setup Commands:

bash
# Install Google Cloud SDK (if not installed)
# Visit: https://cloud.google.com/sdk/docs/install

# Authenticate
gcloud auth application-default login

# Set project (get ID from console.cloud.google.com)
export GOOGLE_CLOUD_PROJECT=your-project-id

Environment Variable: Set in .env file: GOOGLE_CLOUD_PROJECT=your-project-id

How to Use

When this skill is invoked:

  1. Initialize BigQuery searcher:

    python
    import os
    import sys
    sys.path.insert(0, os.environ.get('CLAUDE_PLUGIN_ROOT', '.'))
    from mcp_server.bigquery_search import BigQueryPatentSearch
    
    searcher = BigQueryPatentSearch()
  2. Search by keywords:

    python
    results = searcher.search_by_keywords(
        query="blockchain authentication",
        limit=20,
        country="US",  # Optional: filter by country
        start_year=2020,  # Optional: filter by year
        end_year=2024
    )
  3. Search by CPC code:

    python
    results = searcher.search_by_cpc(
        cpc_code="G06F16/",  # CPC prefix
        limit=20,
        country="US"
    )
  4. Get patent details:

    python
    patent = searcher.get_patent_details(
        patent_number="US10123456B2"  # Publication number
    )

BigQuery Dataset

Uses patents-public-data.patents on Google BigQuery:

  • 100M+ worldwide patents
  • 12M+ US patents with full text
  • Updated weekly
  • Free to query (no billing for reasonable usage)
Show full SKILL.md (191 more words)Show less

Search Result Format

Each result includes:

python
{
    "publication_number": "US10123456B2",
    "title": "Method and system for...",
    "abstract": "A system for...",
    "filing_date": "2019-01-15",
    "grant_date": "2020-06-30",
    "country": "US",
    "cpc_codes": ["G06F16/245", "H04L29/06"],
    "inventors": ["John Doe", "Jane Smith"],
    "assignee": "Example Corp"
}

Full patent details also include:

  • claims: Full text of all claims
  • description: Complete description section
  • priority_date: Earliest priority date
  • family_id: Patent family ID

Presentation Format

Present search results as:

PATENT SEARCH RESULTS
====================

Query: "blockchain authentication"
Found: 247 patents (showing top 20)
Date Range: 2020-2024
Country: US

[1] US10123456B2 - System for blockchain-based authentication
    Assignee: Example Corp
    Filed: 2019-01-15 | Granted: 2020-06-30
    CPC: G06F16/245, H04L29/06

    Abstract: A system for authenticating users using blockchain
    technology with distributed ledger verification...

[2] US10234567B1 - Method of secure authentication using blockchain
    ...

---

Top 5 Most Relevant:
1. US10123456B2 (95% relevance)
2. US10234567B1 (92% relevance)
...

Advanced Search Techniques

  1. Boolean Operators in queries:

    • "blockchain AND authentication"
    • "encryption OR cryptography"
    • "(mobile OR wireless) AND security"
  2. Phrase Search:

    • "distributed ledger technology"
    • "public key infrastructure"
  3. CPC Code Hierarchies:

    • "G06F" = Computing
    • "G06F16/" = Information retrieval
    • "G06F16/245" = Structured query language

Common CPC Codes

  • G06F: Computing, calculating, counting
  • H04L: Digital communication
  • G06Q: Business methods
  • H04W: Wireless communication
  • G06N: Computer systems based on specific models
  • G06T: Image processing

Error Handling

If BigQuery is not configured:

  1. Check if google-cloud-bigquery is installed
  2. Verify authentication: gcloud auth application-default login
  3. Confirm project ID in environment: GOOGLE_CLOUD_PROJECT
  4. Test with: python scripts/test_bigquery.py

Cost Considerations

BigQuery pricing:

  • First 1 TiB/month: FREE
  • After 1 TiB: $6.25 per TiB queried (on-demand)
  • Typical query: 10-50 MB per search
  • Bytes-billed ceiling: enforced per-query via PATENT_BIGQUERY_MAX_BYTES_BILLED (default 350 GiB)

Tools Available

  • Bash: To run Python BigQuery searches
  • Read: To load saved search results
  • Write: To save patent search results
  • Grep: To search through saved results

© RobThePCGuy, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/bigquery-patent-search of RobThePCGuy/Claude-Patent-Creator.

Open the folder on GitHubat commit a089731

Compare with similar skills

Bigquery Patent Search next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Bigquery Patent Search compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Bigquery Patent Search this skillRobThePCGuy/Claude-Patent-Creator196—~1.4kAutomated safety check: NotesMIT
Uspto Databasejaechang-hits/SciAgent-Skills3711 repos~4.6kAutomated safety check: PassCC0-1.0
BigQuery Slot and Cost Optimizergoogle/skills21k—~2.3kAutomated safety check: PassApache-2.0
dbt Snowflake to BigQuery Translatorgoogle/skills21k—~2.7kAutomated safety check: PassApache-2.0
GCP Audit Logssickn33/agentic-awesome-skills47k2 repos~3.8kAutomated safety check: PassMIT
Imaging Data CommonsK-Dense-AI/scientific-agent-skills48k1 repos~7.8kAutomated safety check: PassMIT

Similar skills

  • Uspto Database

    jaechang-hits/SciAgent-Skills

    Access USPTO patent data via PatentsView REST API and Google Patents Public Data (BigQuery).

    371 GitHub starsUsed in 1 repo~4.6k tokens
    Legal & ComplianceAuto-check passed
  • Official

    Analyzes BigQuery slot use, query costs and execution bottlenecks from INFORMATION_SCHEMA to diagnose slow queries, slot contention and unpartitioned scans.

    21k GitHub stars~2.3k tokensUpdated today
    DatabasesAuto-check passed
  • Translates Snowflake dbt SQL models into standardized BigQuery SQL, keeping Jinja constructs and tracking progress in a migration tasks file.

    21k GitHub stars~2.7k tokensUpdated today
    DatabasesAuto-check passed
  • GCP Audit Logs

    sickn33/agentic-awesome-skills

    Configure GCP Cloud Audit Logs for compliance. An agent skill from sickn33/agentic-awesome-skills.

    47k GitHub starsUsed in 2 repos~3.8k tokens
    DatabasesAuto-check passed
  • Imaging Data Commons

    K-Dense-AI/scientific-agent-skills

    Queries and downloads public cancer imaging data from NCI Imaging Data Commons.

    48k GitHub starsUsed in 1 repo~7.8k tokens
    DatabasesAuto-check passed
  • GCP Cloud Architect

    alirezarezvani/claude-skills

    Design GCP architectures for startups and enterprises. An agent skill from alirezarezvani/claude-skills.

    28k GitHub stars~3.2k tokensUpdated 1 mo ago
    DevOps & CloudAuto-check passed

More from RobThePCGuy/Claude-Patent-Creator

All 17 skills in this repo
  • Development Assistant

    RobThePCGuy/Claude-Patent-Creator

    Guides through adding new features, MCP tools, analyzers, and extending the patent creator system.

    196 GitHub stars~1.3k tokensUpdated 3 days ago
    Auto-check: notes
  • Epc Search

    RobThePCGuy/Claude-Patent-Creator

    RAG search across EPC provisions, EPO Guidelines for Examination, and PCT rules for European and international patent law research

    196 GitHub stars~2.2k tokensUpdated 3 days ago
    Auto-check passed
  • Epo Patent Analyzer

    RobThePCGuy/Claude-Patent-Creator

    Automated analysis of patent applications for EPO compliance with Art.

    196 GitHub stars~2k tokensUpdated 3 days ago
    Auto-check passed
  • Epo Patent Search

    RobThePCGuy/Claude-Patent-Creator

    Search European patents using EPO OPS API (full-text, legal status, families) and BigQuery (100M+ patents, EP filter) for prior art, competitive intelligence, and freedom-to-operate analysis

    196 GitHub stars~1.9k tokensUpdated 3 days ago
    Auto-check passed
  • Index Manager

    RobThePCGuy/Claude-Patent-Creator

    Manages MPEP index lifecycle including downloads, building, maintenance, and optimization.

    196 GitHub stars~994 tokensUpdated 3 days ago
    Auto-check passed
  • Mpep Search

    RobThePCGuy/Claude-Patent-Creator

    Expert system for searching USPTO MPEP, 35 USC statutes, 37 CFR regulations, and post-Jan 2024 updates.

    196 GitHub stars~978 tokensUpdated 3 days ago
    Auto-check passed

Questions about Bigquery Patent Search

What does Bigquery Patent Search do?

Fast, cloud-based patent searching across 100 million+ worldwide patents using Google BigQuery - keyword search, CPC classification, patent details retrieval. Bigquery Patent Search is an agent skill from RobThePCGuy/Claude-Patent-Creator.

When should I use Bigquery Patent Search?

Bigquery Patent Search fits situations like: tasks that involve Intellectual property; tasks that involve Data warehousing.

How do I install Bigquery Patent Search in Claude Code?

Run `npx skills add RobThePCGuy/Claude-Patent-Creator --skill bigquery-patent-search -a claude-code`. Or copy the skill folder (skills/bigquery-patent-search in RobThePCGuy/Claude-Patent-Creator) into .claude/skills/bigquery-patent-search in your project. Claude Code loads it when a task matches its description.

How do I install Bigquery Patent Search in Codex?

Run `npx skills add RobThePCGuy/Claude-Patent-Creator --skill bigquery-patent-search -a codex`. Or copy the skill folder (skills/bigquery-patent-search in RobThePCGuy/Claude-Patent-Creator) into .agents/skills/bigquery-patent-search in your project. Codex loads it when a task matches its description.

Can I use Bigquery Patent Search in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add RobThePCGuy/Claude-Patent-Creator --skill bigquery-patent-search -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/bigquery-patent-search, .gemini/skills/bigquery-patent-search, .github/skills/bigquery-patent-search and .opencode/skills/bigquery-patent-search in your project.

What does Bigquery Patent Search need to run?

Going by SKILL.md and its folder, Bigquery Patent Search needs the command-line tools its instructions call (gcloud and python). Our summary lists: Python 3.

Does Bigquery Patent Search access the network?

SKILL.md names 1 domain. In commands or code: cloud.google.com; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.

Is Bigquery Patent Search safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does Bigquery Patent Search use?

Bigquery Patent Search is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Bigquery Patent Search use?

About 1.4k tokens (SKILL.md is roughly 5.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Bigquery Patent Search?

Skills that share tags, products or a category with Bigquery Patent Search: Uspto Database (jaechang-hits/SciAgent-Skills, 371 stars), BigQuery Slot and Cost Optimizer (google/skills, 21k stars), dbt Snowflake to BigQuery Translator (google/skills, 21k stars) and GCP Audit Logs (sickn33/agentic-awesome-skills, 47k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Bigquery Patent Search?

RobThePCGuy (a GitHub user) maintains it in RobThePCGuy/Claude-Patent-Creator, which has 196 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on October 6, 2026.

Source: RobThePCGuy/Claude-Patent-Creator on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.