Loading the registry…
Guides aggregation correctness — every column in the SELECT list of a grouped query must be either named in GROUP BY or wrapped in an aggregate (the functional-dependency rule), because a non-grouped, non-aggregated column has no single value per group. Bans the "ambiguous groups" antipattern that errors on standard-conformant engines but silently returns an arbitrary row's value on MySQL with ONLY_FULL_GROUP_BY disabled. Auto-invokes when writing or editing GROUP BY/HAVING, aggregate functions (SUM/COUNT/AVG/MIN/MAX), FILTER, LISTAGG/STRING_AGG/GROUP_CONCAT/ARRAY_AGG, ROLLUP/CUBE/GROUPING SETS, percentile/WITHIN GROUP, or any multi-level subtotal report, and on "only_full_group_by" / "must appear in the GROUP BY clause" / "subtotal" / "rollup" requests.
Claude Skills are markdown + scripts loaded into Claude Code; scanned with the same pipeline.
We found this by crawling public sources and nobody has attested to it. That is how most of the registry gets here, and it is not a mark against the artifact — it only means no authenticated act of publication is on record. An artifact can be the vendor's own and still appear here.
Claude Skills install to a single target, no runtime picker.
nerlo install -- 'ctoth/sql-skills-plugin (sql-aggregation-and-grouping)'
Manual alternative: copy the skill folder into ~/.claude/skills/ so Claude Code loads it on next launch.
cp -r -- 'ctoth/sql-skills-plugin (sql-aggregation-and-grouping)' ~/.claude/skills/
Install respects the composite badge: Clean proceeds, Caution prompts for confirmation, and Flagged is refused. Write operations require an API token.
3 of 11 scanners examined this package. The rest do not apply to it — language, ecosystem and packaging decide which analyzers can say anything, and a scanner that cannot examine an artifact reports nothing rather than passing it.
v2.0.11
105 findings · 13.0s
v0.3.74
8 findings · 2.7s
v0.1.0
0 findings · 4.0s
v1.4.0
None of the entry points this scanner reads were found in this artifact. What each scanner covers
0 findings · 0.3s
v0.1.0
No source files this scanner can analyze were found in this artifact. What each scanner covers
0 findings · 4.0s
vv0.3.2
No Go packages were found in this artifact. What each scanner covers
0 findings · 0.1s
v0.1.0
This scanner found nothing in this artifact that it assesses. What each scanner covers
0 findings · 1.2s
v0.71.0
No dependency manifest or lockfile was found in this artifact. What each scanner covers
0 findings · 0.2s
v2.3.8
No dependency manifest or lockfile was found in this artifact. What each scanner covers
0 findings · 0.2s
v0.71.0
No container image was published for this artifact. What each scanner covers
0 findings · 0.0s
vv1.6.0
No Go modules were found in this artifact. What each scanner covers
0 findings · 0.1s
1 scan on record. Every scan's full results are retained immutably for 24 months.
| Completed | Composite | Change | Scanners | Status |
|---|---|---|---|---|
| Aug 21, 2026 | Flagged33 | — | agentshield ·n/a: not applicablecisco-skill-scanner: completeagent-audit-kit: completenerlo-behavioral ·n/a: not applicablenerlo-install-instruction: completecapslock ·n/a: not applicablenerlo-multi-source ·n/a: not applicabletrivy ·n/a: not applicableosv-scanner ·n/a: not applicabletrivy_image ·n/a: not applicablegovulncheck ·n/a: not applicable | completed |
Findings in files this artifact installs stand as reported; a model re-read the rest and said which ones it believes are false positives. This is a second opinion published beside the evidence, not a correction to it: the per-scanner reports above are unchanged, every dismissed finding is still listed there at its original severity, and the score and the Flagged badge are computed from those raw severities alone. Nothing below moved them.
Out of 113 findings across every scanner that examined this package.
These findings are in files this artifact installs and are not placeholder values. No false-positive basis can be corroborated for such a finding, so this review never dismisses one; they were not sent to the model and stand at their scanner's severity.
66 MANIFEST_MISSING_LICENSE
Files: /repo/plugins/sql/skills/sql-property-graph-queries/SKILL.md, /repo/plugins/sql/skills/sql-privileges-and-access-control/SKILL.md, /repo/plugins/sql/skills/sql-cte-and-recursion/SKILL.md and 63 more · reported by cisco-skill-scanner
34 SOCIAL_ENG_VAGUE_DESCRIPTION
Files: /repo/SKILL.md, /repo/reports/SKILL.md, /repo/plugins/sql/skills/sql-property-graph-queries/references/SKILL.md and 31 more · reported by cisco-skill-scanner
6 AAK-IPI-WILD-CORPUS-001
Files: reports/research-sql-transactions-and-isolation.md, plugins/sql/skills/sql-privileges-and-access-control/SKILL.md, plugins/sql/skills/sql-injection-and-parameterization/SKILL.md and 3 more · reported by agent-audit-kit
2 AAK-MARKETPLACE-001
Files: .claude-plugin/marketplace.json, .agents/plugins/marketplace.json · reported by agent-audit-kit
2 HIDDEN_DATA_FILE
Files: /repo/.agents/plugins/marketplace.json, /repo/plugins/sql/.codex-plugin/plugin.json · reported by cisco-skill-scanner
2 SECRET_CONNECTION_STRING
Files: /repo/plugins/sql/skills/sql-privileges-and-access-control/SKILL.md, /repo/plugins/sql/skills/sql-privileges-and-access-control/references/SKILL.md · reported by cisco-skill-scanner
1 EXCESSIVE_FILE_COUNT
Files: /repo/. · reported by cisco-skill-scanner
Hardcoded credentials and broad data access capabilities detected.
The artifact contains hardcoded connection strings in SQL-related skill files, which could allow credential access. It also includes capabilities for broad data access or execution, as indicated by 'wild corpus' findings within SQL skill documentation. Additionally, the artifact appears to interact with external marketplaces, suggesting potential for loading external code or network egress.
Concern level assessed by the review: High. This is the review's scale, not the registry badge.
Reviewed by gemini-2.5-flash. The model sees the findings, not your code, and cannot change a score.