Sql Pro
by jeffallan1be15d8064f8MIT11K starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 5 days ago
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).
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| references/database-design.md | 12.2 KB | text/markdown |
| references/dialect-differences.md | 11.7 KB | text/markdown |
| references/optimization.md | 10.6 KB | text/markdown |
| references/query-patterns.md | 7.3 KB | text/markdown |
| references/window-functions.md | 8.7 KB | text/markdown |
| SKILL.md | 5.3 KB | text/markdown |
Source and attribution
Source:jeffallan/claude-skillsinskills/sql-proat commit1be15d8
License: MIT
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from jeffallan/claude-skills
Wordpress Pro
jeffallan
Guides WordPress theme, plugin, Gutenberg block, and WooCommerce development with security and performance practices.
Vue Expert Js
jeffallan
Builds Vue 3 apps in JavaScript only, using JSDoc annotations instead of TypeScript.
The Fool
jeffallan
Applies five structured critical-reasoning modes to stress-test ideas, plans, and decisions.
Swift Expert
jeffallan
Guides Swift 5.9+ development for Apple platforms, covering SwiftUI, async/await, actors, protocols and testing.
Spring Boot Engineer
jeffallan
Guides Spring Boot 3.x backend implementation: REST controllers, JPA data access, Security 6, WebFlux and testing.
Spark Engineer
jeffallan
Guides writing, tuning and configuring Apache Spark jobs for distributed data processing pipelines.
More in Data & Analytics
Content Strategy
anthropics
Turns PayPal, QuickBooks or Square sales data into a prioritized 30-day content brief for small businesses.
Cash Flow Snapshot
anthropics
Builds a 30/60/90-day cash flow forecast with confidence bands and named risk flags from ledger, payment or CSV data.
Pipeline Review
anthropics
Reviews CRM sales pipeline health by stage, flagging aging, stale and at-risk deals and checking coverage.
Metrics Review
anthropics
Reviews product metrics, analyzes trends against targets, and produces a scorecard with recommended actions.
Performance Report
anthropics
Builds marketing performance reports with key metrics, trend analysis, wins and misses, and prioritized optimization recommendations.
People Report
anthropics
Generates HR people-analytics reports on headcount, attrition, diversity, and org health from workforce data.