CareSync SQL Warehouse (MySQL 8)

SQL-first analytics layer for EMS Patient Care Reports (PCRs), vitals time-series, and transcripts.

Quickstart

0) Install

• Install Docker Desktop (Mac/Windows/Linux). Start it once so Docker is running.

1) Start the database

make up
# or: docker compose up -d

The first boot runs everything in initdb/ automatically (schema, roles, triggers, seed data).

2) Connect

• CLI: make mysql (opens mysql shell as root to DB caresync)
• GUI (optional): DBeaver/TablePlus/Beekeeper
  • Host: localhost, Port: 3306, User: root, Password: dev, Database: caresync

3) Run analytics queries

Open any file in analytics/ and paste into your SQL client.

Example:

SELECT COUNT(*) AS patients FROM patients;
SELECT COUNT(*) AS encounters FROM encounters;

4) Reset (to rerun from scratch)

make reset
make up

Files

• initdb/01_schema.sql – tables
• initdb/02_security.sql – roles/users (optional)
• initdb/03_triggers.sql – trigger to auto-stamp finalized_at
• initdb/10_seed.sql – synthetic data (patients, encounters, vitals, transcripts, PCRs, alerts)
• analytics/*.sql – ready-to-run queries for dashboards and episodes