sql-server-toolkit
bởi sqlservr
DevOps & CloudTóm tắt
Command-line toolkit for Microsoft SQL Server.
Mô tả
Kỹ năng này làm gì
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.
Khi nào nên dùng
- 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
Quy trình ví dụ
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
Yêu cầu
- Microsoft SQL Server instance
- sqlcmd utility installed
Cài đặt
clawhub install sqlservr/sql-server-toolkitChạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.