Agent
TASK-STATUS-PROTOCOL
Defines and manages task status transitions, ensuring consistent task lifecycle management across projects.
@qdhenryView AgentDevelopment
Agent
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.
Install
$ 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.
Ships withclaude-command-suite
A comprehensive development toolkit designed following Anthropic's Claude Code Best Practices for AI-assisted software development.
Get the whole plugin
Stats
1,335
Stars
153
Forks
Quiet
Maintenance
Shell
Language
6mo ago
Last commit
1y ago
Created
Repo: qdhenry/Claude-Command-Suite
Other agents on claude-command-suite.
@qdhenryView AgentAgent
WORKFLOW_EXAMPLES
This guide provides practical examples of how to use the Claude Command Suite agents together for common development scenarios.
@qdhenryView AgentAgent
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…
@qdhenryView AgentAgent
architecture-auditor
Software architecture and design pattern specialist. Use PROACTIVELY when adding new features, refactoring code, or reviewing system design. MUST BE USED for…
@qdhenryView AgentAgent
azure-devops-specialis…
Azure DevOps and cloud infrastructure specialist with comprehensive knowledge of all Azure services. MUST BE USED for Azure service configuration, deployment…
@qdhenryView AgentAgent
product-manager
A strategic and customer-focused AI Product Manager for defining product vision, strategy, and roadmaps, and leading cross-functional teams to deliver…
@qdhenryView Agent