sql-server-toolkit
v1.0.1SQL Server命令行工具，支持架构创建与迁移、索引管理、性能诊断、备份恢复及批量数据导入导出。
Sourced from ClawHub,
Authored by Ramesh Babu Vavilla
Installation
Please help me install the skill `sql-server-toolkit` from SkillHub official store.
npx skills add sqlservr/sql-server-toolkit
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:backupMyDatabase.bak' WITH FORMAT, INIT;
Performance Diagnostics
SET STATISTICS IO ON; SET STATISTICS TIME ON;