Claude Skills · Data & Analytics
SQL Optimizer
imtiazrayhan/agentscamp-libraryDiagnose a slow SQL query from its execution plan and propose a verified optimization — finding the real bottleneck (sequential scan, missing or unused index, bad join order, app-side N+1) and measuring the fix before and after. Use when a query is slow and you need a fix backed by EXPLAIN ANALYZE, not a guess.
At a glance
This skill is for Data & Analytics and helps you diagnose slow sql queries, optimize query execution plans, and identify missing or unused indexes.
git clone --depth 1 https://github.com/imtiazrayhan/agentscamp-library
cp -r agentscamp-library/skills/sql-optimizer ~/.claude/skills/sql-optimizer
Setup, runtime and requirements describe imtiazrayhan/agentscamp-library, the repo this skill ships in.
sqlperformanceExplain AnalyzeindexingQuery Optimizationpostgresql
Also in imtiazrayhan/agentscamp-library
View the repoAudit a UI change for accessibility regressions by combining automated checks with keyboard, focus, semantic, name-role-value, contrast, zoo...
Write an Architecture Decision Record capturing a decision the user describes, in Michael Nygard ADR format (Status, Context, Decision, Cons...
Design a project's CLAUDE.md and memory hierarchy by exploring the repo to learn its real build/test/lint commands, architecture, and non-ob...
Evaluate a multi-step AI agent's whole run — tool calls, intermediate steps, and final result — not just final-answer correctness, so you ca...
Cut alert noise and make every page mean something — rewrite alerting rules to fire on user-felt symptoms (error rate, latency SLO burn, fai...
Plan the retirement of an API endpoint, field, event, tool, or version without surprising active consumers. Use when replacing an interface,...
Design or normalize an API's error contract so clients get stable machine-readable codes, safe human messages, field-level validation detail...
Generate accurate architecture diagrams as Mermaid — straight from the codebase, not from imagination — by first choosing which view answers...
Read-only review of authentication AND authorization flows — session/token model, cookie flags, CSRF, token rotation, password-reset/email-v...
Audit scheduled jobs, queue consumers, workers, and asynchronous workflows for delivery assumptions, idempotency, retries, poison messages,...
Rebase the current branch onto its base and walk every conflict methodically, resolving each by understanding both sides. Use when your feat...
Analyze a JS/TS production bundle and surface the biggest size wins — heavy dependencies, duplicate packages, missing code-splitting, oversi...
Other Data & Analytics skills
An engineering runbook — service overview, alerts table, dashboards links, common procedures with copy-pasteable commands, on-call rotation,...
Professional trading analysis dashboard template (single-file HTML) with light/dark theme switch, dense market panels, chart interactions, d...
A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-ma...
Teaches the agent to produce D3 charts and interactive data visualizations. A comprehensive D3.js skill with examples across chart types and...
Notion-style team dashboard rendered as a Live Artifact. A single-page, self-contained HTML dashboard with KPIs, a 7-day sparkline, a real-t...
Admin / analytics dashboard in a single HTML file. Fixed left sidebar, top bar with user/search, main grid of KPI cards and one or two chart...