SmartKey

A key-management platform that replaced the paper logbook at the University of Lagos Senate Building with real-time tracking, an immutable audit trail, and AI-assisted security.

SmartKey

What changed

  • Cut key processing time by up to 50% by building a backend of 40+ Next.js API routes and 25+ Postgres RPCs on Supabase.
  • Automated risk detection and reporting for security staff by integrating 3 AI features - rule-based risk scoring, Gemini shift reports, and signature verification.
  • Achieved zero missing or altered records by writing every state change and its audit entry in one atomic database transaction.

What I worked on

  • I designed and built the backend - API routes, transactional Postgres RPCs, and Row-Level Security across all database tables.
  • I built the AI security layer, including pixel-level signature verification and Gemini-generated shift reports with a deterministic fallback.
  • I implemented four role-specific dashboards for security officers, deans, verifiers, and staff requesters.

Staff request a key, collect it at the security desk with a one-time code, and return it the same way. Every step is logged and timestamped, and the AI features flag what a paper logbook never could, such as a signature that doesn't match.

Built with Next.js, TypeScript, and Supabase (Postgres with Row-Level Security), with the Google Gemini API for AI features.

CSO dashboard flagging a signature mismatch
Key issued at the security desk