sql-server-toolkit
oleh sqlservr
DevOps & CloudRingkasan
Command-line toolkit for Microsoft SQL Server.
Deskripsi
Apa yang Dilakukan Skill Ini
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.
Kapan Menggunakannya
- 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
Contoh Alur Kerja
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
Persyaratan
- Microsoft SQL Server instance
- sqlcmd utility installed
Instalasi
clawhub install sqlservr/sql-server-toolkitJalankan perintah CLI-nya, atau tempel prompt ke Claude Code, Cursor, Codex, atau coding agent apa pun yang Anda pakai.