Subagent

MS-SQL Database Administrator

Work with Microsoft SQL Server databases using the MS SQL extension.

Type: Subagent
Repository: github/awesome-copilot
GitHub stars: 39.4k
License: MIT
Repo last updated: Sep 27, 2026
Source file: agents/ms-sql-dba.agent.md

What MS-SQL Database Administrator is

MS-SQL Database Administrator is a subagent published in the github/awesome-copilot repository on GitHub, which has about 39.4k stars. The repository describes itself as: “Community-contributed instructions, agents, skills, and configurations to help you make the most of GitHub Copilot.”

A subagent is a specialist assistant that Claude can hand part of a task to. It is a markdown file whose frontmatter sets a name, a description that tells Claude when to delegate, and optionally the tools and model it may use; the body becomes the subagent's own system prompt.

Because a subagent works in its own context, it keeps the main conversation focused: Claude can send a narrow job, such as a review or a specialised analysis, to MS-SQL Database Administrator and get back a compact result.

It is set up to use these tools: search/codebase, edit/editFiles, githubRepo, extensions, runCommands, database, mssql_connect, mssql_query, mssql_listServers, mssql_listDatabases, mssql_disconnect, mssql_visualizeSchema. Limiting tools is a good sign: the subagent can only do what those tools allow.

How to install MS-SQL Database Administrator

Claude Code

Download ms-sql-dba.agent.md from the repository.
Save it to ~/.claude/agents/ to use it in every project, or to .claude/agents/ inside one project to share it through version control.
Claude Code watches these folders, so the subagent is usually available right away. Ask Claude to use it by name, or @-mention it to make sure it runs.

Claude Cowork

Cowork loads subagents through plugins. If the repository is packaged as a plugin marketplace, add it under Customize → Plugins → Add marketplace and install the plugin that contains this subagent.
Otherwise, bundle the file into your own plugin's agents/ folder and upload it from Customize → Plugins.

New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.

Inside the source file

An excerpt from agents/ms-sql-dba.agent.md, shared under the repository's MIT license. Read the full file on GitHub.

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
Discontinued features in SQL Server 2025
SQL Server security best practices
SQL Server performance tuning

Before you install

Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
Try it in a test project or a copy of your files before pointing it at real work.
Pin the version you tested, and review changes before updating.
Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.

FAQ

What is MS-SQL Database Administrator?

MS-SQL Database Administrator is a subagent for Claude Code and Claude Cowork from the github/awesome-copilot repository on GitHub. Work with Microsoft SQL Server databases using the MS SQL extension.

How do I install MS-SQL Database Administrator in Claude Code?

Download ms-sql-dba.agent.md from the repository. Save it to ~/.claude/agents/ to use it in every project, or to .claude/agents/ inside one project to share it through version control. Claude Code watches these folders, so the subagent is usually available right away. Ask Claude to use it by name, or @-mention it to make sure it runs.

Can I use MS-SQL Database Administrator in Claude Cowork?

Cowork loads subagents through plugins. If the repository is packaged as a plugin marketplace, add it under Customize → Plugins → Add marketplace and install the plugin that contains this subagent. Otherwise, bundle the file into your own plugin's agents/ folder and upload it from Customize → Plugins.

Is MS-SQL Database Administrator safe to install?

It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.

Similar resources

Browse all skills, subagents, and plugins →

Listing data comes from the public GitHub repository and was last checked in September 2026. Excerpts are © their authors and shared under MIT. This directory is independent and not affiliated with Anthropic or the resource's authors.