Skip to content
All projects
Internal QA tooling

Clinical data QA toolkit

An Electron desktop app that brings clinical data validation, PDF review, and study workflows into one place. Built for the people checking records before anyone downstream trusts them.

CSV validation flow

Inside the build

  • Live CSV & Excel validation

  • PDF review in the same workspace

  • Typed IPC & signed releases

Overview

An internal Electron desktop toolkit that automates QA workflows for regulated clinical study data. The renderer runs a React + Tailwind UI, while a Node main process owns file I/O against secure network shares, signed update channels per environment, and shell-level workflow execution.

Real-time CSV and XLSX validation runs through a streaming pipeline built on PapaParse and xlsx, with rule schemas authored in JavaScript and statically analyzed via acorn so reviewers can see exactly what each rule does. PDF previews render inline next to the validation results, so QA never has to leave the app.

Builds are produced per environment with code signing and auto-update wired in, and the renderer talks to the main process through a typed IPC layer so the same React components stay portable to a future web version.

Stack

  • React
  • Electron
  • Node.js
  • Vite
  • TypeScript
  • Tailwind CSS
  • Vitest
  • @tanstack/react-query
  • @tanstack/react-table
  • axios
  • xlsx
  • PapaParse
  • acorn
  • acorn-walk
  • React Toastify