SQL Expert

Use this skill when the user needs help writing SQL queries, optimizing existing queries, understanding execution plans, designing schemas, or debugging database issues. Trigger on phrases like "write a query", "optimize this SQL", "explain this query", "design a schema", "database help", "why is this query slow", etc.

6 starsDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add techgangboss/agentstore

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add techgangboss/agentstore --skill sql-expert
Manual install
git clone --depth 1 https://github.com/techgangboss/agentstore.git /tmp/agentstore
mkdir -p ~/.claude/skills
cp -r /tmp/agentstore/plugins/sql-expert/skills/sql-expert ~/.claude/skills/sql-expert

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# SQL Expert

Write optimized SQL queries and explain execution plans. Supports PostgreSQL, MySQL, and SQLite.

## Capabilities

- Write complex SQL queries from natural language descriptions
- Optimize slow queries with index and structure suggestions
- Explain execution plans in plain English
- Design normalized database schemas
- Debug query errors and suggest fixes
- Generate migrations for schema changes

## Instructions

### Writing Queries

When the user describes what data they need:

1. Ask clarifying questions if the schema is unclear
2. Check for existing schema files (`.sql`, migrations, ORM models) in the project
3. Write the query with:
   - Clear aliases and formatting
   - Appropriate JOINs (prefer explicit JOIN syntax over implicit)
   - WHERE clauses with proper indexing considerations
   - LIMIT for potentially large result sets
4. Explain what the query does and any assumptions made

### Optimizing Queries

When the user shares a slow query:

1. Analyze the query structure
2. Check for common performance issues:
   - Missing indexes on JOIN/WHERE columns
   - SELECT * when only specific columns needed
   - Correlated subqueries that could be JOINs
   - Missing LIMIT on large tables
   - Unnecessary ORDER BY on unindexed columns
   - N+1 query patterns in application code
3. Suggest specific improvements with before/after
4. Recommend indexes to create: `CREATE INDEX idx_name ON table(column);`

### Explaining Execution Plans
Read the full skill on GitHub

Details

Skill name
sql-expert
Path
plugins/sql-expert/skills/sql-expert/SKILL.md
License
MIT
Repo updated
12 February 2026

FAQ

What does the SQL Expert skill do?

Use this skill when the user needs help writing SQL queries, optimizing existing queries, understanding execution plans, designing schemas, or debugging database issues. Trigger on phrases like "write a query", "optimize this SQL", "explain this query", "design a schema", "database help", "why is this query slow", etc.

How do I install the SQL Expert skill?

Claude Code plugin: /plugin marketplace add techgangboss/agentstore. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is SQL Expert popular?

It lives in techgangboss/agentstore, which has 6 GitHub stars and 0 forks, and is included in 1 curated skill list.

Related skills

Code Reviewer

6

techgangboss/agentstore

Use this skill when the user asks for a code review, wants to check code quality, find bugs, identify security issues, or get best practice suggestions. Trigger on phrases like "review this code", "check for bugs", "security audit", "code quality", "review my PR", "what's wrong with this code", etc.

Software DevelopmentIn 1 list

Wallet Assistant

6

techgangboss/agentstore

Use this skill when the user asks about their AgentStore wallet, USDC balance, transaction history, spending patterns, or wants to check payment status. Trigger on phrases like "check my balance", "wallet status", "transaction history", "how much have I spent", "payment history", etc.

Finance & CryptoIn 1 list

Common

9

mark64oswald/healthsim-workspace

Cross-product infrastructure for HealthSim — persistence (cohort save/load), identity correlation (SSN-based cross-product linking), and DuckDB database operations. Use when saving/loading cohorts, linking entities across products, or querying the database directly.

Databases

Persistence Design

9

eralmansouri/skills

Use for database and persistence design, data ownership, transaction boundaries, repositories, CQRS read models, query performance, optimistic concurrency, caching, projections, schema migrations, partitioning, and multi-tenancy.

Databases

Meta Analysis Systematic Review

5

maydengximin-sketch/meta-analysis-systematic-review-skill

元分析与系统综述(Meta-analysis / Systematic Review + PRISMA)专项方法学助手,聚焦"用 PRISMA 规范做一篇可复制的系统综述,并在合适时把定量结果用元分析合并"的完整链路。当用户要做系统综述或元分析的任何环节时使用:判断"我该做叙述性综述、系统综述、还是元分析、数据够不够同质来合并"、写可检索的研究问题(PICO/PICOS)与预注册协议(PROSPERO)、设计检索策略(数据库、检索式、灰色文献、纳入排除标准)、按 PRISMA 2020 画流程图并双人筛选(标题摘要→全文)、数据提取与调节变量编码、选并计算效应量(Cohen's d / Hedges' g / 相关 r / OR / RR / 及其方差与换算)、固定效应 vs 随机效应模型的选择与加权、异质性评估(Q 检验、I²、τ²)与亚组分析和元回归、发表偏倚检测(漏斗图、Egger 检验、trim-and-fill、p-curve)、研究质量与偏倚风险评价(RoB2 / Newcastle-Ottawa / GRADE)、用软件(R metafor/meta、CMA、RevMan、Stata)做森林图并按 PRISMA 报告、把结果写进论文并应对答辩。触发词包括"元分析""荟萃分析""meta-analysis""系统综述""系统评价""systematic review""

Databases

Seekdb

9

oceanbase/oceanbase-skills

Overview skill for OceanBase SeekDB. Routes to specialized sub-skills covering the full SeekDB lifecycle — install/deploy on a target machine, build from source, look up documentation, use the seekdb-cli for SQL/schema/vector ops, import CSV/Excel data, and query/export results. Use as a starting point when the user mentions seekdb, pyseekdb, "install seekdb", "build seekdb", "seekdb docs", "seekdb-cli", "import to seekdb", "query seekdb", or wants a lightweight standalone OceanBase-compatible database.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.