sql-query-optimizer

Plugin sql-query-optimizer from marketplace expert-ai-developer-skills in jggomez/expert-ai-developer-skills. Commands read from the repo's manifest — 2 days ago.

Skills (4)

• bigquery-query-optimization

  Diagnoses and rewrites slow BigQuery SQL using the query plan (stages, shuffle, workers) — partitioning/clustering pruning, JOIN ordering and broadcast vs. shuffle joins, skewed JOINs, WHERE clause selectivity, and approximate/SQL-vs-JS function choices. Use when a BigQuery query is slow, expensive,

• context-capture

  Use when finishing a task at State 5 (Ship & Finish) or when the user explicitly asks to "save context", "guarda contexto", "record decisions", or "hand off" — writes ultra-compact persistent memory to context/memory/ and ensures target-project root AGENTS.md (<= 90 lines) stays wired to DESIGN.md a

• context-restore

  Use at session start (State 0) or when asked to "load context", "catch up", or "what was done before" — prioritizes LLM Wiki Progressive Disclosure (context/memory/MEMORY.md) across Claude Code and Google Antigravity while supporting user-confirmed restore for scripted sessions (context/sessions/).

• sql-query-optimization

  Diagnoses and rewrites slow SQL on traditional engines (Postgres, MySQL, SQL Server, etc.) using EXPLAIN/EXPLAIN ANALYZE — indexing strategy, WHERE clause selectivity, avoiding functions on indexed columns, JOIN vs. subquery vs. CTE tradeoffs, and pagination. Use for any query slowness outside BigQu

Subagents (1)

• sql-query-optimizer

  Specialized subagent for finding and optimizing slow SQL — scans directories

MCP servers (2)

• bigquery

  connects to: https://bigquery.googleapis.com/mcp

• cloudsql

  connects to: https://sqladmin.googleapis.com/mcp/query_execution