Ms SQL Dba — Agent Skill by GitHub

From the author

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

— the description by aaronpowell

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

The MS-SQL Database Administrator skill enables an AI agent to interact with Microsoft SQL Server instances. By leveraging the ms-mssql.mssql extension, the agent can connect to servers, execute T-SQL queries, visualize database schemas, and perform administrative tasks such as configuration, security auditing, and performance tuning.

What it does

Connects to and manages Microsoft SQL Server instances and databases
Executes and optimizes T-SQL queries and stored procedures
Visualizes database schemas for better understanding of data structures
Assists with database backups, restores, and disaster recovery planning
Implements and audits security configurations including roles and permissions
Reviews database compatibility and identifies deprecated features

When to use it

When you need to perform administrative tasks on a Microsoft SQL Server database
When you need to write or troubleshoot complex T-SQL queries
When you need to audit security settings or user permissions
When you need to visualize the schema of your database
When preparing for database upgrades or migrations

Advantages

Direct integration with the MS SQL extension for VS Code
Provides specialized expertise in MS-SQL management and maintenance
Facilitates database schema visualization
Supports security and performance tuning best practices

Usage examples

“Connect to my local SQL Server instance and list all available databases.”: The agent uses the mssql_connect and mssql_listDatabases tools to establish a connection and display the list of databases.
“Visualize the schema for the Sales database.”: The agent uses the mssql_visualizeSchema tool to generate a visual representation of the database structure.

Install

Download the custom agent as a ZIP:
https://autogineer.com/agent-skills/github/ms-sql-dba/download

Extract the agent file into .github/agents, then commit it:

mkdir -p .github/agents && unzip -j ms-sql-dba.zip 'ms-sql-dba/ms-sql-dba.agent.md' -d .github/agents

Keep the LICENSE and ATTRIBUTION.md files from the ZIP with your copy.

Documentation by aaronpowell

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

Files

ATTRIBUTION.mdAdded by AutoGineer868 B
LICENSELicence file added by AutoGineer1.0 KiB
ms-sql-dba.agent.md2.2 KiB

Requirements and compatibility

Written for: GitHub Copilot

Works with: GitHub Copilot

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Anndata
K-Dense· Community
A Python framework for managing annotated data matrices in single-cell genomics and general research workflows.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Liteparse
K-Dense· Community
Local document and PDF parsing with spatial text extraction and bounding box support.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
Apache-2.0Low riskHas scriptsGitHub stars of the source repository56.4k
Usfiscaldata
K-Dense· Community
Access U.S. Treasury federal financial data via the Fiscal Data REST API.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Geopandas
K-Dense· Community
Guidance and local audit tools for Python workflows using GeoPandas 1.2.0 for spatial data analysis.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Markitdown
K-Dense· Community
A lightweight utility for converting diverse document formats into structured Markdown for analysis, search, and LLM ingestion.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Zarr Python
K-Dense· Community
A guide for storing and querying chunked N-D scientific arrays using Zarr-Python 3.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k