Skip to content
TakoAPI
Back to skills

sql-server-toolkit

by sqlservr

DevOps & Cloud
515Downloads reported by clawskills.sh
0Views
0 likesSign in to like this skill
—Not yet rated
Your rating

Brief

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

INPUT

User asks: Back up MyDatabase to a local file

AGENT
  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

OUTPUT

Database backup file created at C:\backup\MyDatabase.bak

Requirements

  • Microsoft SQL Server instance
  • sqlcmd utility installed

Installation

clawhub install sqlservr/sql-server-toolkit

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links