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 BigtableDesign a primary key for a high-write Spanner table
- Kind
- SkillSkill
- Pricing
- Open sourceOpen source
- Platforms
- Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, GooseClaude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- GitHub stars
- 24.4K24.4K
- Last commit
- Nov 2026Nov 2026
- License
- Apache-2.0Apache-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 cbtDesign 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.
