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.
Install
/plugin marketplace add techgangboss/agentstoreThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add techgangboss/agentstore --skill sql-expertgit 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-expertPersonal 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
Details
- Skill name
sql-expert- Repository
- techgangboss/agentstore
- Path
plugins/sql-expert/skills/sql-expert/SKILL.md- License
- MIT
- Repo updated
- 12 February 2026
- Listed in
- heilcheng/awesome-agent-skills
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
6techgangboss/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.
Wallet Assistant
6techgangboss/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.
Common
9mark64oswald/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.
Persistence Design
9eralmansouri/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.
Meta Analysis Systematic Review
5maydengximin-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""
Seekdb
9oceanbase/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.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.