sql-server-dba-dev-expert
CommunitySQL Server DBA+Dev expert for AF.ECT.Database.
Software Engineering#indexing#performance-tuning#data-integrity#sql-server#database-design#backup-recovery#stored-procedures
Authordonellmccoy
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill provides the combined expertise required to design, implement, optimize, and troubleshoot the AF.ECT.Database schemas, queries, and stored procedures, ensuring performance, data integrity, security, and reliable operations.
Core Features & Use Cases
- Performance tuning: Optimize high-volume queries and stored procedures used by the AF.ECT.Database, such as form348_sp_* and related search routines.
- Schema and security design: Apply best practices for schema organization (dbo, usp, DBSign), access control, and auditing.
- Backup, recovery, and compliance: Establish robust backup strategies, disaster recovery plans, and data protection measures for military-grade operations.
- Use Case: When a case search is slow or a workflow transition fails, this skill guides diagnosis, remediation, and validation.
Quick Start
Start by auditing the performance of key search SPs (e.g., form348_sp_FullSearch) and reviewing core_user_sp and core_workflow_sp implementations against recommended patterns.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sql-server-dba-dev-expert Download link: https://github.com/donellmccoy/ECTSystem/archive/main.zip#sql-server-dba-dev-expert Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.