/database--query-optimize

/database--query-optimize is a Claude Code skill in the Data section. Analyzes a slow SQL or ORM query, spots missing indexes and N+1 problems, and suggests index and rewrite fixes.

Author's description

Analyze and optimize slow SQL queries or ORM queries

How to ask for it

/database--query-optimize this SQL query takes 10 seconds, why?
/database--query-optimize optimize this slow Prisma query
/database--query-optimize review indexes for this reporting query

Install

curl -fsSL https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.sh | bash

After installing with the script, type /database--query-optimize. Using Cursor, Windsurf or Codex? Platform guides

Demo coming soon

/database--schemaDatabase schema design
Designs or reviews a database schema covering normalization, keys, constraints and indexes, and delivers SQL plus an ER diagram.
Built here
/database--seedSeed data for development
Generates realistic seed data for your database, with valid relationships and edge cases, in your ORM's format and safe to re-run.
Built here
/web-readerWeb reading with z-ai
Shows how to use z-ai-web-dev-sdk to read a URL and get its title, main HTML and publication time, from backend code or the CLI.
By Hainrixz
/data--analytics-sqlAnalytics SQL from a question
Turns a plain-language business question into a runnable analytical SQL query built on your project's real schema, with an explanation.
Built here
/data--cohort-analysisCohort retention analysis
Builds runnable cohort retention SQL on your real schema, plus a guide to reading the retention triangle and spotting misleading patterns.
Built here
/data--csv-wranglerCSV and Excel cleanup
Cleans, dedupes and reshapes a CSV or Excel file with a reusable Python script, saving a clean copy and leaving the original untouched.
Built here

How to ask for it

Install

More from this section