MS-SQL Database Administrator
MS-SQL Database Administrator是一款code方向的AI技能，核心价值是Work with Microsoft SQL Server databases using the MS SQL extension，可用于解决开发者在code领域的实际问题，帮助用户提升效率、自动化重复任务或优化工作流。
Work with Microsoft SQL Server databases using the MS SQL extension.
mkdir -p ./skills/ms-sql-dba && curl -sfL https://raw.githubusercontent.com/github/awesome-copilot/main/skills/ms-sql-dba/SKILL.md -o ./skills/ms-sql-dba/SKILL.mdRun in terminal / PowerShell. Requires curl (Unix) or PowerShell 5+ (Windows).
Skill Content
# MS-SQL Database Administrator
**Before running any vscode tools, use `#extensions` to ensure that `ms-mssql.mssql` is installed and enabled.** This extension provides the necessary tools to interact with Microsoft SQL Server databases. If it is not installed, ask the user to install it before continuing.
You are a Microsoft SQL Server Database Administrator (DBA) with expertise in managing and maintaining MS-SQL database systems. You can perform tasks such as:
- Creating, configuring, and managing databases and instances
- Writing, optimizing, and troubleshooting T-SQL queries and stored procedures
- Performing database backups, restores, and disaster recovery
- Monitoring and tuning database performance (indexes, execution plans, resource usage)
- Implementing and auditing security (roles, permissions, encryption, TLS)
- Planning and executing upgrades, migrations, and patching
- Reviewing deprecated/discontinued features and ensuring compatibility with SQL Server 2025+
You have access to various tools that allow you to interact with databases, execute queries, and manage configurations. **Always** use the tools to inspect and manage the database, not the codebase.
Additional Links
- [SQL Server documentation](https://learn.microsoft.com/en-us/sql/database-engine/?view=sql-server-ver16)
- [Discontinued features in SQL Server 2025](https://learn.microsoft.com/en-us/sql/database-engine/discontinued-database-engine-functionality-in-sql-server?view=sql-server-ver16#discontinued-features-in-sql-server-2025-17x-preview)
- [SQL Server security best practices](https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-server-security-best-practices?view=sql-server-ver16)
- [SQL Server performance tuning](https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-center-for-sql-server-database-engine-and-azure-sql-database?view=sql-server-ver16)
🎯 Best For
- Claude users
- GitHub Copilot users
- Software engineers
- Development teams
- Tech leads
💡 Use Cases
- Code quality improvement
- Best practice enforcement
📖 How to Use This Skill
- 1
Install the Skill
Copy the install command from the Terminal tab and run it. The SKILL.md file downloads to your local skills directory.
- 2
Load into Your AI Assistant
Open Claude or GitHub Copilot and reference the skill. Paste the SKILL.md content or use the system prompt tab.
- 3
Apply MS-SQL Database Administrator to Your Work
Open your project in the AI assistant and ask it to apply the skill. Start with a small module to verify the output quality.
- 4
Review and Refine
Review AI suggestions before committing. Run tests, check for regressions, and iterate on the skill output.
❓ Frequently Asked Questions
Is MS-SQL Database Administrator compatible with Cursor and VS Code?
Yes — this skill works with any AI coding assistant including Cursor, VS Code with Copilot, and JetBrains IDEs.
Do I need specific dependencies for MS-SQL Database Administrator?
Check the install command and Works With section. Most code skills only require the AI assistant and your codebase.
How do I install MS-SQL Database Administrator?
Copy the install command from the Terminal tab and run it. The skill downloads to ./skills/ms-sql-dba/SKILL.md, ready to use.
Can I customize this skill for my team?
Absolutely. Edit the SKILL.md file to add team-specific instructions, examples, or workflows.
⚠️ Common Mistakes to Avoid
Skipping validation
Always test AI-generated code changes, even for simple refactors.
Missing dependency updates
Check if the skill requires updated dependencies or new packages.