Skill audit report
Group events by local hour or local day in application code from one raw scan, not in SQL — the engine's local-time modifier answers from the process time zone rather than the user's, and four local-time aggregates mean four scans that can disagree with each other. Covers where the line sits between an aggregate that belongs in SQL and one that does not, and what the single scan has to return to stay correct. Use when an hour-of-day or weekday chart differs between platforms or between a device and a desktop build, when adding a fourth "group by day" query, or before writing a date function into a query string.
OpenAgentSkill Trust Score
The Trust Score helps an agent decide whether a skill is safe enough to shortlist before installation.
GitHub adoption
INFO62
202 GitHub stars
Stars/forks activity
WARN51
202 stars, 6 forks; issue activity unavailable in current metadata
Recent maintenance
PASS100
25d since push
License clarity
PASS86
GPL-3.0
README/SKILL.md completeness
INFO76
Public metadata needs stronger README/SKILL.md context
Dependency/runtime risk
WARN54
command execution surface, external package install surface
Install availability
PASS92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Install command safety
PASS92
standard package or runtime install path
Permission surface
WARN50
shell or command execution, filesystem or document access
Repository evidence
PASS86
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
Review status
WARN46
AI review approval is missing
Agent Proven outcomes
INFO54
No agent outcome data yet
Checks
Install path
92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Repository
88
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
License
86
GPL-3.0
Maintenance
100
25d since push
AI review
55
Review approval is missing
README/SKILL.md completeness
84
Warnings
Method
This report combines public metadata, AI review output, repository freshness, install readiness, OpenAgentSkill events, quality scoring, trust checks, and the agent safety gate. It is not a full source-code security review.
Compare nearby options
Guidance for distinctive, intentional UI design, typography, visual direction, and non-template-like product interfaces.
178K Stars · Audit report
Design and implementation guidance for distinctive landing pages, portfolios, product demos, and purposeful redesigns.
89K Stars · Audit report
Create original visual art, posters, PNG assets, and PDF documents through a clear design philosophy.
178K Stars · Audit report
Usable description available
Dependency risk
54
command execution surface, external package install surface
Install command safety
92
standard package or runtime install path
Permission surface
50
shell or command execution, filesystem or document access
Stars/forks activity
51
202 stars, 6 forks; issue activity unavailable in current metadata
Adoption
68
202 GitHub stars
Agent safety v2
Sparse or mixed signals. Useful for discovery, but not for autonomous installation.
Test manually in an isolated workspace and compare against safer alternatives.
Shell or command execution
highSkill metadata references terminal, CLI, shell, subprocess, or command execution workflows.
Network access
mediumSkill likely fetches remote pages, APIs, repositories, or external services.
Filesystem access
mediumSkill may read or write project files, documents, generated artifacts, or local workspace state.
Database access
mediumSkill may inspect schemas, query databases, or work with persistent stores.