FSG Environmental Data Portal
Multi-tenant carbon accounting portal for an Irish sustainability consultancy: clients log energy, water, waste and travel, and the portal reports Scope 1/2/3 emissions with a full audit trail.
- Kept each client organisation's data apart in the SQL itself rather than in Go conditionals, so a forged id reads or writes nothing; database-backed tests prove it, and CI fails if they are skipped
- Required a second factor for FSG staff (TOTP or a single-use recovery code) before any session exists, with lockout after repeated wrong codes and email alerts when it is set up, reset or bypassed with a recovery code
- Strict CSP (default-src 'none', no inline script or style) with html/template escaping as the XSS defence; the Go toolchain is pinned as a security floor and govulncheck fails the build on a called vulnerability
- Agent-built under my review behind the AI Harness verify.sh gates: the full test suite, gosec, govulncheck, gitleaks, an SBOM check and a distroless image that runs as non-root
GoPostgreSQLhtml/templateargon2idFly.io