What problem does it solve? Working with Google Cloud Spanner requires careful decisions around primary key design, schema evolution, and performance tuning, and mistakes like hotspotting keys can silently degrade production databases. This Skill guides provisioning, schema design, querying, and troubleshooting so those decisions follow Spanner best practices. ## Core Features & Use Cases - Schema Design Guidance: Prevents hotspots by recommending UUID v4 keys, bit-reversed sequences, key hashing, and interleaved tables for parent-child data. - Provisioning & Administration: Covers instance and database creation via gcloud CLI, Terraform, client libraries (Python, Java, Go, Node.js), and the Spanner MCP server. - Performance Diagnosis: Uses SPANNER_SYS tables such as QUERY_STATS_TOP_HOUR to identify slow or CPU-intensive queries. - Use Case: When designing a new orders table, the Skill warns against a monotonically increasing timestamp as the leading primary key and instead proposes a UUID or composite key, then generates the DDL for review before execution. ## Quick Start Ask the assistant to design a Spanner schema for your tables and generate the DDL commands to create the database. ## Safety Note All non-emulator DDL, DML, and destructive operations require explicit user confirmation before execution.
