← 返回 Skills 市场
sqlservr

sql-server-toolkit

作者 Ramesh Babu Vavilla · GitHub ↗ · v1.0.1
cross-platform ⚠ suspicious
988
总下载
0
收藏
4
当前安装
2
版本数
在 OpenClaw 中安装
/install sql-server-toolkit
功能描述
Command-line tools for SQL Server schema creation, migrations, index management, performance diagnostics, backups, restores, and bulk data import/export.
使用说明 (SKILL.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;

安全使用建议
This package appears to be a straightforward SQL Server CLI toolkit (migration scripts, backup/diagnostic examples) and the SQL files provided look benign. However, before installing or running anything: 1) note that the skill's metadata does not declare that sqlcmd and bcp are required even though the docs require them — ensure those tools are installed from trusted sources; 2) do not run the example commands against production databases — test in an isolated environment first; 3) avoid using the 'sa' account or putting passwords on the command line (use Windows Authentication or secure credential mechanisms) because command-line passwords can be exposed to other system users and logs; 4) verify and, if needed, change the backup path (C:\backup) to a secure location with appropriate permissions; 5) review each migration/SQL script before execution to ensure it performs only the operations you expect. The main issue is inconsistency around required tools and credential handling — fixing those (declare required binaries, recommend secure auth patterns) would reduce the security concerns.
功能分析
Type: OpenClaw Skill Name: sql-server-toolkit Version: 1.0.1 The skill bundle provides standard SQL Server management capabilities and examples, including schema creation, migrations, performance diagnostics, and database backup. All commands and SQL scripts are consistent with the stated purpose of a 'SQL Server Toolkit'. There is no evidence of data exfiltration, malicious execution, persistence mechanisms, prompt injection attempts against the agent, or obfuscation. The backup command writing to a specific disk path is a standard SQL Server operation and does not indicate malicious intent within the skill itself, but rather demonstrates a legitimate function.
能力评估
Purpose & Capability
The name, README, SKILL.md, and included SQL scripts are coherent with a SQL Server toolkit. However, the registry metadata lists no required binaries or env vars while the documentation explicitly expects sqlcmd and bcp; that's an omission that doesn't align with the stated purpose.
Instruction Scope
The SKILL.md instructs only local SQL Server interactions (sqlcmd, backup to local disk, running provided scripts). It does not instruct reading unrelated system files or posting data to external endpoints. Instructions are concrete and limited to DB management tasks.
Install Mechanism
This is an instruction-only skill with no install spec or downloaded code; nothing will be written to disk by an installer. Files in the package are static SQL and docs.
Credentials
No environment variables or credentials are declared, yet SKILL.md shows example commands that use authentication (e.g., -U sa -P YourPassword) and recommends sqlcmd and bcp. That omission is disproportionate: the skill expects credentials and specific tools but doesn't declare them, and it demonstrates passing passwords on the command line (which exposes secrets to process listings).
Persistence & Privilege
The skill is not always-enabled, does not request system-wide changes, and has no install steps that modify other skills or global settings. It does not request elevated or persistent privileges itself.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install sql-server-toolkit
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /sql-server-toolkit 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.1
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.
v1.0.0
Initial release of SQL Server Toolkit. - Command-line toolkit for Microsoft SQL Server. - Supports schema creation, versioned migrations, index management, performance diagnostics, backup & restore, and bulk import/export. - Includes usage examples for connection, running scripts, table creation, indexing, backup, and performance monitoring.
元数据
Slug sql-server-toolkit
版本 1.0.1
许可证
累计安装 4
当前安装数 4
历史版本数 2
常见问题

sql-server-toolkit 是什么?

Command-line tools for SQL Server schema creation, migrations, index management, performance diagnostics, backups, restores, and bulk data import/export. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 988 次。

如何安装 sql-server-toolkit?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install sql-server-toolkit」即可一键安装,无需额外配置。

sql-server-toolkit 是免费的吗?

是的,sql-server-toolkit 完全免费(开源免费),可自由下载、安装和使用。

sql-server-toolkit 支持哪些平台?

sql-server-toolkit 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 sql-server-toolkit?

由 Ramesh Babu Vavilla(@sqlservr)开发并维护,当前版本 v1.0.1。

💬 留言讨论