Agent skills for Windsurf (legacy)

SpriteKit API reference — all node types, physics body creation, action catalog, texture atlases, constraints, scene setup, particles…

Use when the user wants to audit SpriteKit game code for common issues.

Reviews and merges Dependabot pull requests for Go modules (gomod) at the sq repo root.

SQL query writing and optimisation: complex joins, window functions, CTEs, indexes, query plans, migration patterns

Remediates SQL injection security findings safely using validated execution plans, allowlisted tools, and strict outcome verification.

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.

Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans.

Write SQL and design indexes that stay fast as data grows — composite index column ordering, keeping predicates sargable, avoiding…

Automatically fix SQL performance issues with step-by-step measurement.

Explains, optimises, writes, and documents SQL queries.

Analyzes SQL performance, interprets execution plans, and provides actionable optimization strategies for databases and ORMs.

Expert knowledge for SQL Server on Azure Virtual Machines development including troubleshooting, best practices, decision making…

Use when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift…

SQLAlchemy 2.0 patterns - model definition, engine setup, async patterns, relationships, query optimization, repository pattern, and…

SQLDelight patterns for Kotlin Multiplatform - .sq file definitions, platform drivers, type adapters, migrations, and shared database…

SQLite changes since training cutoff (latest: 3.51.0) — JSON enhancements, new SQL functions, FTS5 locale support, date modifiers, JSONB…

Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or…

SQLite performance optimization techniques

Guides the agent through migrating SQLite and SQL-style Capacitor plugins to @capgo/capacitor-fast-sql.

sqlite-vec extension for vector similarity search in SQLite.

Square integration. Manage Organizations, Users, Goals, Filters. Use when the user wants to interact with Square data.