AGENT SKILL

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

0xharryriddle
0xharryriddle/codex-field-kit

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.

前端开发
★ 3
0xharryriddle
0xharryriddle/codex-field-kit

swarm-planner

[EXPLICIT INVOCATION ONLY] Creates dependency-aware implementation plans optimized for parallel multi-agent execution.

★ 3
0xharryriddle
0xharryriddle/codex-field-kit

super-swarm-spark

Only to be triggered by explicit super-swarm-spark commands.

★ 3
0xharryriddle
0xharryriddle/codex-field-kit

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).

★ 3
0xharryriddle
0xharryriddle/codex-field-kit

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

Skill与智能体开发
★ 3
0xharryriddle
0xharryriddle/codex-field-kit

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.

★ 3