Laporan audit skill
bucket-local-time-in-code-not-in-sql Laporan 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.
Adopsi GitHub
Info62
202 star GitHub
Aktivitas star/fork
Peringatan51
202 star dan 6 fork; aktivitas issue tidak tersedia dalam metadata saat ini
Pemeliharaan terbaru
Lulus88
1 bulan sejak push
Kejelasan lisensi
Lulus86
GPL-3.0
Kelengkapan README/SKILL.md
Info76
Metadata publik memerlukan konteks README/SKILL.md yang lebih kuat
Risiko dependensi/runtime
Peringatan54
command execution surface, external package install surface
Ketersediaan pemasangan
Lulus92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Keamanan perintah pemasangan
Lulus92
Jalur pemasangan paket atau runtime standar
Cakupan izin
Peringatan50
shell or command execution, filesystem or document access
Bukti repositori
Lulus86
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
Status peninjauan
Peringatan46
Persetujuan tinjauan AI belum ada
Hasil terbukti Agent
Info54
Belum ada data hasil Agent
Pemeriksaan
Tinjauan pemasangan dan adopsi
Jalur pemasangan
92
npx skills add maxrave-dev/kotlin-footguns --skill bucket-local-time-in-code-not-in-sql
Repositori
88
https://github.com/maxrave-dev/kotlin-footguns/tree/main/skills/bucket-local-time-in-code-not-in-sql
Lisensi
86
GPL-3.0
Pemeliharaan
88
1 bulan sejak push
Tinjauan AI
55
Review approval is missing
Kelengkapan README/SKILL.md
84
Usable description available
Risiko dependensi
54
command execution surface, external package install surface
Keamanan perintah pemasangan
92
Jalur pemasangan paket atau runtime standar
Cakupan izin
50
shell or command execution, filesystem or document access
Aktivitas star/fork
51
202 star dan 6 fork; aktivitas issue tidak tersedia dalam metadata saat ini
Adopsi
68
202 star GitHub
Peringatan
- Dependency or permission surface needs review
- Permission surface may require sandboxing
- Persetujuan tinjauan AI belum ada
- 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
Metode
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.
Bandingkan opsi sekitar
Skill terkait untuk diaudit berikutnya
Frontend Design
Guidance for distinctive, intentional UI design, typography, visual direction, and non-template-like product interfaces.
181K Star · Laporan audit
Taste Skill: Anti-Slop Frontend
Design and implementation guidance for distinctive landing pages, portfolios, product demos, and purposeful redesigns.
95K Star · Laporan audit
Canvas Design
Create original visual art, posters, PNG assets, and PDF documents through a clear design philosophy.
181K Star · Laporan audit