Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add huangzt/my-agent-skills --skill mssql-toolsgit clone --depth 1 https://github.com/huangzt/my-agent-skillsWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/huangzt/my-agent-skills/mssql-tools)<a href="https://agentmods.dev/skills/huangzt/my-agent-skills/mssql-tools"><img src="https://agentmods.dev/badge/skills/huangzt/my-agent-skills/mssql-tools/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/huangzt/my-agent-skills/mssql-tools"><img src="https://agentmods.dev/badge/skills/huangzt/my-agent-skills/mssql-tools.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00093 | $0.00963 |
| Opus 5 | $0.00046 | $0.00481 |
| Sonnet 5 | $0.00019 | $0.00193 |
| Haiku 4.5 | $0.00009 | $0.00096 |
Grade B, and why
mssql-tools scanned grade B with 1 finding against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Asks for rootmediumPrivilege escalation
A mod that escalates privileges can change anything on the machine, not only the project.
- **Linux (Debian/Ubuntu)**: `sudo apt-get install freetds-dev` How it starts
The opening of the file, as written. The whole thing — 139 lines — stays where its author put it; the contents beside it link to each section on GitHub.
MSSQL 工具 Skill
用于操作 SQL Server 数据库的工具集，提供连接测试、表管理和 SQL 执行功能。
快速开始
前置要求
安装 Python 库：
pip install pymssql
平台特定依赖：
- Windows: 无需额外依赖
- macOS:
brew install freetds - Linux (Debian/Ubuntu):
sudo apt-get install freetds-dev
平台兼容性
- ✅ Windows
- ✅ macOS
- ✅ Linux
连接参数
所有脚本支持以下参数：
| 参数 | 说明 | 默认值 |
|---|---|---|
--server |
数据库服务器地址 | localhost |
--port |
数据库端口 | 1433 |
--user |
数据库用户名 | sa |
--password |
数据库密码 | 必填 |
--database |
数据库名称 | 必填 |
可用脚本
1. 测试数据库连接
验证数据库连接参数是否正确：
python scripts/mssql_connect.py --server 127.0.0.1 --port 1433 --user sa --password YOUR_PASSWORD --database YOUR_DB
2. 列出所有表
获取数据库中的所有表名：
python scripts/mssql_tables.py --server 127.0.0.1 --user sa --password YOUR_PASSWORD --database YOUR_DB
输出格式：表名列表，包含表类型（TABLE / VIEW）、Schema 和行数
3. 查看表结构
显示指定表的字段信息：
python scripts/mssql_schema.py --server 127.0.0.1 --user sa --password YOUR_PASSWORD --database YOUR_DB --table TABLE_NAME
可选指定 Schema：--schema dbo
输出格式：字段名、类型、是否可空、是否主键、默认值
4. 执行 SQL 查询
运行任意 SQL 语句：
python scripts/mssql_query.py --server 127.0.0.1 --user sa --password YOUR_PASSWORD --database YOUR_DB --query "SELECT TOP 10 * FROM users"
支持 SELECT、INSERT、UPDATE、DELETE 等所有 T-SQL 语句。
5. 查看数据库信息
获取数据库版本、大小等信息：
python scripts/mssql_info.py --server 127.0.0.1 --user sa --password YOUR_PASSWORD --database YOUR_DB
输出格式
所有脚本输出 JSON 格式数据，便于解析：
{
"success": true,
"data": [...],
"message": "操作成功"
}
错误时返回：
{
"success": false,
"error": "错误信息",
"message": "操作失败"
}
常见用例
探索新数据库
- 测试连接：
mssql_connect.py - 列出所有表：
mssql_tables.py - 查看关键表结构：
mssql_schema.py --table TABLE_NAME - 查询示例数据：
mssql_query.py --query "SELECT TOP 5 * FROM TABLE_NAME"
数据分析
- 获取表记录数：
mssql_query.py --query "SELECT COUNT(*) FROM TABLE_NAME" - 分析数据分布：
mssql_query.py --query "SELECT column, COUNT(*) FROM TABLE_NAME GROUP BY column"
What ships with it
6 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 12d ago First seen · 139 lines · 93 tokens per session scan B 3376da99b77a
mssql-tools is a skill published in the GitHub repository huangzt/my-agent-skills (20 stars, last pushed 8mo ago), licensed MIT. It adds 93 tokens to every session and 963 once invoked, about $0.0005 per session on Opus 5. A static security scan graded it B with 1 finding (asks for root). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other skills, from other repositories
database-expert
Advanced database design and administration for PostgreSQL, MongoDB, and Redis. Use when designing schemas, optimizing queries, managing database performance, or implementing data patterns.
clickhouse-architect
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.
imessage-query
Query macOS iMessage database (chat.db) via SQLite. Decode NSAttributedString messages, handle tapbacks, search conversations.
backtesting-py-oracle
Configuration and anti-patterns for using backtesting.py to validate ClickHouse SQL sweep results. Ensures bit-atomic replicability between SQL and Python trade evaluation.
ml-data-pipeline-architecture
Patterns for efficient ML data pipelines using Polars, Arrow, and ClickHouse. TRIGGERS - data pipeline, polars vs pandas, arrow format.
multi-agent-e2e-validation
Multi-agent parallel E2E validation for database refactors. TRIGGERS - E2E validation, schema migration testing, database refactor validation.