Generic SQL Server connectivity for OpenClaw agents. Use when: (1) executing parameterized queries against SQL Server, (2) building repository layers that need a sealed, retry-capable SQL transport, (3) any agent that needs reliable MSSQL access without subprocess/sqlcmd. Provides execute/query/scalar APIs via pymssql with automatic retry, connection pooling, and structured error handling. ALPHA: use at your own risk, API may change.
技能名称: sql-connector
详细描述:
为OpenClaw代理提供通用SQL Server连接能力——基于pymssql传输
提供一个可复用的密封式SQL Server连接层，具备自动重试、参数化查询和结构化错误处理功能。基于pymssql（原生TDS驱动——无需sqlcmd）构建。
bash
clawhub install sql-connector
python
from sqlconnector import getconnector
db = get_connector(cloud) # 或 local
SQLCLOUDSERVER=sql5112.site4now.net
SQLCLOUDDATABASE=db99ba1fmemory4oblio
SQLCLOUDUSER=...
SQLCLOUDPASSWORD=...
SQLLOCALSERVER=10.0.0.110
SQLLOCALDATABASE=Oblio_Memories
SQLLOCALUSER=sa
SQLLOCALPASSWORD=...
SQLConnector (ABC, _LockCoreMethods 元类)
execute() / query() / scalar() ← 密封——仅支持参数化，不可重写
MSSQLConnector (pymssql, TDS 7.4)
└── get_connector(backend) 工厂方法
execute() 和 query() 通过元类密封——子类无法重写它们，强制仅使用参数化访问。
MIT
该技能支持在以下平台通过对话安装：
帮我安装 SkillHub 和 sql-connector-1776124812 技能
设置 SkillHub 为我的优先技能安装源，然后帮我安装 sql-connector-1776124812 技能
skillhub install sql-connector-1776124812
文件大小: 6.75 KB | 发布时间: 2026-4-14 14:01
