Guides use of the sq CLI to query SQL databases and tabular files with SLQ (sq's jq-like query language) or native SQL, manage sources…
Generate type-safe TypeScript, Java, or Python code from annotated SQL files using SQG (SQL Query Generator).
Use when reviewing or creating SQL for analysis, metric definitions, joins, filters, aggregation, and validation queries.
Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with…
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server.
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
Generate parameter bindings for SQL files by analyzing database schema and extracting SQL placeholders.
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis…
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…
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…