SQL Pro
Jeffallan/claude-skills
Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.
Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.
Install Agent SQL Pro
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install xiaoyuge886/aigc agent-sql-pro --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/agent-sql-pro .claude/skills/agent-sql-pro && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .claude/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-proType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install xiaoyuge886/aigc agent-sql-pro --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/agent-sql-pro .agents/skills/agent-sql-pro && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .agents/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install xiaoyuge886/aigc agent-sql-pro --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/agent-sql-pro .cursor/skills/agent-sql-pro && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .cursor/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/xiaoyuge886/aigc.git --path .claude/skills/agent-sql-pro--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install xiaoyuge886/aigc agent-sql-pro --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/agent-sql-pro .gemini/skills/agent-sql-pro && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .gemini/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install xiaoyuge886/aigc agent-sql-proInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/agent-sql-pro .github/skills/agent-sql-pro && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .github/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install xiaoyuge886/aigc agent-sql-pro --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/xiaoyuge886/aigc.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/agent-sql-pro .opencode/skills/agent-sql-pro && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "agent-sql-pro" agent skill from https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro into .opencode/skills/agent-sql-pro/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "agent-sql-pro", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
agent-sql-pro- GitHub stars
- 198
- Token cost
- ~315 tokens
- SKILL.md length
- 115 words
- Files
- 1
- Skills in repo
- 9
- Repo updated
- First seen
- Licence
- MIT
At a glance
Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.
- Tasks that involve SQL
- SKILL.md covers Domain, Tools, Key Capabilities and Activation, plus 1 more section
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
- Tasks that involve Query optimization
What it does
Agent SQL Pro is an agent skill from xiaoyuge886/aigc. Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Masters advanced SQL features, indexing strategies, and data warehousing patterns.
Its SKILL.md is about 320 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering SQL, Query optimization and Database schema design. It works with SQL, PostgreSQL, MySQL and Microsoft SQL Server. The repository describes itself as: AIGC 智能 Agent 平台是一个强大的 AI 应用框架，通过集成 Claude AI 模型和丰富的技能生态系统，为用户提供智能化、场景化的 AI 解决方案。平台采用前后端分离架构，支持多租户、会话管理、技能扩展等企业级特性。 The licence is MIT.
When your agent uses it
- Tasks that involve SQL
- Tasks that involve Query optimization
- Tasks that involve Database schema design
Example prompts
- “/agent-sql-pro”
What it can do on your machine
Read from SKILL.md and the folder at commit e970014. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Agent SQL Pro loads about 315 tokens when it runs. Until then it costs about 63 tokens; SKILL.md has 115 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from xiaoyuge886/aigc at commit e970014, republished under its MIT licence (© xiaoyuge886). 115 words, ~315 tokens.
Download SKILL.mdSave it as
.claude/skills/agent-sql-pro/SKILL.md (or your agent's skills folder).- name
- agent-sql-pro
- description
- Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Masters advanced SQL features, indexing strategies, and data warehousing patterns.
Sql Pro Agent
You are a senior SQL developer with mastery across major database systems (PostgreSQL, MySQL, SQL Server, Oracle), specializing in complex query design, performance optimization, and database architecture. Your expertise spans ANSI SQL standards, platform-specific optimizations, and modern data patterns with focus on efficiency and scalability.
Domain
Language Expertise
Tools
Primary: Read, Write, MultiEdit, Bash, psql, mysql
Key Capabilities
- ANSI SQL compliance verified
- Query performance < 100ms target
- Execution plans analyzed
- Index coverage optimized
- Deadlock prevention implemented
- Data integrity constraints enforced
Activation
This agent activates for tasks involving:
- sql professional related work
- Domain-specific implementation and optimization
- Technical guidance and best practices
Integration
Works with other agents for:
- Cross-functional collaboration
- Domain expertise sharing
- Quality validation
© xiaoyuge886, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in .claude/skills/agent-sql-pro of xiaoyuge886/aigc.
Open the folder on GitHubat commit e970014
Compare with similar skills
Agent SQL Pro next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Agent SQL Pro this skillxiaoyuge886/aigc | 198 | — | ~315 | Automated safety check: Pass | MIT | |
| SQL ProJeffallan/claude-skills | 12k | — | ~1.3k | Automated safety check: Pass | MIT | |
| SQL Expertaiskillstore/marketplace | 430 | — | ~3.4k | Automated safety check: Pass | None | |
| SQL Optimizationgithub/awesome-copilot | 40k | 2 repos | ~2.3k | Automated safety check: Pass | MIT | |
| SQL Queriesphuryn/pm-skills | 27k | — | ~907 | Automated safety check: Pass | MIT | |
| Optimizing SQLancoleman/ai-design-components | 526 | — | ~3k | Automated safety check: Pass | MIT |
Similar skills
SQL Expert
aiskillstore/marketplace
Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server.
- Official
SQL Optimization
github/awesome-copilot
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…
SQL Queries
phuryn/pm-skills
Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills.
Optimizing SQL
ancoleman/ai-design-components
Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
SQL Toolkit
LeoYeAI/openclaw-master-skills
Query, design, migrate, and optimize SQL databases. An agent skill from LeoYeAI/openclaw-master-skills.
More from xiaoyuge886/aigc
All 9 skills in this repoDocs Management
xiaoyuge886/aigc
Single source of truth and librarian for ALL Claude official documentation.
Data Analysis
xiaoyuge886/aigc
Perform data analysis tasks including data cleaning, statistical analysis, visualization, and insight generation.
Xagent
xiaoyuge886/aigc
XAgent是一个智能跨域分析助手，基于SOP驱动的规划、多工具协调和多层次数据分析框架，提供专业的商业智能和数据分析能力。当用户需要进行数据分析、业务分析、生成报告或需要结构化的问题解决方案时使用。
Investment Due Diligence Report
xiaoyuge886/aigc
投资尽调报告专业生成工具。当用户需要撰写投资尽调报告、尽职调查报告、投资分析报告时使用此skill。支持处理Excel财务数据、PDF文档等多种格式数据源，自动生成包含执行摘要、业务分析、财务分析、风险提示、投资建议等核心章节的专业报告。无论用户明确要求"写报告"还是提到"分析投资标的"、"评估项目"、"做DD"等相关需求时，都应使用此skill。
Minio Uploader
xiaoyuge886/aigc
简化版MinIO文件上传工具，支持一键上传文件到MinIO对象存储并获取访问链接. An agent skill from xiaoyuge886/aigc.
Todo Master
xiaoyuge886/aigc
专业的待办事项管理技能，指导如何有效使用 TodoWrite 工具进行任务规划、进度跟踪和状态管理。当用户需要处理复杂任务、多步骤工作流或需要任务规划时使用。
Related
Works with
Categories
Questions about Agent SQL Pro
What does Agent SQL Pro do?
Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Agent SQL Pro is an agent skill from xiaoyuge886/aigc. Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.
When should I use Agent SQL Pro?
Agent SQL Pro fits situations like: tasks that involve SQL; tasks that involve Query optimization; tasks that involve Database schema design.
How do I install Agent SQL Pro in Claude Code?
Run `npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a claude-code`. Or copy the skill folder (.claude/skills/agent-sql-pro in xiaoyuge886/aigc) into .claude/skills/agent-sql-pro in your project. Claude Code loads it when a task matches its description.
How do I install Agent SQL Pro in Codex?
Run `npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a codex`. Or copy the skill folder (.claude/skills/agent-sql-pro in xiaoyuge886/aigc) into .agents/skills/agent-sql-pro in your project. Codex loads it when a task matches its description.
Can I use Agent SQL Pro in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add xiaoyuge886/aigc --skill agent-sql-pro -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/agent-sql-pro, .gemini/skills/agent-sql-pro, .github/skills/agent-sql-pro and .opencode/skills/agent-sql-pro in your project.
What does Agent SQL Pro need to run?
SKILL.md names no scripts, command-line tools or credentials: Agent SQL Pro is instructions for the agent only.
Does Agent SQL Pro access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Agent SQL Pro safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Agent SQL Pro use?
Agent SQL Pro is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Agent SQL Pro use?
About 315 tokens (SKILL.md is roughly 1.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Agent SQL Pro?
Skills that share tags, products or a category with Agent SQL Pro: SQL Pro (Jeffallan/claude-skills, 12k stars), SQL Expert (aiskillstore/marketplace, 430 stars), SQL Optimization (github/awesome-copilot, 40k stars) and SQL Queries (phuryn/pm-skills, 27k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Agent SQL Pro?
xiaoyuge886 (a GitHub user) maintains it in xiaoyuge886/aigc, which has 198 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on July 14, 2026.
Source: xiaoyuge886/aigc on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.