跳到正文
TakoAPI
返回技能列表

sql-server-toolkit

由 sqlservr 提供

DevOps & Cloud
515下载量由 clawskills.sh 提供
0浏览量
0 个赞登录后即可为这个技能点赞
—暂无评分
你的评分

简介

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. 1

    Connects to the SQL Server instance using sqlcmd

  2. 2

    Issues a BACKUP DATABASE command targeting the specified database

  3. 3

    Writes the backup to the specified disk path with FORMAT and INIT options

  4. 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 或你在用的任意编程智能体里。

链接