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 | $0.00031 | $0.00563 |
| Sonnet 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 9d 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.
- 9d 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 3mo ago), licensed MIT. It adds 62 tokens to every session and 1,126 once invoked, about $0.0003 per session on Opus 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.
Other skills, from other repositories
azure-resource-manager-postgresql-dotnet
Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL", "PostgreSqlFlexibleServer", "PostgreSQL Flexible Server", "Azure Database for…
optimizing-ef-core-queries
Optimize and improve the performance of slow Entity Framework Core (EF Core) queries: make them generate less SQL, make fewer database round-trips, and return results faster. Use whenever an EF Core or DbContext query or data-access path is slow or should be made faster — whether or not EF Core owns the database…
entity-framework-core
Design, tune, or review EF Core data access with proper modeling, migrations, query translation, performance, and lifetime management for modern .NET applications. USE FOR: DbContext, migrations, model configuration, EF queries, tracking, loading, performance, transactions, and EF6 migration decisions. DO NOT USE FOR…
efcore-patterns
Entity Framework Core best practices including NoTracking by default, query splitting for navigation collections, migration management, dedicated migration services, and common pitfalls to avoid.
entity-framework6
Maintain or migrate EF6-based applications with realistic guidance on what to keep, what to modernize, and when EF Core is or is not the right next step. USE FOR: EF6 codebases; runtime versus ORM migration decisions; EDMX, code-first, ObjectContext, and legacy data-access review. DO NOT USE FOR: unrelated stacks…
ef-core
Entity Framework Core patterns for .NET 10. Covers DbContext configuration, migrations workflow, interceptors, compiled queries, ExecuteUpdateAsync, ExecuteDeleteAsync, value converters, and query optimization. Load this skill when working with databases, writing queries, managing schema changes, or when the user…