SqloptSAFE
一个能持续增强本地开源模型的cli,专门为本地部署模型优化的coding窗口。目前仍然处于mvp未能大规模测试和端到端跑通,欢迎指正🙏🏻🙏🏻🙏🏻
Overview
一个能持续增强本地开源模型的cli,专门为本地部署模型优化的coding窗口。目前仍然处于mvp未能大规模测试和端到端跑通,欢迎指正🙏🏻🙏🏻🙏🏻
55367f81de56OBSERVED · 2026-10-13What it tells the agent
The instruction file, verbatim from the audited commit — this is the text the model reads, and the surface the audit's instruction layer examines. Quoted here so you can judge it without cloning anything.
--- name: SQLOptExpert version: 1.0.0 trigger_keywords: [sql优化, 慢查询, explain, 索引, sql性能] trigger_min_confidence: 0.7 pipeline: [locator, generator, verifier] lifecycle: mature --- ## 领域知识 - EXPLAIN分析:关注type列(ALL全表扫描→需优化,ref/range/const为佳)、rows估算、Extra中的Using filesort/temporary - 索引设计:WHERE条件列建索引,联合索引遵循最左前缀原则,区分度高的列放前面 - 覆盖索引:SELECT的列都在索引中,避免回表(Extra显示Using index) - 避免索引失效:不在索引列上用函数/运算、不用前导%LIKE、注意隐式类型转换 - 子查询改JOIN:IN子查询改为INNER JOIN,EXISTS改为LEFT JOIN + IS NOT NULL判断 - 分页优化:深分页用WHERE id > last_id LIMIT n代替OFFSET,或延迟关联 - 批量操作:INSERT用批量VALUES(每批500-1000条),UPDATE用CASE WHEN批量 - COUNT优化:COUNT(*)让引擎选最小索引,不要COUNT(列名)除非需排除NULL - 大表JOIN:确保JOIN字段有索引且类型一致,小表驱动大表 - 锁优化:长事务拆短、避免SELECT...FOR UPDATE范围过大 ## 经验规则(自动生成)
Trust audit
SAFEgrade B · trust 89/100 Nothing in the source contradicts what it says it does. Grade A is reserved for packages that have also passed the behavioural sandbox.
| Layer | What it checks | Result |
|---|---|---|
| L0 | Provenance & inventory | PASS |
| L1 | Static analysis of the code | NA |
| L2 | Instruction surface (what it tells the agent) | PASS |
| L3 | Class-specific surface | PASS |
| L4 | Behavioural (sandbox) | SKIPPED |
What the source does
- Filesystem
- none-observed
- Network
- none-observed
- Shell
- none-observed
- Dependencies
- pinned
- Secrets in source
- none-found
Findings (1)
Gates applied: no_behavioural_pass, no_license.
55367f81de56full audit observations/trust-audit/skill/val1813__sqlopt.json · Report an issue / request a re-scanAudit history
Every audit this skill has had.
| Date | Source | Verdict | Grade | Score | Change |
|---|---|---|---|---|---|
| 2026-10-13 | 55367f81de56 | SAFE | B | 89 | first audit |
Questions
What does the Sqlopt skill do?
一个能持续增强本地开源模型的cli,专门为本地部署模型优化的coding窗口。目前仍然处于mvp未能大规模测试和端到端跑通,欢迎指正🙏🏻🙏🏻🙏🏻
Is Sqlopt safe to install?
The audit found nothing in the source that contradicts what it says it does, and graded it B (89/100). Grade A is held back for packages that have also passed a sandboxed behavioural run, which is why a clean skill reads B.
What can Sqlopt access on my machine?
The audit observed no filesystem, network or shell use at all in its source.
How current is this page?
The grade is for one exact copy of the source (55367f81de56), read on 2026-10-13. The repository is watched, and a new audit runs when it changes — this is the first audit.