sqlservr-sql-server-toolkit

ClawSkills 作者 clawskills

安装 / 下载方式

TotalClaw CLI推荐

totalclaw install clawskills:clawskills~sqlservr-sql-server-toolkit

cURL直接下载，无需登录

curl -fsSL https://skills.taituai.com/api/skills/clawskills%3Aclawskills~sqlservr-sql-server-toolkit/file -o sqlservr-sql-server-toolkit.md

# SQL Server Toolkit

Command-line toolkit for Microsoft SQL Server.

## Capabilities
- Schema creation
- Versioned migrations
- Index management
- Performance diagnostics
- Backup & restore
- Bulk import/export

## Connect
sqlcmd -S localhost -E
sqlcmd -S localhost -U sa -P YourPassword

## Run Script
sqlcmd -S localhost -d MyDatabase -i script.sql

## Example Table
CREATE TABLE Users (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    Email NVARCHAR(255) NOT NULL UNIQUE,
    Name NVARCHAR(100) NOT NULL,
    CreatedAt DATETIME2 DEFAULT SYSDATETIME()
);

## Example Index
CREATE INDEX IX_Users_Email ON Users(Email);

## Backup Example
BACKUP DATABASE MyDatabase
TO DISK = 'C:\backup\MyDatabase.bak'
WITH FORMAT, INIT;

## Performance Diagnostics
SET STATISTICS IO ON;
SET STATISTICS TIME ON;