I built The Repair Line: turning small repairs into shared relief

Description and use

The Repair Line platform aggregates small community repairs, using AI for assessment and Snowflake for data storage, enabling residents to see and support local needs.

Problem

Small shared community repairs often lack visibility and coordinated funding, making it hard for residents to identify and support local repair needs.

Outcome

The Repair Line successfully centralizes small repair requests, provides AI‑generated severity and cost estimates, and tracks community pledges, fostering transparent and efficient local generosity.

Workflow

• Choose a city from the location selector
• Browse local repair needs or click "Show all repairs"
• Upload a clear photo of a broken shared item in "Assess a repair"
• Receive AI assessment of severity, plausibility, cost range, and reasoning
• Add the assessed repair to the line and track pledges

Evidence

The repair assessor accepts a photo and sends it to a server‑side Gemini route. Gemini is asked to return structured JSON with severity, cost, plausibility, and reasoning.

Source

Repair records include the repair title, location, severity, estimated cost, people helped, reason, image, and pledged amount. The Snowflake schema and query layer support feed filters for city, severity, and sorting.

Source