mssql-expert
Use when implementing mssql functionality with production-grade patterns and safeguards.
- License 许可
- MIT
- 最近更新
- 2026-04-11
- Stars
- ★ 3
- Forks
- 0
01 前言 Front Matter
- name
- mssql-expert
- metadata
- { "hermes": { "tags": [ "codex-agent", "databases-storage" ], "source": "codex-field-kit/databases-storage" } }
- description
- Use when implementing mssql functionality with production-grade patterns and safeguards.
03 SKILL.md 正文
Mssql Expert
Focus Areas
- Advanced T-SQL programming and query optimization
- Indexing strategy and performance tuning
- Database normalization and schema design
- Transaction management and isolation levels
- Stored procedures, functions, and triggers
- High-availability solutions like clustering and Always On
- Security practices including encryption and permissions
- Backup, restore, and disaster recovery planning
- Analysis and optimization of execution plans
- Integration with SQL Server Reporting Services (SSRS)
Approach
- Apply systematic query optimization techniques
- Implement effective indexing strategies for performance
- Normalize databases to minimize redundancy
- Manage transactions with appropriate isolation levels
- Write efficient stored procedures and user-defined functions
- Ensure high availability and disaster recovery guidelines
- Utilize security features to safeguard data
- Prioritize regular backups and test restoration processes
- Analyze execution plans to identify bottlenecks
- Align reports and analytics with SQL Server Reporting Services
Quality Checklist
- Queries are consistently optimized for performance
- Proper indexing strategy is in place for all tables
- Database schema adheres to normalization principles
- Transaction handling prevents deadlocks and isolation issues
- Stored procedures are efficient and reusable
- Security practices are integrated throughout the database
- High availability configurations are appropriately tested
- Backup and restore procedures are routinely verified
- Execution plans are regularly reviewed for improvement
- Reporting solutions are accurate and timely
Output
- Optimized queries with detailed comments
- Indexed tables with performance metrics
- Well-designed and normalized database schema
- Secure transaction handling with minimal locking
- Modular and efficient stored procedures and functions
- High-availability setup documentation
- Comprehensive backup and disaster recovery plans
- Execution plan analysis and improvements
- SQL Server Reporting Services integrated solutions
- Database security audits and reports
04 同仓库更多 Skills
vercel-react-best-practices
React and Next.js performance optimization guidelines from Vercel Engineering. This skill should be used when writing, reviewing, or refactoring React/Next.js code to ensure optimal performance patterns. Triggers on tasks involving React components, Next.js pages, data fetching, bundle optimization, or performance improvements.
swarm-planner
[EXPLICIT INVOCATION ONLY] Creates dependency-aware implementation plans optimized for parallel multi-agent execution.
super-swarm-spark
Only to be triggered by explicit super-swarm-spark commands.
role-creator
Create and install Codex custom agent roles in ~/.codex/config.toml, generate role config files, enforce supported keys, and guide users through required role inputs (model, reasoning effort, developer_instructions).
read-github
Read and search GitHub repository documentation via gitmcp.io MCP service. **WHEN TO USE:** - User provides a GitHub URL - User mentions a specific repo in owner/repo format - User asks "what does this repo do?", "read the docs for X repo", or similar - User wants to search code or docs within a repo
planner
Create comprehensive, phased implementation plans with sprints and atomic tasks. Use when user says: "make a plan", "create a plan", "plan this out", "plan the implementation", "help me plan", "design a plan", "draft a plan", "write a plan", "outline the steps", "break this down into tasks", "what's the plan for", or any similar planning request. Also triggers on explicit "/planner" or "/plan" commands.