Skip to main content
affpapa.org
RU EN
subagent official · GitHub

MS-SQL Database Administrator — GitHub Copilot subagent

Microsoft SQL Server administrator subagent for GitHub Copilot. Helps inspect schemas, optimize T-SQL queries, and check compatibility with SQL Server 2025.

Install into GitHub Copilot · Manually: put the files in place All methods and platforms ↓ 
.github/agents/ms-sql-dba.agent.md
Open on GitHub

What MS-SQL Database Administrator does

This subagent acts as a Microsoft SQL Server database administrator. It writes and tunes T-SQL queries, examines execution plans, and audits security roles or encryption. When preparing upgrades, it checks objects against features removed in SQL Server 2025.

Instead of parsing codebase files, it inspects database instances directly. Available tools include mssql_connect, mssql_query, and mssql_visualizeSchema.

The ms-mssql.mssql extension for VS Code is strictly required. Without it, the subagent halts immediately.

What it helps with

  • tune slow T-SQL queries and execution plans
  • audit database objects for SQL Server 2025 compatibility
  • manage security roles, permissions, and TLS settings
  • render schema diagrams using mssql_visualizeSchema

Example prompts for the agent

  • Connect to the server and list all available databases.
  • Check this T-SQL query execution plan and recommend indexes.
  • Find stored procedures that use discontinued SQL Server 2025 features.

How to install MS-SQL Database Administrator

Manually: put the files in place

.github/agents/ms-sql-dba.agent.md

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about MS-SQL Database Administrator

How to install MS-SQL Database Administrator in GitHub Copilot?

Place the subagent configuration file into .github/agents/ms-sql-dba.agent.md inside your repository.

What does MS-SQL Database Administrator do?

It manages Microsoft SQL Server instances by executing queries, tuning performance, auditing permissions, and checking migration compatibility.

What dependencies are required to run this subagent?

You need the ms-mssql.mssql extension installed and active in VS Code. The subagent verifies this with #extensions before running queries.

Source text

ms-sql-dba.agent.md · MIT 
---
description: "Work with Microsoft SQL Server databases using the MS SQL extension."
name: "MS-SQL Database Administrator"
tools: ["search/codebase", "edit/editFiles", "githubRepo", "extensions", "runCommands", "database", "mssql_connect", "mssql_query", "mssql_listServers", "mssql_listDatabases", "mssql_disconnect", "mssql_visualizeSchema"]
---

# 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)

© github · MIT · github/awesome-copilot

Similar subagents

All subagents for Data and databases →
ai-engineer Seth Hobson This subagent designs LLM applications, RAG systems, and AI agents. Use it when a project needs vector search, model orchestration, or multimodal AI. CX Codex 7,687installs business-analyst Seth Hobson This subagent analyzes business data and helps shape KPIs, forecasts, and financial models. Use it to turn a business question into an analysis plan and recommendations. CX Codex 3,855installs sql-pro VoltAgent Community Subagent for optimizing complex SQL queries, designing database schemas, and fixing performance bottlenecks across PostgreSQL, MySQL, SQL Server, and Oracle. 3,602installs sql-pro Seth Hobson Helps design database schemas, inspect query plans, and tune SQL for OLTP and OLAP systems. Use it for database optimization or complex analysis. CX Codex 3,602installs data-scientist VoltAgent Community Subagent for exploratory data analysis, hypothesis testing, and building machine learning models directly in Claude Code. 3,342installs database-optimizer VoltAgent Community This subagent reviews slow queries, execution plans, and indexes. Use it when a database needs query, schema, or configuration tuning. 3,320installs

From the same set861

The whole set →
Oracle-to-PostgreSQL Migration Expert Guides .NET and C# application migrations from Oracle to PostgreSQL. Scans data access layers, scaffolds xUnit integration suites, and drafts migration plans. ★ 40,418repo stars one-shot-feature-issue-planner Converts a single feature request into a complete, issue-ready implementation plan without asking follow-up questions. ★ 40,418repo stars Expert Nuxt Developer Guides Nuxt 3 and Nitro development with TypeScript typing. Helps configure data fetching via useFetch, resolve hydration issues, and structure server routes. ★ 40,418repo stars New Relic Incident Response Agent A GitHub Copilot subagent that ties New Relic observability data to code changes so you can find the cause of a production incident. ★ 40,418repo stars Modernization Agent Exhaustive workspace assistant that inspects every business logic file, writes per-feature markdown docs, and outlines architecture migration plans. ★ 40,418repo stars Microsoft Study and Learn A guided tutor subagent for Microsoft and Azure technologies that uses hints instead of direct answers. Handy for exam prep and systematic learning. ★ 40,418repo stars Meta Agentic Project Scaffold Fetches prompts, instructions, and chat modes from awesome-copilot and structures them directly inside your project. ★ 40,418repo stars Sensei - Junior Mentor A Socratic mentor agent that guides junior developers through probing questions instead of handing out answers. It helps beginners understand code and debug issues independently. ★ 40,418repo stars

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor