CATALOG // PROJECTS

All projects

Filter by organization or inspect full case studies and technical specs.

Showing 30 of 30 projects
IplanRio2026
in production

Rio Queue

A virtual waiting room that absorbs traffic spikes on Nota Carioca and the SuperApp.

75%
of the commits
1,000
concurrent sessions on the tax guide queue
2
protected systems, one of them legacy ASP.NET
  • Python
  • FastAPI
  • Granian
  • Valkey
  • SSE
  • TypeScript
  • esbuild
  • GKE
  • Argo CD
  • KEDA
IplanRio2025–2026
in production

Courses, jobs and employability API

The Go backend behind course enrollments and job listings in the SuperApp.

#1
contributor by commits
97%
of responses under 100 ms under load
474
req/s peak with zero errors
  • Go
  • Gin
  • GORM
  • PostgreSQL
  • Redis
  • Cerbos
  • Keycloak
  • Typesense
  • Argo Rollouts
  • OpenTelemetry
IplanRio2026
in production

Nota Carioca data pipelines

A BigQuery → Oracle load 31 to 33x faster, in production a few days after the first test.

33x
faster than conventional inserts
35 s
for 3.4 million rows
0
mismatches in parity checks
  • Python
  • Prefect
  • BigQuery
  • dbt
  • Oracle
  • SQL*Loader
  • GCS
  • Kubernetes
  • Discord
IplanRio2026
in production

GCP cost investigation and Billing Guard

From a fee that jumped over 6,000x to an automatic breaker for runaway APIs.

R$ 128k
per year in projected savings
2.5x
gap between bytes read and billed, explained
1/h
cap on automatic shutoffs
  • BigQuery
  • GCS
  • dbt
  • Go
  • Cloud Run
  • Pub/Sub
  • Firestore
  • Cloud Monitoring
  • OpenTofu
IplanRio2025–2026
in production

EAí gateway and the city's MCP server

The bridge between citizens on WhatsApp and the city's AI agents.

500 → 50 ms
average latency versus the Python version
220
of my commits on the evals API in 2025
  • Go
  • Gin
  • RabbitMQ
  • Redis
  • Google Agent Engine
  • Letta
  • Speech-to-Text
  • Python
  • FastMCP
  • Keycloak
IplanRio2024–2025
in production

City chatbot integrations

The webhooks that let the city chatbot issue property tax slips, open 1746 service requests and point to the nearest hospital.

  • Python
  • Google Cloud
  • Vertex AI Search
  • Django REST Framework
  • JWT
Inspect detailsHide details[chatbot-webhooks]

Solution

Python webhooks to look up and download property tax slips with short links, query properties over VPN with encrypted tokens, open 1746 service requests with data validation and find the nearest health units by location, filtered by complexity. I also built the share.dados.rio URL shortener in Django REST with JWT.

Result

29 merged PRs between late 2024 and early 2025, my first deliveries at IplanRio.

Stack

  • Python
  • Google Cloud
  • Vertex AI Search
  • Django REST Framework
  • JWT
IplanRio2026
in production

Go email worker

A rewrite of the transactional email worker, with automatic fallback to the Gmail API.

  • Go
  • RabbitMQ
  • SMTP
  • Gmail API
  • Kubernetes
Inspect detailsHide details[mailman]

Solution

The Python worker kept stalling on the proxy tunnel to the city's SMTP relay. I rewrote it in Go consuming from RabbitMQ, with an unbuffered HTTP/1.0 tunnel reader and a Gmail API fallback when the SMTP network hangs. If the AMQP channel drops, the process exits on purpose so Kubernetes restarts it.

Stack

  • Go
  • RabbitMQ
  • SMTP
  • Gmail API
  • Kubernetes
IplanRio2026
in production

Executive meeting room displays

Two synchronized screens showing city indicators in the City Hall executive meeting room.

  • Next.js
  • React
  • TypeScript
  • Tailwind CSS
  • Framer Motion
Inspect detailsHide details[sala-pref]

Solution

Merged two separate apps into a single Next.js app with one route per screen, transitions without black frames and a 6-second rotation. CI runs with zero react-doctor warnings.

Stack

  • Next.js
  • React
  • TypeScript
  • Tailwind CSS
  • Framer Motion
Vizo2026
in production

Alliomed

Practice management for doctors and psychologists, with AI in the medical record and paying clinics.

350+
PRs merged
17
ADRs
RLS
enforced per clinic in PostgreSQL
  • TypeScript
  • Next.js
  • React
  • Drizzle
  • PostgreSQL
  • Redis
  • Vertex AI
  • Speech-to-Text
  • Mercado Pago
  • Cloud Run
  • OpenTofu
  • GitHub Actions
Vizo2026
internal

Maestro, a coding agent delivery pipeline

An issue lands on the board, one agent implements, another reviews and a third validates in staging. If it breaks, the revert is automatic.

122
commits, all mine
110
test files
11
typed fields in the machine contract
  • Python
  • SQLite
  • systemd
  • Telegram
  • GitHub Actions
  • OpenCode
  • Terraform
  • Caddy
Vizo2025–2026
in use by customers

