dba-mssql
CommunityMaster SQL Server 2022+ database design and administration.
Software Engineering#schema design#performance tuning#dba#sql server#database administration#t-sql#columnstore
AuthorMassimilianoPili
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill streamlines the design, development, and administration of SQL Server 2022+ databases, ensuring efficient, secure, and performant data management.
Core Features & Use Cases
- T-SQL Development: Write stored procedures, functions, and optimize queries.
- Schema Design: Implement best practices for indexing, partitioning, and temporal tables.
- Performance Tuning: Analyze execution plans and leverage DMVs for optimization.
- Administration: Configure Always On availability groups and security features like TDE.
- Use Case: Develop a new temporal audit table for tracking changes to sensitive customer data, ensuring compliance and enabling point-in-time analysis.
Quick Start
Use the dba-mssql skill to create a new temporal audit table named 'audit_log' with a clustered columnstore index.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 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: dba-mssql Download link: https://github.com/MassimilianoPili/agent-framework/archive/main.zip#dba-mssql 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.