Rapport d’audit du skill
bucket-local-time-in-code-not-in-sql Rapport d’audit.
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.
Trust Score OpenAgentSkill
Trust Score OpenAgentSkill
The Trust Score helps an agent decide whether a skill is safe enough to shortlist before installation.
Adoption GitHub
Info62
202 stars GitHub
Activité stars/forks
Avertissement51
202 stars et 6 forks; l’activité des issues n’est pas disponible dans les métadonnées actuelles
Maintenance récente
Validé88
1 mois depuis le dernier push
Clarté de licence
Validé86
GPL-3.0
Complétude README/SKILL.md
Info76
Les métadonnées publiques nécessitent davantage de contexte README/SKILL.md
Risque dépendances/runtime
Avertissement54
command execution surface, external package install surface
Disponibilité de l’installation
Validé92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Sécurité de la commande d’installation
Validé92
Chemin d’installation standard de package ou runtime
Surface de permissions
Avertissement50
shell or command execution, filesystem or document access
Preuve du dépôt
Validé86
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
État de revue
Avertissement46
L’approbation de revue IA est absente
Résultats prouvés par Agent
Info54
Pas encore de données de résultats Agent
Vérifications
Revue d’installation et d’adoption
Chemin d’installation
92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Dépôt
88
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
Licence
86
GPL-3.0
Maintenance
88
1 mois depuis le dernier push
Revue IA
55
Review approval is missing
Complétude README/SKILL.md
84
Usable description available
Risque de dépendances
54
command execution surface, external package install surface
Sécurité de la commande d’installation
92
Chemin d’installation standard de package ou runtime
Surface de permissions
50
shell or command execution, filesystem or document access
Activité stars/forks
51
202 stars et 6 forks; l’activité des issues n’est pas disponible dans les métadonnées actuelles
Adoption
68
202 stars GitHub
Avertissements
- Dependency or permission surface needs review
- Permission surface may require sandboxing
- L’approbation de revue IA est absente
- Quality score needs review
- Permission surface needs review: shell or command execution, filesystem or document access
- Stars/forks activity: 202 stars, 6 forks; issue activity unavailable in current metadata
- Dependency/runtime risk: command execution surface, external package install surface
- Permission surface: shell or command execution, filesystem or document access
- Review status: AI review approval is missing
Méthode
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.
Comparer les options proches
Skills associés à auditer ensuite
Frontend Design
Guidance for distinctive, intentional UI design, typography, visual direction, and non-template-like product interfaces.
181K Stars · Rapport d’audit
Taste Skill: Anti-Slop Frontend
Design and implementation guidance for distinctive landing pages, portfolios, product demos, and purposeful redesigns.
95K Stars · Rapport d’audit
Canvas Design
Create original visual art, posters, PNG assets, and PDF documents through a clear design philosophy.
181K Stars · Rapport d’audit