Proventus

Social security case analysis for law firms, in use at two firms.

2
law firm customers, still using it
3 → 1
repositories merged into one monorepo
  • Python
  • FastAPI
  • LangGraph
  • Prefect
  • Gemini
  • GoRules ZenEngine
  • PostgreSQL
  • Redis
  • Next.js
  • GCP
Vizo2025–2026
sold

Sienge SaaS RPA

Six fiscal and finance robots became one platform, and then the product was sold.

6 → 1
robots consolidated into one platform
Sold
to another company
  • Python
  • Playwright
  • Prefect
  • FastAPI
  • PostgreSQL
  • Next.js
  • Docker
Freelance2026
live

PLANEHAB Nosso Bairro

A public housing consultation turned into a game, used in live sessions in Bahia.

75%
of the commits
6
groups per session in stage 2
13
hexes on the neighborhood board
  • TypeScript
  • React
  • Vite
  • dnd-kit
  • Canvas
  • Hono
  • Drizzle
  • PostgreSQL
  • Turborepo
  • AWS Lightsail
  • Nginx
Freelance2025–2026
client work

Vardis

Architecture support for a data engineering consultancy's data platform.

  • Kubernetes
  • Talos
  • Argo Workflows
  • dbt
  • PostgreSQL
  • Helm
  • Nix
Inspect detailsHide details[vardis]

Solution

Kubernetes on Talos on a dedicated server, Argo Workflows pipelines, dbt on PostgreSQL with pg_duckdb, Helm charts and reproducible environments with Nix.

Stack

  • Kubernetes
  • Talos
  • Argo Workflows
  • dbt
  • PostgreSQL
  • Helm
  • Nix
Freelance2026
client work

LivinHub

Short-term rental management with Airbnb calendar sync and a digital guest guide.

  • TypeScript
  • Next.js
  • Hono
  • Prisma
  • PostgreSQL
  • Turborepo
Inspect detailsHide details[livinhub]

Solution

Restructured the project as a Turborepo monorepo, fixed the API build with esbuild and refined the year-over-year revenue view and onboarding.

Stack

  • TypeScript
  • Next.js
  • Hono
  • Prisma
  • PostgreSQL
  • Turborepo
New Data Company2026
prototype

NDC Nexus

Ten Elixir agents that read WhatsApp, email and calendar, and only act once you approve.

10
supervised agents per workspace
6
integrated channels
100%
of external actions gated by a human
  • Elixir
  • OTP
  • Phoenix
  • Jido
  • Oban
  • PostgreSQL
  • pgvector
  • Next.js
  • Baileys
  • Docker
New Data Company2026
prototype

WhatsApp group monitor

Transcribes voice notes, detects narratives and pings Telegram when a topic heats up.

  • Python
  • FastAPI
  • Celery
  • Redis
  • PostgreSQL
  • Node.js
  • Baileys
  • Gemini
  • Next.js
Inspect detailsHide details[monitor-whatsapp]

Solution

A Node.js bridge on Baileys keeps one WhatsApp session per user, with the QR code streamed over SSE. FastAPI receives the events, and Celery transcribes voice notes with Gemini, scores group activity and runs narrative detection hourly without repeating topics from the last 24 h. Phone login with TOTP. 40 commits, all mine, in two weeks.

Stack

  • Python
  • FastAPI
  • Celery
  • Redis
  • PostgreSQL
  • Node.js
  • Baileys
  • Gemini
  • Next.js
New Data Company2026
internal

Internal ERP

Finance, contracts, people, tasks and Gmail in one place.

  • TypeScript
  • Next.js
  • Fastify
  • Prisma
  • PostgreSQL
  • MinIO
Inspect detailsHide details[ndc-erp]

Solution

Fastify, Prisma and PostgreSQL with 20 models (revenue, expenses, contracts, subscriptions, projects, documents, tasks and calendar), MinIO for files, Google and WhatsApp integrations and per-route permissions. I moved state that lived in the browser's localStorage into the API and got it ready for production.

Stack

  • TypeScript
  • Next.js
  • Fastify
  • Prisma
  • PostgreSQL
  • MinIO
Personal2026
open source

Jungle Wallet

A wagering wallet in Go where the database itself guarantees the balance never drifts from the ledger.

232
req/s on a 2 vCPU VM
29.8 ms
p95
0
reconciliation mismatches
  • Go
  • PostgreSQL
  • SQS
  • SNS
  • Keycloak
  • Terraform
  • k6
  • GitHub Actions
  • Cosign
  • Tailscale
Personal2026
internal

ZolioLab

The server this site runs on, with one-command HTTPS previews and ops bots.

  • Linux
  • Terraform
  • Caddy
  • systemd
  • Docker
  • SOPS
  • Tailscale
  • Nix
Inspect detailsHide details[zoliolab]

Solution

A hardened VM with Terraform, UFW, Fail2ban and an iptables chain that stops Docker from bypassing the firewall. Caddy publishes any local service on *.lab.fredzol.io with one command. A health watcher runs every 30 minutes, plus LLM spend tracking and SOPS-managed secrets. Before it, I ran a declarative NixOS homelab.

