Claude Skills · Data & Analytics
SQL Pro
Jeffallan/claude-skillsOptimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a schema. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis, covering index creation, recursive queries, EXPLAIN/ANALYZE interpretation, before/after query benchmarking, or migrating queries between database dialects (PostgreSQL, MySQL, SQL Server, Oracle).
At a glance
This skill is for Data & Analytics and helps you optimize slow sql queries, design database schemas, and troubleshoot performance issues.
/plugin marketplace add Jeffallan/claude-skills
/plugin install sql-pro
Setup, runtime and requirements describe Jeffallan/claude-skills, the repo this skill ships in.
sqlQuery Optimizationdatabase-performancepostgresqlMysqlindexing
Also in Jeffallan/claude-skills
View the repoGenerates Angular 17+ standalone components, configures advanced routing with lazy loading and guards, implements NgRx state management, app...
Use when designing REST or GraphQL APIs, creating OpenAPI specifications, or planning API architecture. Invoke for resource modeling, versio...
Use when designing new high-level system architecture, reviewing existing designs, or making architectural decisions. Invoke to create archi...
Integrates with Atlassian products to manage project tracking and documentation via MCP protocol. Use when querying Jira issues with JQL fil...
Designs chaos experiments, creates failure injection frameworks, and facilitates game day exercises for distributed systems — producing runb...
Use when building CLI tools, implementing argument parsing, or adding interactive prompts. Invoke for parsing flags and subcommands, display...
Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produces disaster recovery strategies...
Generates, formats, and validates technical documentation — including docstrings, OpenAPI/Swagger specs, JSDoc annotations, doc portals, and...
Analyzes code diffs and files to identify bugs, security vulnerabilities (SQL injection, XSS, insecure deserialization), code smells, N+1 qu...
Writes, optimizes, and debugs C++ applications using modern C++20/23 features, template metaprogramming, and high-performance systems techni...
Use when building C# applications with .NET 8+, ASP.NET Core APIs, or Blazor web apps. Builds REST APIs using minimal or controller-based ro...
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing exec...
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...