Setup & Installation
Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:
Version History
Initial release of the SQL Server Toolkit. - Supports schema creation, versioned migrations, index management, performance diagnostics, backup & restore, and bulk data operations. - Includes example SQL commands for common tasks such as connecting, running scripts, table creation, indexing, and backups. - Provides performance diagnostic commands using STATISTICS IO and TIME.
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
Here's how your AI assistant might use this skill in practice.
User asks: Back up MyDatabase to a local file
- 1Connects to the SQL Server instance using sqlcmd
- 2Issues a BACKUP DATABASE command targeting the specified database
- 3Writes the backup to the specified disk path with FORMAT and INIT options
- 4Confirms successful backup completion
Database backup file created at C:\backup\MyDatabase.bak
Requirements
Accounts, API keys, or tools you or your AI assistant may need to set up while using this skill.