spanner-specialist

Generate and optimize GoogleSQL queries for Google Cloud Spanner.

Updated Aug 23, 2026

One-click install

npx skills add https://github.com/jliocsar/subagents-framework --skill spanner-specialist

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: spanner-specialist
Source: https://github.com/jliocsar/subagents-framework/tree/main/forge/spanner
Command: npx skills add https://github.com/jliocsar/subagents-framework --skill spanner-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Working with Google Cloud Spanner's unique GoogleSQL dialect and advanced distributed database features can be challenging. This Skill provides expert assistance for writing, optimizing, and managing Spanner SQL, ensuring efficient and scalable database operations, so your data infrastructure runs smoothly.

Core Features & Use Cases

GoogleSQL Query Generation: Craft complex SQL queries tailored for Spanner, including CTEs, window functions, and JSON operations.
Schema Design & Optimization: Design efficient schemas with interleaved tables and recommend optimal indexing strategies for performance.
Use Case: Need to retrieve a list of active users with their recent order counts from a Spanner database? This Skill can generate the optimized GoogleSQL query, saving you time on complex joins and aggregations.

Quick Start

Write a GoogleSQL query for Spanner to select all users from the users table where status is 'active' and created_at is within the last 30 days.