sql-server-toolkit
由 sqlservr 提供
DevOps & Cloud简介
Command-line toolkit for Microsoft SQL Server.
描述
该技能的功能
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.
何时使用
- 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
示例工作流
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
前置要求
- Microsoft SQL Server instance
- sqlcmd utility installed
安装
clawhub install sqlservr/sql-server-toolkit运行 CLI 命令,或把这段提示词粘贴到 Claude Code、Cursor、Codex 或你在用的任意编程智能体里。