projects / GitSOD

Internal Government Tool

GitSOD

Next.js
Hono
Prisma
Supabase
Octokit
GitHub API

2025 - Present

GitSOD

Description

GitSOD is an automated SOD/EOD report generator built as an internal productivity tool for developers in the City Government of Butuan CICTD. It uses developers' commit history as context for AI-assisted report writing, helping teams produce consistent daily accomplishment and blocker updates with less manual effort.

Problem

Developers were spending repetitive time writing Start-of-Day and End-of-Day reports, and monthly accomplishment summaries were hard to compile across many days of work. Manual reporting also made it easy to miss blockers, underreport progress, and lose visibility into actual engineering output.

Technical Details

The system ingests and tracks commit activity per developer, structures commit metadata as contextual input, and sends it to an AI generation pipeline to produce Daily SOD/EOD reports with blockers. It also aggregates commit activity over time and visualizes it in graphs to provide clear progress signals per developer and per team. At month end, the same commit timeline and AI summarization workflow are used to generate accomplishment reports grounded in actual delivered work.

My Role

I designed and implemented the reporting flow end-to-end, including commit tracking, contextualization logic for AI generation, and report output formatting. I also worked on the analytics side by mapping commit activity into visual graphs and connecting monthly summaries to accomplishment report generation.

Challenges

The key challenge was converting raw commit logs into useful and readable report context without losing technical accuracy. Another challenge was balancing automation with reviewability so generated SOD/EOD and monthly reports stay trustworthy and aligned with each developer's actual contributions.

Screenshots

GitSODGitSODGitSOD

Conclusion

GitSOD improves engineering reporting quality and consistency while reducing manual overhead. By grounding AI-generated reports on commit history and providing monthly visual/activity summaries, it gives both developers and management a clearer and faster way to track day-to-day progress and end-of-month accomplishments.