Agent skills for Windsurf (legacy)

Generate type-safe TypeScript, Java, or Python code from annotated SQL files using SQG (SQL Query Generator).

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

Use when reviewing or creating SQL for analysis, metric definitions, joins, filters, aggregation, and validation queries.

Craft and optimize SQL for any warehouse dialect — Snowflake, BigQuery, Databricks, Redshift, PostgreSQL.

Execute comprehensive SQL injection vulnerability assessments on web applications to identify database security flaws, demonstrate…

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

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

Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.

Analyze SQL files for performance issues like full table scans, ineffective joins, and inefficient queries.

Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).

Explains, optimises, writes, and documents SQL queries.

SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention.

Guide for researching SQL syntax and behavior for database backends.

Database Architect skill. Use this when you need to modify the database schema, add tables, or seed data. This project uses RAW SQL…

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

This skill should be used when the user asks to "analyze data with SQLite", "query logs", "find patterns in test results", or "correlate…

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.

SQLiteData queries, @Table models, Point-Free SQLite, RETURNING clause, FTS5 full-text search, CloudKit sync, CTEs, JSON aggregation…