Claude Skills · Data & Analytics
Query Optimization
seb1n/awesome-ai-agent-skillsDiagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. Use when the user provides a query, performance symptom, or EXPLAIN plan; use sql-query-generation when creating a new query from requirements.
At a glance
This skill is for Data & Analytics.
git clone --depth 1 https://github.com/seb1n/awesome-ai-agent-skills
cp -r awesome-ai-agent-skills/database/query-optimization ~/.claude/skills/query-optimization
Setup, runtime and requirements describe seb1n/awesome-ai-agent-skills, the repo this skill ships in.
Also in seb1n/awesome-ai-agent-skills
View the repoAudit web interfaces against WCAG 2.1 AA/AAA standards, identify violations, and produce actionable remediation reports with code fixes. Use...
Design reproducible evaluations for AI agents with representative task sets, explicit rubrics, appropriate graders, baselines, regression ga...
Design privacy-aware observability for AI agents using traces, spans, structured events, metrics, cost attribution, dashboards, alerts, and...
Plan, execute, document, and retest authorized security assessments of AI agents and multi-agent workflows using safe adversarial cases, syn...
Generate comprehensive marketing analytics reports by collecting KPIs, analyzing trends, and delivering actionable insights with attribution...
Design RESTful APIs with proper resource modeling, HTTP method semantics, status codes, pagination, versioning, and documentation. Use when...
Integrate with external APIs using REST clients, webhook consumers, SDK wrappers, and polling patterns with proper authentication, error han...
Write high-quality, SEO-optimized blog posts in multiple formats including how-to guides, listicles, opinion pieces, and case studies, with...
Create and manage budgets with variance analysis and departmental allocation. Use when the user requests budget planning or provides relevan...
Design structured, engaging chatbot conversations with robust intent handling, slot filling, disambiguation, error recovery, and graceful fa...
Identify at-risk customer accounts by analyzing usage patterns, engagement signals, and support history to generate churn risk scores and in...
Set up a continuous integration and continuous delivery (CI/CD) pipeline for a software project, automating builds, tests, and deployments a...
Other Data & Analytics skills
Teaches the agent to produce D3 charts and interactive data visualizations. A comprehensive D3.js skill with examples across chart types and...
An engineering runbook — service overview, alerts table, dashboards links, common procedures with copy-pasteable commands, on-call rotation,...
A consumer-feeling dating / matchmaking dashboard — left rail navigation, ticker bar of community signals, headline KPIs, a 30-day mutual-ma...
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...
Professional trading analysis dashboard template (single-file HTML) with light/dark theme switch, dense market panels, chart interactions, d...
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...