Agent Skill
SQL Pro skill
sql-proJeffallan/claude-skillsskills/sql-pro/SKILL.md
Optimizes 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).
always on
115 tokname + description
once used
1,010 tokSKILL.md body
bundled files
550 KB
repo stars
12kGitHub
Install the SQL Pro skill
Skills CLI (Claude Code, Codex, Cursor and others)
npx skills add https://github.com/Jeffallan/claude-skills --skill sql-pro
Claude Code, by hand (all projects)
git clone --depth 1 https://github.com/Jeffallan/claude-skills.git /tmp/claude-skills mkdir -p ~/.claude/skills cp -R /tmp/claude-skills/skills/sql-pro ~/.claude/skills/sql-pro
For one project only, copy the folder into .claude/skills/ in that project instead. The agent picks it up when a task matches its description.
What it costs your context
Agent Skills load in three steps. Tokens counted with the o200k tokenizer; your model's count will differ a little.
| When | What loads | Cost |
|---|---|---|
| Every session | Name and description | 115 tok |
| When the agent uses it | The SKILL.md instructions | 1,010 tok |
| Only if opened | 5 bundled files (50 KB) | varies |
Until it is used, sql-pro costs about 12× less than the median MCP server we measured (1,362 tokens on every turn). Installing all 67 skills from Jeffallan/claude-skills would load 5,798 tokens of descriptions. Skills vs MCP study
Checks
Our checks found nothing to flag: it follows the Agent Skills specification's naming and size guidelines and doesn't pipe downloads into a shell.
Checked 2026-10-22 · method
What's inside
The headings of its SKILL.md. Read the full file on GitHub.
- SQL Pro
- Core Workflow
- Reference Guide
- Quick-Reference Examples
- CTE Pattern
- Window Function Pattern
- EXPLAIN ANALYZE Interpretation
- Before / After Optimization Example
- Constraints
- MUST DO
- MUST NOT DO
- Output Templates
More skills from Jeffallan/claude-skills
- angular-architectJeffallan/claude-skills
Generates Angular 17+ standalone components, configures advanced routing with lazy loading and guards, implements NgRx state management, applies RxJS patterns, and optimizes bundle performance. Use when building Angular 17+ applications with standalone components or signals, setting up NgRx stores, establishing RxJS reactive patterns, performance tuning, or writing Angular tests for enterprise apps.
12k76 tok idle · 1,197 in use - api-designerJeffallan/claude-skills
Use when designing REST or GraphQL APIs, creating OpenAPI specifications, or planning API architecture. Invoke for resource modeling, versioning strategies, pagination patterns, error handling standards.
12k39 tok idle · 1,730 in use - architecture-designerJeffallan/claude-skills
Use when designing new high-level system architecture, reviewing existing designs, or making architectural decisions. Invoke to create architecture diagrams, write Architecture Decision Records (ADRs), evaluate technology trade-offs, design component interactions, and plan for scalability. Use for system design, architecture review, microservices structuring, ADR authoring, scalability planning, and infrastructure pattern selection — distinct from code-level design patterns or database-only design tasks.
12k87 tok idle · 778 in use - atlassian-mcpJeffallan/claude-skills
Integrates with Atlassian products to manage project tracking and documentation via MCP protocol. Use when querying Jira issues with JQL filters, creating and updating tickets with custom fields, searching or editing Confluence pages with CQL, managing sprints and backlogs, setting up MCP server authentication, syncing documentation, or debugging Atlassian API integrations.
12k75 tok idle · 1,054 in use - chaos-engineerJeffallan/claude-skills
Designs chaos experiments, creates failure injection frameworks, and facilitates game day exercises for distributed systems — producing runbooks, experiment manifests, rollback procedures, and post-mortem templates. Use when designing chaos experiments, implementing failure injection frameworks, or conducting game day exercises. Invoke for chaos experiments, resilience testing, blast radius control, game days, antifragile systems, fault injection, Chaos Monkey, Litmus Chaos.
12k87 tok idle · 1,418 in use - cli-developerJeffallan/claude-skills
Use when building CLI tools, implementing argument parsing, or adding interactive prompts. Invoke for parsing flags and subcommands, displaying progress bars and spinners, generating bash/zsh/fish completion scripts, CLI design, shell completions, and cross-platform terminal applications using commander, click, typer, or cobra.
12k65 tok idle · 979 in use - cloud-architectJeffallan/claude-skills
Designs cloud architectures, creates migration plans, generates cost optimization recommendations, and produces disaster recovery strategies across AWS, Azure, and GCP. Use when designing cloud architectures, planning migrations, or optimizing multi-cloud deployments. Invoke for Well-Architected Framework, cost optimization, disaster recovery, landing zones, security architecture, serverless design.
12k70 tok idle · 1,643 in use - code-documenterJeffallan/claude-skills
Generates, formats, and validates technical documentation — including docstrings, OpenAPI/Swagger specs, JSDoc annotations, doc portals, and user guides. Use when adding docstrings to functions or classes, creating API documentation, building documentation sites, or writing tutorials and user guides. Invoke for OpenAPI/Swagger specs, JSDoc, doc portals, getting started guides.
12k79 tok idle · 1,191 in use