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…
General guide for using the sqlite3 CLI to build composable knowledge databases.
Teaches SQLite development including WAL mode, FTS5 full-text search, JSON1 queries, and async Python integration with aiosqlite.
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
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…
SQLiteData advanced patterns, @Selection column groups, single-table inheritance, recursive CTEs, database views, custom aggregates…
Use when working with SQLMesh — writing or editing MODEL blocks, Python @model decorators, Python @macros, audits, unit tests…
Deep-dive into AWS messaging services including SQS, SNS, and EventBridge.
Squad lifecycle skill. Use when asked to create, validate, inspect, list, or migrate squads — portable AI agent teams with workflows…
Automate Square tasks via Rube MCP (Composio): payments, orders, invoices, locations.
Reorganize messy branch commits into a small set of logical, meaningful commits without changing any content.
Use when responding to production incidents following SRE principles and best practices.
Use when building comprehensive monitoring and observability systems.
Use when building reliable and scalable distributed systems.