sql-server-toolkit
by sqlservr
DevOps & CloudBrief
Command-line toolkit for Microsoft SQL Server.
Description
What This Skill Does
Command-line toolkit for Microsoft SQL Server. Covers schema creation, versioned migrations, index management, performance diagnostics, and backup and restore operations via sqlcmd.
Consolidates common SQL Server administrative tasks into a single CLI workflow, removing the need to switch between SSMS, custom scripts, and separate backup utilities.
When to Use It
- Running a versioned migration against a staging database before deployment
- Diagnosing slow queries using IO and time statistics
- Creating a full database backup before a major release
- Bulk importing CSV data into a production table
- Adding indexes to optimize frequently queried columns
Example Workflow
User asks: Back up MyDatabase to a local file
- 1
Connects to the SQL Server instance using sqlcmd
- 2
Issues a BACKUP DATABASE command targeting the specified database
- 3
Writes the backup to the specified disk path with FORMAT and INIT options
- 4
Confirms successful backup completion
Database backup file created at C:\backup\MyDatabase.bak
Requirements
- Microsoft SQL Server instance
- sqlcmd utility installed
Installation
clawhub install sqlservr/sql-server-toolkitRun the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.