agent-sql-pro
Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL,…
Analyze a codebase and recommend Claude Code automations (hooks, subagents, skills, plugins, MCP servers). Use when user asks for automation recommendations, wants to optimize their Claude Code setup, mentions improving Claude Code workflows, asks how to first set up Claude Code
$ npx -y skills add xiaoyuge886/aigc --skill claude-automation-recommender --agent claude-codeHow it fires
How this skill gets triggered: by you, by Claude, or both.
/claude-automation-recommenderContext preview
The summary Claude sees to decide when to auto-load this skill.
Analyze a codebase and recommend Claude Code automations (hooks, subagents, skills, plugins, MCP servers). Use when user asks for automation recommendations, wants to optimize their Claude Code setup, mentions improving Claude Code workflows, asks how to first set up Claude Code
name: claude-automation-recommender description: Analyze a codebase and recommend Claude Code automations (hooks, subagents, skills, plugins, MCP servers). Use when user asks for automation recommendations, wants to optimize their Claude Code setup, mentions improving Claude Code workflows, asks how to first set up Claude Code for a project, or wants to know what Claude Code features they should use. tools: Read, Glob, Grep, Bash
Analyze codebase patterns to recommend tailored Claude Code automations across all extensibility options.
**This skill is read-only.** It analyzes the codebase and outputs recommendations. It does NOT create or modify any files. Users implement the recommendations themselves or ask Claude separately to help build them.
| Type | Best For | |------|----------| | **Hooks** | Automatic actions on tool events (format on save, lint, block edits) | | **Subagents** | Specialized reviewers/analyzers that run in parallel | | **Skills** | Packaged expertise, workflows, and repeatable tasks (invoked by Claude or user via `/skill-name`) | | **Plugins** | Collections of skills that can be installed | | **MCP Servers** | External tool integrations (databases, APIs, browsers, docs) |
Gather project context:
# Detect project type and tools ls -la package.json pyproject.toml Cargo.toml go.mod pom.xml 2>/dev/null cat package.json 2>/dev/null | head -50 # Check dependencies for MCP server recommendations cat package.json 2>/dev/null | grep -E '"(react|vue|angular|next|express|fastapi|django|prisma|supabase|stripe)"' # Check for existing Claude Code config ls -la .claude/ CLAUDE.md 2>/dev/null # Analyze project structure ls -la src/ app/ lib/ tests/ components/ pages/ api/ 2>/dev/null
**Key Indicators to Capture:**
| Category | What to Look For | Informs Recommendations For | |----------|------------------|----------------------------| | Language/Framework | package.json, pyproject.toml, import patterns | Hooks, MCP servers | | Frontend stack | React, Vue, Angular, Next.js | Playwright MCP, frontend skills | | Backend stack | Express, FastAPI, Django | API documentation tools | | Database | Prisma, Supabase, raw SQL | Database MCP servers | | External APIs | Stripe, OpenAI, AWS SDKs | context7 MCP for docs | | Testing | Jest, pytest, Playwright configs | Testing hooks, subagents | | CI/CD | GitHub Actions, CircleCI | GitHub MCP server | | Issue tracking | Linear, Jira references | Issue tracker MCP | | Docs patterns | OpenAPI, JSDoc, docstrings | Documentation skills |
Based on analysis, generate recommendations across all categories:
See [references/mcp-servers.md](references/mcp-servers.md) for detailed patterns.
| Codebase Signal | Recommended MCP Server | |-----------------|------------------------| | Uses popular libraries (React, Express, etc.) | **context7** - Live documentation lookup | | Frontend with UI testing needs | **Playwright** - Browser automation/testing | | Uses Supabase | **Supabase MCP** - Direct database operations | | PostgreSQL/MySQL database | **Database MCP** - Query and schema tools | | GitHub repository | **GitHub MCP** - Issues, PRs, actions | | Uses Linear for issues | **Linear MCP** - Issue management | | AWS infrastructure | **AWS MCP** - Cloud resource management | | Slack workspace | **Slack MCP** - Team notifications | | Memory/context persistence | **Memory MCP** - Cross-session memory | | Sentry error tracking | **Sentry MCP** - Error investigation | | Docker containers | **Docker MCP** - Container management |
See [references/skills-reference.md](references/skills-reference.md) for details.
Create skills in `.claude/skills/<name>/SKILL.md`. Some are also available via plugins:
| Codebase Signal | Skill | Plugin | |-----------------|-------|--------| | Building plugins | skill-development | plugin-dev | | Git commits | commit | commit-commands | | React/Vue/Angular | frontend-design | frontend-design | | Automation rules | writing-rules | hookify | | Feature planning | feature-dev | feature-dev |
**Custom skills to create** (with templates, scripts, examples):
| Codebase Signal | Skill to Create | Invocation | |-----------------|-----------------|------------| | API routes | **api-doc** (with OpenAPI template) | Both | | Database project | **create-migration** (with validation script) | User-only | | Test suite | **gen-test** (with example tests) | User-only | | Component library | **new-component** (with templates) | User-only | | PR workflow | **pr-check** (with checklist) | User-only | | Releases | **release-notes** (with git context) | User-only | | Code style | **project-conventions** | Claude-only | | Onboarding | **setup-dev** (with prereq script) | User-only |
See [references/hooks-patterns.md](references/hooks-patterns.md) for configurations.
| Codebase Signal | Recommended Hook | |-----------------|------------------| | Prettier configured | PostToolUse: auto-format on edit | | ESLint/Ruff configured | PostToolUse: auto-lint on edit | | TypeScript project | PostToolUse: type-check on edit | | Tests directory exists | PostToolUse: run related tests | | `.env` files present | PreToolUse: block `.env` edits | | Lock files
Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL,…
Perform data analysis tasks including data cleaning, statistical analysis, visualization, and insight generation. Use when the…
Single source of truth and librarian for ALL Claude official documentation. Manages local documentation storage, scraping,…
ECharts数据可视化专家,能够根据数据和分析需求生成专业的ECharts图表配置。适用于:数据可视化、图表生成、数据展示、趋势分析图表、对比图表、分布图表、饼图、柱状图、折线图、散点图、雷达图、热力图、仪表盘、漏斗图、树形图、关系图、桑基图、数据报表图表、…
Transform UI style requirements into production-ready frontend code with systematic design tokens, accessibility compliance, and…
综合智能代理系统,整合任务分析、规划和ReAct执行循环能力。当用户需要处理复杂任务、多步骤工作流或需要自主决策和反思的任务时使用。