
Final-year project · 2026
Bancada
RoleFull-stack development
Digital job sheets for car repair shops. Still in development.
Key points
- One shared tablet in the garage, with a PIN for each mechanic.
- Several garages on one platform, with each one's data kept apart.
- 52 tests against a real SQL Server on every pull request.
- Designed for dirty or gloved hands: large touch targets and status lights readable from a metre or two away.
Read the full case study
Bancada replaces the paper job sheets used in car repair shops. It started at the Duarte & Raposo garage in Canhoso (Covilhã), where sheets got lost, got dirty and meant doing the sums by hand. It is my final-year degree project and it is still in development.
Problem
- Job sheets were on paper: they got lost around the shop, got dirty, and it was hard to know what had been done to a car the year before.
- At the end of each repair, the invoice totals were worked out by hand, and it was not always clear who had done what.
- Several mechanics use the same tablet throughout the day, often with dirty hands or gloves on.
Technical decisions
- A dedicated mode for the shared tablet: each mechanic signs in with their name and a PIN, what they log is recorded under their name, and the session ends on its own if the tablet sits idle.
- The main screen works like a car's dashboard, with one light per repair status, readable from a metre or two away.
- Totals and VAT calculated to the cent. Bancada does not issue invoices, because in Portugal that requires certified software; invoices still come from the shop's own program.
- Several garages on the same platform, with each one's data kept apart in the API and in the database itself (SQL Server), through composite foreign keys, and tested against a real SQL Server.
- Sessions in httpOnly cookies, passwords hashed with bcrypt, rate limiting per account and per IP, and a database user with no permission to delete records. A security review of the first version of the code, done with Claude Code, found flaws (for example, the author of a job sheet could be forged) that were fixed.
Results
- The API and the interface are built and work on tablet, desktop and phone, with light and dark themes. It can be installed as an app (PWA), but it needs a network connection to show data.
- 52 automated tests run against a real SQL Server on every pull request, on GitHub Actions. The backend has 93% of its lines covered.
- I asked Claude Code for a quality, security and performance audit: it found no critical or high problems, and no accessibility violations across 13 screens in both themes. The minor issues are logged to be fixed.
- I worked in three phases (June, July and September 2026). In the last one I used Claude Code as an assistant: the product decisions were mine, and the tools report explains what the assistant did and what I decided.
- It has not yet been installed or tested at the garage: that is the next step, before it is used with real data.
Technologies
- React
- Node.js
- Express
- SQL Server
- Docker
- PWA
- GitHub Actions
Screenshots
















































