database 100/100 — SaferSkills

Is database safe to install?

SaferSkills independently audited database (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.

CategoryWeightCategory scoreContribution

Securityprompt, exec, net, exfil, eval

35%

100

35.0 pts

Supply chainhash, typosquat, maintainer, lockfile

20%

100

20.0 pts

Maintenancestaleness, pinning, CI

15%

100

15.0 pts

TransparencySKILL.md, perms, README

15%

100

15.0 pts

Communityinstalls, verify, response

15%

100

15.0 pts

Findings & checks · 0 flagged

Securityscore 100 · 0 findings

✓—All security checks passedNo findings in this category for the latest scan.pass

Supply chainscore 100 · 0 findings

✓—All supply chain checks passedNo findings in this category for the latest scan.pass

Maintenancescore 100 · 0 findings

✓—All maintenance checks passedNo findings in this category for the latest scan.pass

Transparencyscore 100 · 0 findings

✓—All transparency checks passedNo findings in this category for the latest scan.pass

Communityscore 100 · 0 findings

✓—All community checks passedNo findings in this category for the latest scan.pass

The primary manifest — the file an agent reads to learn what this artifact does.

skills/database/SKILL.md · 1 file

skills/database/SKILL.md1.2 KB · Markdown

description: Diagnose and fix slow database queries. Runs EXPLAIN ANALYZE, identifies missing indexes, eliminates N+1 ORM patterns, and provides exact CREATE INDEX statements.

Execute all three phases in order.

Phase 1 — Analysis

Take the slow query or ORM code.
Generate the equivalent raw SQL.
Either instruct the user to run EXPLAIN QUERY PLAN (SQLite) or EXPLAIN ANALYZE (Postgres/MySQL), or infer missing indexes directly from the WHERE, JOIN, and ORDER BY clauses.

Phase 2 — N+1 Audit

Check whether queries are issued inside a loop. If yes, rewrite using:

IN (...) batch clause
SQL JOIN
ORM eager loading:
.include() — Prisma
.populate() — Mongoose
select_related() / prefetch_related() — Django

Phase 3 — Rewrite

Provide the optimized SQL or ORM code.
Provide the exact CREATE INDEX statements required.
Explain the disk I/O reduction: Full Table Scan O(N) → Index Lookup O(log N).

Before/after query plan summary:

Metric	Before	After
Scan type	Full Table Scan	Index Lookup
Complexity	O(N)	O(log N)
Query count (per page load)	N+1	1

database— agent skill

Is database safe to install?

Phase 1 — Analysis

Phase 2 — N+1 Audit

Phase 3 — Rewrite

Audit the pieces. Scan the whole. Decide.