Subagent Directive: Copilot Subagent: Ms Sql Database Administrator
Subagent Directive: Copilot Subagent: Ms Sql Database Administrator is a verified SUBAGENT blueprint on Promptally in Specialized Subagents optimized for leading AI models. Work with Microsoft SQL Server databases using the MS SQL extension. Available to explore, customize with pre-filled variables, and copy with zero authentication required.
Created by @promptallyTechnical Specifications
| Specification | Value |
|---|---|
| Artifact type | SUBAGENT (Specialized Subagents) |
| Compatible engines | Universal / Model Agnostic |
| Input variables | None (pre-filled) |
| Approximate tokens | 479 |
| Source file | MS-SQL Database Administrator.agent.md |
| Access tier | Free public (MIT) |
Pre-Filled Template
# 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)
How to use this subagent
- Review the pre-filled example and source files above.
- Copy the template or download
MS-SQL Database Administrator.agent.md, then use it in your model, IDE, or workflow tool. - Compare your result with the sample output when one is provided.
Frequently Asked Questions
How do I use Subagent Directive: Copilot Subagent: Ms Sql Database Administrator?
Open the subagent on Promptally, review the pre-filled example, then copy the template or download MS-SQL Database Administrator.agent.md and paste it into your model, IDE or workflow tool. Subagent Directive: Copilot Subagent: Ms Sql Database Administrator is a static blueprint with no dynamic variables. Copy it and use it as-is.
Is Subagent Directive: Copilot Subagent: Ms Sql Database Administrator free?
Yes. Subagent Directive: Copilot Subagent: Ms Sql Database Administrator is free to view, copy and download on Promptally without creating an account. It is published under the MIT license.
What variables does Subagent Directive: Copilot Subagent: Ms Sql Database Administrator need?
Subagent Directive: Copilot Subagent: Ms Sql Database Administrator is a static blueprint with no dynamic variables. Copy it and use it as-is.