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 Jay-ssr/skillrunner-market --skill sqlsugar-guidegit clone --depth 1 https://github.com/Jay-ssr/skillrunner-marketWrote 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/jay-ssr/skillrunner-market/sqlsugar-guide)<a href="https://agentmods.dev/skills/jay-ssr/skillrunner-market/sqlsugar-guide"><img src="https://agentmods.dev/badge/skills/jay-ssr/skillrunner-market/sqlsugar-guide/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/jay-ssr/skillrunner-market/sqlsugar-guide"><img src="https://agentmods.dev/badge/skills/jay-ssr/skillrunner-market/sqlsugar-guide.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.00062 | $0.01126 |
| Opus 5.5 | $0.00025 | $0.00450 |
| Sonnet 5.5 | $0.00012 | $0.00225 |
| Haiku 4.5 | $0.00006 | $0.00113 |
Grade A, and why
sqlsugar-guide scanned grade A with 0 findings 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 2mo 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.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 84 lines — stays where its author put it; the contents beside it link to each section on GitHub.
SqlSugar 知识库
系统自动参考，用户不可调用。
定位流程
- 按主题目录定位：basics、query、write、dynamic、runtime、database
- 按「高价值入口」精确读取 1-2 个文件
- 跨主题时才读多个文件，优先高价值入口
Topic Routing
| 目录 | 主题 |
|---|---|
basics/ |
安装、SqlSugarClient/Scope、连接配置/池、实体映射、ValueObject、鉴别器、EntityMaintenance、DbFirst、CodeFirst、表结构管理 |
query/ |
Where、Select、分页、排序、分组/去重、报表、SqlFunc、联表、子查询、导航查询、树型、并集、动态条件、跨库 |
write/ |
插入、更新、删除、保存、批量写入、导入/验证、雪花ID、导航增删改 |
dynamic/ |
无实体 CRUD、Ado 原生 SQL、动态类、Json2Sql、字符串表达式 |
runtime/ |
事务、锁、异步、并发、多库、缓存、读写分离、分表、多租户、IOC、仓储、UOW、AOP、查询过滤器、SQL注入防护、Aspire |
database/ |
厂商特有行为、通用配置、类型映射、JSON/枚举处理、自定义转换 |
高价值入口
架构选型
- SqlSugarClient vs SqlSugarScope →
basics/02→ 按需加03或04 - 单例模式 →
runtime/17（含错误写法）；IOC 示例可加basics/04 - IOC 注入 →
runtime/18
实体建模
- 实体配置：
basics/07(内置) →08(自定义) →09(无特性) →10(完整示例) - ValueObject/鉴别器/实体管理：
basics/11、12、13
代码生成
- CodeFirst →
basics/17→ 按需加18(配置)、19(表结构)、20(数据库差异) - DbFirst →
basics/14→ 按需加15(Razor)、16(自定义生成器)
查询
- 基础
01、条件02、投影03、分页04、函数08 - 联表
12、导航15、子查询13
写入
- 插入
01、更新02、删除03、批量05、保存04
故障排查
- 偶发错误/线程安全 →
runtime/06 - 常见报错 →
runtime/23；版本要求 →runtime/24 - 数据库连接报错 → 对应
database/XX的"注意事项"
AOP/过滤器
- AOP+日志拦截 →
runtime/25 - 查询过滤器 →
runtime/26（与query/21重复，读一个即可）
冗余文件（只读一个）
runtime/17↔basics/04— 单例读runtime/17，IOC 示例读basics/04runtime/26≈query/21— 优先runtime/26runtime/25末尾含过滤器概述，详细仍读runtime/26
API 模式速查
CodeFirst|InitTables|MoreSettings→ basics/Queryable|Where|Select|Join|Subqueryable|Includes→ query/Insertable|Updateable|Deleteable|Storageable|Fastest→ write/Ado|SqlQuery|ExecuteCommand|DynamicBuilder→ dynamic/BeginTran|UseTran|Tenant|SplitTable|Aop|QueryFilter→ runtime/
回答规则
- 保留 SqlSugar 类型名/API 名原样，不翻译不缩写
- 代码示例用 C#，遵循官方命名风格
- 依赖数据库引擎时标注引用的数据库文件
- 跨主题基于最小必要文件作答
- 信息不足时说明，不编造 API
- 版本敏感功能标注最低版本（如
5.1.4.63+） - 报错优先引导至
runtime/06+runtime/23
What ships with it
60 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.
- references/architecture/01_核心架构与类关系.md 3.4 KB
- references/architecture/02_方法调用链.md 4.2 KB
- references/architecture/03_隐藏API与高级配置.md 6.5 KB
- references/architecture/04_接口体系与扩展点.md 10 KB
- references/architecture/05_已废弃API与迁移指南.md 4.2 KB
- references/basics/01_安装教程.md 834 B
- references/basics/02_入门必看.md 4.3 KB
- references/basics/03_SqlSugarClient_原生模式.md 2.7 KB
- references/basics/04_SqlSugarScope_单例模式.md 3.7 KB
- references/basics/05_连接配置.md 3.0 KB
- references/basics/06_连接池原理.md 4.0 KB
- references/basics/07_实体配置_内置特性.md 2.6 KB
- references/basics/08_实体配置_自定义特性.md 1.6 KB
- references/basics/09_实体配置_无特性配置.md 2.8 KB
- references/basics/10_完整实体建模示例.md 662 B
- references/basics/11_ValueObject_值对象.md 2.3 KB
- references/basics/12_鉴别器.md 2.5 KB
- references/basics/13_实体管理.md 987 B
- references/basics/14_DbFirst_与实体生成.md 4.7 KB
- references/basics/15_Razor模版生成.md 4.1 KB
- references/basics/16_自定义生成器.md 380 B
- references/basics/17_CodeFirst_快速开始.md 770 B
- references/basics/18_CodeFirst_相关配置.md 1.3 KB
- references/basics/19_表结构管理.md 26 KB
- references/basics/20_CodeFirst_数据库差异.md 1.5 KB
- references/database/01_MySQL.md 6.4 KB
- references/database/02_MySqlConnector.md 501 B
- references/database/03_SqlServer.md 4.0 KB
- references/database/04_PostgreSQL.md 4.9 KB
- references/database/05_Oracle.md 6.3 KB
- references/database/06_SQLite.md 3.9 KB
- references/database/07_达梦.md 1.9 KB
- references/database/08_人大金仓.md 3.4 KB
- references/database/09_瀚高数据库.md 1.3 KB
- references/database/10_神通数据库.md 575 B
- references/database/11_华为GaussDB.md 2.2 KB
- references/database/12_Vastbase.md 1.3 KB
- references/database/13_虚谷数据库.md 190 B
- references/database/14_ClickHouse.md 1.4 KB
- references/database/15_TDengine.md 3.4 KB
- references/database/16_MongoDB.md 3.8 KB
- references/database/17_QuestDb.md 2.7 KB
- references/database/18_DuckDB.md 528 B
- references/database/19_Access.md 936 B
- references/database/20_DB2.md 143 B
- references/database/21_Doris.md 736 B
- references/database/22_GBase.md 1.2 KB
- references/database/23_GoldenDB.md 483 B
- references/database/24_HANA.md 130 B
- references/database/25_OceanBase.md 1.6 KB
- references/database/26_ODBC.md 1.1 KB
- references/database/27_PolarDB.md 512 B
- references/database/28_TDSQL.md 967 B
- references/database/29_TiDB.md 573 B
- references/database/30_Sql中间管道.md 1.5 KB
- references/database/31_通用配置.md 1.2 KB
- references/database/32_数据类型映射.md 921 B
- references/database/33_DbType_枚举值汇总.md 1.0 KB
- references/database/34_常见问题汇总.md 738 B
- references/database/35_JSON_类型处理.md 3.3 KB
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.
- 2mo ago First seen · 84 lines · 62 tokens per session scan A 1c4934f1d3c3
sqlsugar-guide is a skill published in the GitHub repository Jay-ssr/skillrunner-market (2 stars, last pushed 5mo ago), licensed MIT. It adds 62 tokens to every session and 1,126 once invoked, about $0.0002 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
sqlsugar-guide compared with skills from other repositories
| Mod | Type | Stars | Last push | Licence | Scan | Tokens | Works with |
|---|---|---|---|---|---|---|---|
| sqlsugar-guideJay-ssr/skillrunner-market | Skill | 2 | 5mo ago | MIT | A | 62 | Claude Code |
| optimizing-ef-core-queriesdotnet/skills | Skill | 5.8k | today | MIT | A | 116 | Claude Code |
| azure-resource-manager-postgresql-dotnetmicrosoft/skills | Skill | 3.2k | yesterday | MIT | A | 97 | Claude Code |
| efcore-patternsAaronontheweb/dotnet-skills | Skill | 1.3k | 10d ago | MIT | A | 35 | Claude Code |
| ef-corecodewithmukesh/dotnet-claude-kit | Skill | 807 | 3d ago | MIT | A | 113 | Claude Code |
| migratecodewithmukesh/dotnet-claude-kit | Skill | 807 | 3d ago | MIT | A | 82 | Claude Code |
| entity-framework-coremanagedcode/dotnet-skills | Skill | 509 | today | MIT | A | 110 | Claude Code, Codex |