spanner-basics
Assists in provisioning instances and databases, designing performant schemas
by googleFree
Description
Spanner basics is an agent skill for provisioning instances and databases, designing schemas and querying data in Cloud Spanner, Google's fully managed database service with global transactional consistency and synchronous replication for high availability. Its core principle is performance through key design. Because Spanner scales horizontally, the skill always warns against putting monotonically increasing or decreasing values, such as sequential timestamps, at the start of a primary key, since that creates hotspots. Its schema guidance prefers interleaved tables for strongly related parent and child data that is read together. The safety rule is strict: before making any change to a non-emulator database, whether a data change or a schema change, or any destructive operation such as dropping a table or index, the agent must get your explicit confirmation. It outputs the command, such as the gcloud DDL update, and waits for your approval rather than running it. The skill is aimed at developers and database administrators working with Spanner. It is published by Google on skills.sh under the google skills repository, with about 4.2K installs. The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.…
Highlights
- Primary key design to avoid hotspots
- Interleaved tables for parent-child data
- Provisioning instances and databases
- Confirmation before any non-emulator change
- Outputs gcloud DDL commands for approval
Ratings & Reviews
No ratings yet
Be the first to rate spanner-basics.
People also visit
code-quality
General Correctness rules, Rust patterns, comments, avoiding over-engineering
spanner-basics FAQ
What does the skill help with?
Provisioning Spanner instances and databases, designing schemas, and querying data.
What key design does it warn against?
Monotonically increasing or decreasing values, such as sequential timestamps, as the first part of a primary key.
Will it run schema changes for me?
No. It needs your explicit confirmation first, and it outputs the command for approval.
How do I install it?
Run npx skills add https://github.com/google/skills --skill spanner-basics.
What are the best spanner-basics alternatives?
Popular alternatives to spanner-basics include database-design, async-io-model and code-quality. See all spanner-basics alternatives