Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
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.).
SQL query optimization for PostgreSQL/MySQL with indexing, EXPLAIN analysis.
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…
SQL Server 2025 and SqlPackage 170.2.70 (October 2025) — vector databases, AI integration, and modern features.
Expert in Microsoft SQL Server development and administration.
SQLAlchemy 2.0 async patterns with AsyncSession, async_sessionmaker, and FastAPI integration.
Comprehensive SQLAlchemy skill for customer support tech enablement, covering ORM patterns, session management, query optimization, async…
SQLAlchemy ORM patterns for Python database access.
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.