Stack

  • Linux
  • Terraform
  • Caddy
  • systemd
  • Docker
  • SOPS
  • Tailscale
  • Nix
Personal2026
prototype

OSCE Cirurgia

A surgery practical exam simulator, with examiner and student on separate devices.

  • TypeScript
  • React
  • Vite
  • Hono
  • WebSocket
  • SQLite
  • Docker
Inspect detailsHide details[osce]

Solution

Real-time rooms with Hono and WebSockets, a server-owned clock (1 minute to read, 5 to answer), student join by QR code and exams released by the examiner. The student never receives the answer key or an unreleased image. 100 stations, 52 of them with verbatim source content audited across 555 excerpts.

Stack

  • TypeScript
  • React
  • Vite
  • Hono
  • WebSocket
  • SQLite
  • Docker
Personal2026
experiment

ENEM essay grading spike

An honest test of whether atomic questions and deterministic rules can grade Brazil's national exam essays.

  • TypeScript
  • Bun
  • Python
Inspect detailsHide details[redacao]

Solution

19 atomic questions across the 5 competencies, with all of the official rubric math in code and none in the model. Each competency is routed by confidence to automatic, a cascade to a reasoning model, or a human, and an essay is only zeroed at 90% confidence. It produced zero false zeros and a 20.7-point mean error on competency 1, but the total error was 197 points against an 80-point target. The call was to stop before spending on UI and billing.

Stack

  • TypeScript
  • Bun
  • Python
Personal2026
prototype

GamePixzo

A browser arcade where the server replays the whole match before accepting a score.

  • TypeScript
  • Canvas
  • Hono
  • Drizzle
  • PostgreSQL
  • PGlite
  • ethers
Inspect detailsHide details[gamepixzo]

Solution

The server issues a seeded session, the client records inputs per tick, and on submit the server re-simulates the match in one of 5 engines (snake, tetris, invaders, breakout and pong), computes score and state hash and logs any mismatch. Login by wallet signature (EIP-191).

Stack

  • TypeScript
  • Canvas
  • Hono
  • Drizzle
  • PostgreSQL
  • PGlite
  • ethers
Personal2025
open source

Surkai

An autonomous search engine for AI agents, later adopted by the city.

  • Python
  • Docker
Inspect detailsHide details[surkai]

Solution

Searches and crawls the web and returns ready-to-use context for the agent. It became a city service and the search tool on the MCP server.

Stack

  • Python
  • Docker

Links

Quick actionsSwitch language to Português (PT-BR)
PT-BR
Quick actionsToggle light / dark theme
THEME
Quick actionsDownload résumé in Portuguese (PDF)
PDF · PT-BR
Quick actionsDownload résumé in English (PDF)
PDF · EN
Quick actionsCopy email address (fredzolio.dev@gmail.com)
COPY
NavigationProduction services and featured work
#servicos
NavigationAll projects
/en/projects/
NavigationCareer timeline
#carreira
NavigationTalks, hiring, documentation & open source
#atuacao
NavigationSkills & tooling
#stack
NavigationAcademic background, courses & languages
#formacao
NavigationContact & résumé
#contato
Projects & case studiesRio Queue
IplanRio · in production
Projects & case studiesPublic service search and recommendations
IplanRio · in production
Projects & case studiesCourses, jobs and employability API
IplanRio · in production
Projects & case studiesSuperApp load test
IplanRio · internal
Projects & case studiesNota Carioca data pipelines
IplanRio · in production
Projects & case studiesGCP cost investigation and Billing Guard
IplanRio · in production
Projects & case studiesEAí gateway and the city's MCP server
IplanRio · in production
Projects & case studiesCoding agent platform for developers
IplanRio · internal
Projects & case studiesAgents for infrastructure operations
IplanRio · internal
Projects & case studiesCity chatbot integrations
IplanRio · in production
Projects & case studiesGo email worker
IplanRio · in production
Projects & case studiesExecutive meeting room displays
IplanRio · in production
Projects & case studiesAlliomed
Vizo · in production
Projects & case studiesMaestro, a coding agent delivery pipeline
Vizo · internal
Projects & case studiesProventus
Vizo · in use by customers
Projects & case studiesSienge SaaS RPA
Vizo · sold
Projects & case studiesAWS infrastructure assessment
Vizo · client work
Projects & case studiesPLANEHAB Nosso Bairro
Freelance · live
Projects & case studiesConecta Solar
Freelance · live
Projects & case studiesVardis
Freelance · client work
Projects & case studiesLivinHub
Freelance · client work
Projects & case studiesNDC Nexus
New Data Company · prototype
Projects & case studiesWhatsApp group monitor
New Data Company · prototype
Projects & case studiesInternal ERP
New Data Company · internal
Projects & case studiesJungle Wallet
Personal · open source
Projects & case studiesZolioLab
Personal · internal
Projects & case studiesOSCE Cirurgia
Personal · prototype
Projects & case studiesENEM essay grading spike
Personal · experiment
Projects & case studiesGamePixzo
Personal · prototype
Projects & case studiesSurkai
Personal · open source