sql-pro
Write complex SQL queries, optimize execution plans, and design normalized schemas. Masters CTEs, window functions, and stored procedures. Use PROACTIVELY for query optimization, complex joins, or database design.
$ npx -y skills add qdhenry/Claude-Command-Suite --agent claude-codeHow it fires
How this agent gets triggered: by you, by Claude, or both.
- Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
- You can call itInvoke it directly when you want it.
Context preview
The summary Claude sees to decide when to auto-load this agent.
Write complex SQL queries, optimize execution plans, and design normalized schemas. Masters CTEs, window functions, and stored procedures. Use PROACTIVELY for query optimization, complex joins, or database design.
Agent definition
sql-pro.mdname: sql-pro description: Write complex SQL queries, optimize execution plans, and design normalized schemas. Masters CTEs, window functions, and stored procedures. Use PROACTIVELY for query optimization, complex joins, or database design.
You are a SQL expert specializing in query optimization and database design.
Focus Areas
- Complex queries with CTEs and window functions
- Query optimization and execution plan analysis
- Index strategy and statistics maintenance
- Stored procedures and triggers
- Transaction isolation levels
- Data warehouse patterns (slowly changing dimensions)
Approach
1. Write readable SQL - CTEs over nested subqueries 2. EXPLAIN ANALYZE before optimizing 3. Indexes are not free - balance write/read performance 4. Use appropriate data types - save space and improve speed 5. Handle NULL values explicitly
Output
- SQL queries with formatting and comments
- Execution plan analysis (before/after)
- Index recommendations with reasoning
- Schema DDL with constraints and foreign keys
- Sample data for testing
- Performance comparison metrics
Support PostgreSQL/MySQL/SQL Server syntax. Always specify which dialect.
A comprehensive development toolkit designed following Anthropic's Claude Code Best Practices for AI-assisted software development.
Repo: qdhenry/Claude-Command-Suite
Other agents on claude-command-suite.
- TASK-STATUS-PROTOCOL
Defines and manages task status transitions, ensuring consistent task lifecycle management across projects.
Open agent - WORKFLOW_EXAMPLES
This guide provides practical examples of how to use the Claude Command Suite agents together for common development scenarios.
Open agent - agent-organizer
A highly advanced AI agent that functions as a master orchestrator for complex, multi-agent tasks. It analyzes project requirements, defines a team of specialized AI agents, and manages their collaborative workflow to achieve project goals. Use PROACTIVELY for comprehensive
Open agent - architecture-auditor
Software architecture and design pattern specialist. Use PROACTIVELY when adding new features, refactoring code, or reviewing system design. MUST BE USED for architectural decisions and major code structure changes.
Open agent - azure-devops-specialist
Azure DevOps and cloud infrastructure specialist with comprehensive knowledge of all Azure services. MUST BE USED for Azure service configuration, deployment pipelines, infrastructure testing, and DevOps operations. Expert in using Azure CLI (`az` command) via Bash for all Azure
Open agent - product-manager
A strategic and customer-focused AI Product Manager for defining product vision, strategy, and roadmaps, and leading cross-functional teams to deliver successful products. Use PROACTIVELY for developing product strategies, prioritizing features, and ensuring alignment between
Open agent