skills.rest
leocosta
leocostaCOMMUNITY
Explore all skills by this author →
𝕏@leoccostaGitHub

dba-mssql

Analyze MSSQL database artifacts and apply deterministic T-SQL fixes for performance and security issues.

4|Updated Mar 21, 2026
Search Tags:#automation#security#indexing#query-tuning#sql-server#mssql#database-performance
One-click install
npx skills add https://github.com/leocosta/octopus --skill dba-mssql-leocosta
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-mssql
Source: https://github.com/leocosta/octopus/tree/main/skills/dba-mssql
Command: npx skills add https://github.com/leocosta/octopus --skill dba-mssql-leocosta

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

MSSQL performance and security issues can degrade application reliability and increase operational risk.

Core Features & Use Cases

  • Detects indexing, modeling, query, migration, retention, capacity, security, and concurrency problems specific to SQL Server; each finding is accompanied by a deterministic T-SQL fix.
  • Optional live enrichment via MSSQL_CONNECTION_STRING to query system views like sys.indexes, sys.dm_db_missing_index_details, and sp_spaceused for deeper insights.
  • Provides a structured findings output suitable for integration into audits, code reviews, and deployment pipelines.

Quick Start

Run the dba-mssql skill in your MSSQL projects to analyze and fix common SQL Server issues.

Frequently Asked Questions about dba-mssql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect and fix SQL Server indexing and query tuning issues?▼

SQL Server indexing and query tuning issues are detected by applying a static heuristics catalogue to database artifacts, generating structured findings with deterministic T-SQL fixes for immediate remediation.

What is the best way to automate MSSQL performance and security audits?▼

MSSQL performance and security audits are automated by analyzing database artifacts for indexing, modeling, and concurrency problems, outputting structured findings suitable for integration into code reviews and deployment pipelines.

Can I use a live connection string to query missing index details in MSSQL?▼

Yes, you can set the MSSQL_CONNECTION_STRING environment variable to enable live queries against system views like sys.dm_db_missing_index_details and sys.indexes for deeper enrichment during analysis.

Does this approach work with both on-premises and cloud SQL Server deployments?▼

Yes, the analysis applies to DBA workflows across both on-premises and cloud SQL Server deployments, covering capacity planning, retention, and security audits without deployment-specific limitations.

How do I remediate concurrency and security problems in SQL Server?▼

Concurrency and security problems in SQL Server are remediated by applying targeted T-SQL fixes generated from the static heuristics catalogue, addressing each identified vulnerability or bottleneck deterministically.

Why does my SQL Server database need a static heuristics catalogue for capacity planning?▼

A static heuristics catalogue is needed for capacity planning to systematically identify retention and modeling problems across database artifacts, ensuring structured findings and deterministic fixes before operational risk increases.

Related Skills

Explore More Software Engineering Skills→
wfukatsuwfukatsu
12

analyze-oracle-schema

Analyze Oracle database schemas and generate a Markdown report.

Community
Advanced
DieStokDieStok

ce-code-review

Orchestrate multi-agent code review workflows and aggregate findings into merge-ready reports.

Community
Advanced
interflownexinterflownex
2

alloydb-omni-performance

Analyze PostgreSQL query execution plans and table statistics in AlloyDB Omni.

Community
Advanced
bcastelinobcastelino
2

code-reviewer

Analyze pull requests for security vulnerabilities and performance issues.

Community
Advanced