A comprehensive diagnostic and management toolkit for SQL Server performance tuning and database administration using automated T-SQL workflows.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-server-skills
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install sql-server-skills using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL Server Skills?
The SQL Server Openclaw Skills package provides a robust framework for AI agents to interact directly with Microsoft SQL Server instances. By leveraging the sqlcmd utility and a deep library of Dynamic Management Views (DMVs), this skill enables automated performance bottleneck detection, schema management, and real-time monitoring. It functions as a virtual DBA, capable of interpreting complex execution plans and identifying resource-heavy queries to ensure high availability and optimal throughput.
Designed for modern database environments, these Openclaw Skills allow for safe, read-only diagnostic gathering alongside controlled DDL operations. The skill architecture is segmented into specialized sub-skills, ensuring that the AI agent can transition seamlessly between high-level server health checks and granular query-level optimization tasks without manual intervention.
SQL Server Skills Use Cases
- Identifying and resolving server-wide performance bottlenecks using wait statistics.
- Tuning specific slow queries by analyzing XML execution plans and IO/Time statistics.
- Maintaining database health through missing index identification and fragmentation analysis.
- Managing schema migrations and DDL changes safely within a devops pipeline.
- Investigating database blocking, deadlocks, and long-running transactions.
How SQL Server Skills Works
- The agent establishes a connection to the SQL Server instance using provided credentials via the sqlcmd utility.
- Diagnostic scripts are executed against system DMVs to gather metadata about server state, resource consumption, and query performance.
- The Openclaw Skills logic analyzes the returned datasets to identify specific issues such as memory pressure, I/O latency, or lock contention.
- Based on the findings, the agent suggests or applies remediation steps like index creation, query rewrites, or statistics updates.
- Detailed logs, execution plans, and performance metrics are generated for human review to ensure operational safety and compliance.
SQL Server Skills Setup
To deploy these Openclaw Skills, ensure the host environment has the sqlcmd utility installed and network access to the target SQL Server (port 1433).
# Install sqlcmd (example for Ubuntu/Debian)
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list | sudo tee /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools unixodbc-dev
# Configure environment variables for the Openclaw Skills
export SQL_SERVER="your-server-address"
export SQL_USER="your-username"
export SQL_PASSWORD="your-password"
# Test connectivity
sqlcmd -S "$SQL_SERVER" -U "$SQL_USER" -P "$SQL_PASSWORD" -Q "SELECT @@VERSION"
SQL Server Skills Data Schema & Taxonomy
The Openclaw Skills manage data through structured T-SQL outputs and metadata tables:
| Component | Organization | Purpose |
|---|---|---|
| Wait Stats | Key-Value Pair | Identifies system-level resource bottlenecks |
| Index Metadata | Tabular Data | Details fragmentation, usage, and missing index impact |
| Execution Plans | XML / String | Maps the logical and physical execution of queries |
| Blocking Tree | Hierarchical | Visualizes session relationships to find head blockers |
| Job History | Chronological | Tracks success/failure of SQL Agent maintenance tasks |
SQL Server Skills Advanced Features
- Automated interpretation of complex XML execution plans to spot expensive operators like table scans.
- Hierarchical blocking analysis within the Openclaw Skills to identify root-cause sessions in deadlock scenarios.
- Integrated index lifecycle management including automated fragmentation checks and unused index tracking.
- Support for both Windows Authentication and SQL Authentication for flexible enterprise deployment.
- Advanced T-SQL anti-pattern detection to fix common performance issues in stored procedures and views.
SKILL.md
Loading
Related Openclaw Skills
GitLab CLI Skills
A comprehensive routing skill for managing GitLab repositories, CI/CD pipelines, and merge requests via the GitLab CLI (glab).
MOL Instant Messenger
An AIM-themed real-time chat platform allowing AI agents to join topic-based rooms and interact with other bots using Socket.IO.
Discord Local STT & TTS Installer
A macOS-exclusive installer for the discord-local-stt-tts plugin that enables private, local speech recognition and synthesis for Discord voice assistants.
Trading Signal
A specialized utility for subscribing to and retrieving real-time on-chain Smart Money trading signals across multiple blockchains.
WhatsApp Automation with AI Alerts
An AI-driven automation skill that monitors WhatsApp messages to provide intelligent Telegram alerts and calendar scheduling suggestions.
WhatsApp Analyzer
Automate the detection of appointments and urgent messages from WhatsApp with integrated Telegram alerts and Google Calendar syncing.
Featured*
