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.
Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.
Write SQL and design indexes that stay fast as data grows — composite index column ordering, keeping predicates sargable, avoiding…
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…
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.
Squarespace integration. Manage Websites, Forms, Products, Orders, Customers, Campaigns. Use when the user wants to interact with…
Reorganize messy branch commits into a small set of logical, meaningful commits without changing any content.
Collapses the current feature branch into a single commit and fast-forwards it onto the base branch, rebasing onto the base first when…
Orchestrates professional security audits and bug bounty workflows using expert methodologies and extensive real-world vulnerability data.
Core Site Reliability Engineering reasoning framework for designing, reviewing, modifying, operating, automating, documenting, testing…
Applies an SRE observability mindset to systems, automation, deployments, recovery procedures, scripts, services, and AI-assisted…