What problem does it solve?
This Skill provides comprehensive guidance and best practices for writing efficient SQL queries, designing robust database schemas, and performing essential Microsoft SQL Server Database Administration tasks.
Core Features & Use Cases
- Schema Design: Enforces naming conventions, required columns, and constraint best practices.
- SQL Coding Style: Promotes readable, maintainable SQL with formatting and structure guidelines.
- Stored Procedures: Standardizes creation, parameter handling, and structure for reusable logic.
- Security: Details practices to prevent SQL injection and manage transactions securely.
- DBA Tasks: Covers essential responsibilities like performance tuning, backups, and security configuration.
- Use Case: You need to design a new database schema for a user management system, ensuring all tables have primary keys, foreign keys with cascade rules, and appropriate timestamps.
Quick Start
Use the sql-development skill to generate a T-SQL stored procedure template for creating a new user record.
