skills.rest
larsnyg
larsnygCOMMUNITY
Explore all skills by this author →
GitHub

sql-server-admin

Automate SQL Server administration tasks including backups, security, and maintenance.

Updated Dec 20, 2025
Search Tags:#monitoring#security#maintenance#backup#index#admin#sql-server
One-click install
npx skills add https://github.com/larsnyg/claude-code-template-sql --skill sql-server-admin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-server-admin
Source: https://github.com/larsnyg/claude-code-template-sql/tree/main/.claude/skills/sql-server-admin
Command: npx skills add https://github.com/larsnyg/claude-code-template-sql --skill sql-server-admin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill covers SQL Server administration, backups, user management, performance monitoring, and maintenance tasks to keep databases healthy and secure.

Core Features & Use Cases

  • Backup and Restore Automation: Full/diff/log backups and restores.
  • Security & User Management: Create logins/users, grant permissions, roles.
  • Index Maintenance: Check fragmentation, rebuild/reorganize, update statistics.
  • Monitoring & Troubleshooting: Active sessions, running queries, wait stats.

Quick Start

Describe your SQL Server environment and I will provide an automated maintenance plan.

Frequently Asked Questions about sql-server-admin

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

FAQPage Schema
How do I automate SQL Server backups and restores?▼

Automate SQL Server backups by scheduling full, differential, and log backups using T-SQL BACKUP commands, then restore from those backups using RESTORE statements. This reduces manual effort and enables point-in-time recovery across your database instances.

What's the best way to manage SQL Server security and user permissions?▼

Manage SQL Server security by creating logins and users with CREATE LOGIN and CREATE USER, then assign permissions using GRANT and REVOKE commands tied to roles for role-based access control. This centralizes permission management and reduces human error in access provisioning.

How do I monitor SQL Server performance and troubleshoot slow queries?▼

Monitor SQL Server by querying active sessions, running queries, and wait statistics to identify bottlenecks. Use these insights to diagnose performance issues and guide index maintenance and query optimization decisions.

Why should I rebuild or reorganize SQL Server indexes regularly?▼

Rebuild or reorganize fragmented indexes by checking fragmentation levels and using maintenance commands, then update statistics to reflect data changes. This restores query performance and prevents degradation over time as tables grow and change.

Can I schedule maintenance tasks across multiple SQL Server instances?▼

Yes. Design and deploy a centralized maintenance plan that applies backup, restore, index maintenance, and monitoring tasks consistently across multiple SQL Server instances, reducing manual overhead and ensuring uniform database health.

Related Skills

Explore More Software Engineering Skills→
interflownexinterflownex
2

cloud-sql-sqlserver-lifecycle

Automate cloning, backup creation, and restoration for Cloud SQL for SQL Server instances.

Community
Intermediate
BagelHoleBagelHole
46

azure-monitor-audit

Configure Azure Monitor diagnostic settings to export activity logs to Log Analytics.

Community
Intermediate
rudi-bruchezrudi-bruchez

sqlserver-backup-recovery

Design SQL Server backup schedules and perform point-in-time restores with T-SQL scripts.

Community
Advanced
partme-aipartme-ai
610

cloud-azure-sql

Create, configure, secure, and manage Azure SQL databases.

Official
Intermediate