Skip to content

Bigtable basics vs Spanner basics

Bigtable basics is an open-source agent skill for databases. Spanner basics is an open-source agent skill for databases.

  • Bigtable basics is best for design a row key scheme for time-series sensor data in bigtable.
  • Spanner basics is best for design a primary key for a high-write spanner table.
What it is
Bigtable basics is an open-source agent skill for databases.
Spanner basics is an open-source agent skill for databases.
Best for
Design a row key scheme for time-series sensor data in Bigtable
Design a primary key for a high-write Spanner table
Kind
Skill
Skill
Pricing
Open source
Open source
Platforms
Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
GitHub stars
24.4K
24.4K
Last commit
Nov 2026
Nov 2026
License
Apache-2.0
Apache-2.0
Open source
Good for
Design a row key scheme for time-series sensor data in Bigtable; Find out why a Bigtable table has hotspotting and slow reads; Create a Bigtable instance and table with gcloud and cbt
Design a primary key for a high-write Spanner table; Write a SQL query against a Spanner database; Find the slowest queries using Spanner system tables

What Bigtable basics does

  • Row key design

    Guidance on choosing row keys that spread load and support the access patterns the application needs.

  • Instance and table provisioning

    Steps for creating instances, clusters and tables with gcloud and cbt, with schema reference notes.

  • Bigtable SQL querying

    Patterns for read-only SQL on _key predicates, using bounded ranges to avoid expensive scans.

  • Hotspot diagnosis

    A diagnostic order that starts with Key Visualizer and continues with hot-tablet and stats tools.

  • Column family and GC policy checks

    Commands to inspect existing column families and garbage collection policies before changing them.

  • Client library patterns

    Reference notes for high-performance Bigtable code in Java, Go and Python.

What Spanner basics does

  • Instance and database provisioning

    Guidance for creating and managing Spanner instances and databases with gcloud and Terraform.

  • Primary key and schema design

    Rules for avoiding hotspots from sequential keys and modeling parent-child data with interleaved tables.

  • Schema evolution via DDL

    Steps for applying CREATE, ALTER and DROP changes to tables and indexes with user approval.

  • Query performance diagnosis

    Using SPANNER_SYS statistics tables to locate slow or resource-intensive queries.

  • Client library examples

    Reference material for using Spanner client libraries in Java, Go, Python and Node.js.

  • PostgreSQL dialect and MCP access

    Notes on the PostgreSQL interface and on using the Spanner remote MCP server.

Bigtable basics vs Spanner basics: questions

Is Bigtable basics or Spanner basics cheaper?

Both are open source. Compare current plans on each official site.

What is the difference between Bigtable basics and Spanner basics?

Bigtable basics is an open-source agent skill for databases. Spanner basics is an open-source agent skill for databases.

Keep comparing