Gio Fiore

Experience

Welty Enterprises

Junior Solutions Engineer

Aug 2026–present

Internal AI tools and cloud integrations on Azure.

Cleveland Metroparks

IT Rotational Intern

May–Aug 2026

Designed and deployed a zoo scavenger hunt web app.

Mentor Public Schools

Information Technology Assistant

May–Aug 2025

Device deployment, helpdesk support, and school technology.

Kent State University · B.S. Emerging Media & Technology, 2026 · Entrepreneurship minor

Featured projects

All projects

Civicfolio

A local-first stock research app with cited hypotheses, market context, and a research journal.

TypeScript · Research tools

GitHub

Civicfolio market screening and research interface, captured October 30, 2026 — Local application capture, October 30, 2026. Displayed market observations are historical.

SQLSage

A PostgreSQL CLI for query analysis and rewrite suggestions.

TypeScript · PostgreSQL

Docs GitHub

npx sqlsage demo

Nullable NOT IN subquery can invalidate anti-membership.

SQL NOT IN becomes UNKNOWN for every otherwise-unmatched outer row if this subquery emits even one NULL.

Fix — Use NULL-safe NOT EXISTS anti-membership

DiffGuard

AI-assisted git diff reviews for security issues and unintended behavior changes.

TypeScript · Code review

Example GitHub

npm run demo

FIXTURE DEMO — prewritten finding, no model call or accuracy claim.

[security] high  query.js:2
  User input is interpolated into a SQL query.
  Fix: Use a parameterized query with a separate values array.

1 finding (1 security)

More projects

All repos

FairwayOS

Prototype

Golf-video analysis research prototype: automatic ball, clubhead, golfer and cup tracking with video-motion analytics. Paused development checkpoint.

Python · Computer vision · Updated Oct 16, 2026GitHub

Details

Development is paused at a research checkpoint.

Gmail Tidy

Privacy-conscious Gmail cleanup CLI using declarative, non-destructive rules

Python · CLI · Updated Oct 16, 2026GitHub

Balatro AI Sparring

In development

Experimental local Balatro AI practice companion. Development in progress; not yet playable.

Python · AI · Updated Oct 16, 2026GitHub

Details

Development is in progress; it is not yet playable.

upgrade-check

A coding-agent skill that tests whether an update still works for existing saved data

JavaScript · SQLite · Updated Nov 1, 2026GitHub

Last synced Nov 2, 2026.

A few favorites

Favorite albums

Favorite movies

Golf courses

Image sources

Cornell ’77 (Live) — Album artwork via Apple Music
WUNNA (Deluxe) — Album artwork via Apple Music
Panic in the Streets — Album artwork via Apple Music
Scarface — Poster: Universal Pictures
Hereditary — Poster: A24
Smokey and the Bandit — Poster: Universal Pictures
Tobacco Road — Photo: Tobacco Road Golf Club
Torrey Pines — Photo: City of San Diego
The Old Course at St Andrews — Photo: Eddy23 / Wikimedia Commons · CC BY-SA 4.0; cropped for display