Terminal
Terminal/Skill
Helps provision Spanner instances and databases, design primary keys and schemas, write queries, and diagnose slow performance.
By Google
Works with
npx skills add google/skills --skill spanner-basicsThis skill provides core workflows and guidance for administering and developing with Google Cloud Spanner, a fully managed, mission-critical database service offering global transactional consistency and automatic, synchronous replication for high availability.
[!CAUTION] CRITICAL INSTRUCTION: You MUST obtain explicit user confirmation before making any non-emulator database changes (DML or DDL) or destructive operations (such as dropping tables, indexes, or any other Spanner resources). Do not execute them automatically; instead, output the command (e.g.,
gcloud spanner databases ddl update) and ask for explicit user approval. When database access is unavailable or authentication fails, do not block on trying to verify the existence of the instance, database, or table. Assume the provided resources exist and directly generate the DDL commands.
gcloud spanner databases ddl update to apply schema updates (such as CREATE, ALTER, or DROP tables and indexes).SPANNER_SYS tables to identify slow or resource-intensive queries.SPANNER_SYS.QUERY_STATS_TOP_HOUR to find queries with the highest CPU usage.gcloud spanner command-line operations for managing instances and databases.If you need product information that's not found in these references, use the
search_documents tool of the Developer Knowledge MCP server.