Projects / Maintenance App

Maintenance App

A simple CMMS for tracking issues, assets, and maintenance activity across sites for Exceed Robotics.

Flask PostgreSQL HTML/CSS Self-hosted
← Back to Projects GitHub

What it does

  • Issue tracking: open > in progress > closed, with status history.
  • Updates/activity log: comments + actions tied to an issue timeline.
  • Asset linking: issues can attach to an asset (tag/model/site).
  • Fast filtering: status, category, site/asset, search.
Our old "maintenance system" was:
  • See which robot was sitting in the maintenance box.
  • Assume someone remembered to post the issue in Slack.
  • Fix it if parts happened to be available.

There was no source of truth, no history, and no accountability. As soon as multiple sites and instructors were involved, this stopped working.

I'm working on this app to enforce a single, simple workflow: issues must be logged, they must be tied to a specific asset, and they stay visible until they are closed.

(Also, I thought it would be cool to learn databases and needed a project that used them)

Screenshots

Issue page screenshot
Issue details + activity + status changes.
Issues list screenshot
Issues list with filters (status/category/search).

Technical notes

Backend

  • Flask app with a small service/db layer split.
  • Postgres as source of truth.
  • Local server-rendered pages for speed and simplicity.

Frontend

  • Plain HTML templates + a consistent CSS token set.
  • Minimal JS.
  • Mobile/tablet tweaks - the app should work for all devices, else it will never be used.

Next steps

  • Finish:
    > Dashboard
    > Issue Creation
    > App Settings on a per-user basis

  • Deploy and test at one location
  • Bug-fix with results from test
  • Deploy across all locations