CareOps Agent

A Coral-powered family care coordination first mate

Important

CareOps is Coral-first. The app uses real Coral CLI execution (coral sql) as its default query engine — 9 registered JSONL-backed Coral sources, cross-source JOINs, and a doctor-ready packet generated from Coral results. SQLite/mock modes exist only as fallback for testing.

🩺 The Problem

When managing care for an aging parent or loved one, records are scattered everywhere. Doctor instructions in WhatsApp, lab reports in PDFs, prescriptions in photos, symptoms in notes apps. When you walk into a follow-up appointment, doctors waste 10 minutes just trying to piece together the timeline.

💡 The Solution: CareOps

CareOps joins medical records, prescription photos, lab reports, doctor chat instructions, pharmacy receipts, and symptom logs using Coral SQL. It generates a clean, doctor-ready packet with a unified timeline, missing record detection, and questions for the doctor.

Warning

Safety Boundary: CareOps does NOT diagnose, prescribe, or provide medical advice. It only organizes records, builds timelines, detects missing records, and generates questions to ask a licensed medical professional.

🆕 What's New

Feature	Description
Interactive Mermaid Diagram	Dashboard shows a live architecture flow diagram rendered via the `mermaid` npm package — no build step required
Analytics Dashboard	`/analytics` — per-patient KPI cards, symptom severity charts, cross-patient comparison, Ollama model status
Interactive Exports	`/exports` — list, preview, download, and delete exported Markdown packets
Patient Selector	Dropdown component across dashboard + analytics for quick patient switching
5 Patients, 73 Records	Expanded synthetic data for richer demos
Ollama Integration	Community source spec with 3 local models (llama3.2, phi3, kimi-k2.5)
22 tests	13 careops + 9 coral-cli tests, all passing

🌊 Why Coral? (Track 2)

Coral is central to this application. CareOps relies on joining 9 disparate data sources through a single SQL interface.

Layer	Implementation
Source specs	Real Coral manifests (`coral/sources/careops/{spec}/manifest.yaml`)
Data backend	JSONL through Coral (`backend: jsonl`)
Query engine	`coral sql --format json` via Coral CLI v0.2.0
App API	`CoralClient` → `coral-cli-client.ts` (safe `execFile` wrapper)
Packet generation	10+ real `coral sql` calls assembled into a doctor-ready packet
SQLite	Fallback/cache only
Mock	Tests/offline only

Architecture

flowchart TD
    subgraph App["CareOps Application"]
        UI["Next.js UI"] --> API["Next.js API Routes"]
        API --> Client["Coral CLI Client\n(coral-cli-client.ts)"]
        Client --> CLI["coral sql --format json"]
    end

    subgraph Coral["Coral Query Layer"]
        CLI --> JOIN["Cross-Source JOIN\n(patient_id key)"]
        JOIN --> PAT["careops_patients\npatient demographics"]
        JOIN --> MED["careops_medications\nmedication records"]
        JOIN --> LAB["careops_lab_reports\nlab test results"]
        JOIN --> CHAT["careops_doctor_chats\ndoctor instructions"]
        JOIN --> PHARM["careops_pharmacy_receipts\nrefill evidence"]
        JOIN --> SYMP["careops_symptom_logs\nsymptom tracking"]
        JOIN --> APPT["careops_appointments\nappointment calendar"]
        JOIN --> OCR["careops_prescription_ocr\nOCR prescriptions"]
        JOIN --> NOTES["careops_family_notes\ncaregiver notes"]
    end

    subgraph Storage["Data Backend"]
        MED --> JSONL["data/*.jsonl\n73 records across 9 files"]
        LAB --> JSONL
        CHAT --> JSONL
        PHARM --> JSONL
        SYMP --> JSONL
        APPT --> JSONL
        OCR --> JSONL
        NOTES --> JSONL
        PAT --> JSONL
    end

    CLI --> Result["Joined SQL Result"]
    Result --> Agent["CareOps Packet Generator"]
    Agent --> Packet["Doctor Visit Packet"]
    Packet --> Evidence["SQL Evidence Panel"]

    style PAT fill:#e0f2fe,stroke:#0284c7
    style JOIN fill:#f0fdf4,stroke:#15803d
    style JSONL fill:#fef2f2,stroke:#b91c1c

Tech Stack

graph TB
    subgraph Frontend["Frontend"]
        NEXT["Next.js 15 App Router"]
        TS["TypeScript"]
        TW["Tailwind CSS"]
        LI["Lucide Icons"]
    end

    subgraph Query["Query Layer"]
        CC["CoralClient\nmode-switching abstraction"]
        CCLI["Coral CLI Client\nsafe execFile wrapper"]
        CP["Coral Output Parser\nJSON result parser"]
    end

    subgraph Coral["Coral Engine"]
        CSQL["coral sql --format json"]
        CLINT["coral source lint"]
        CADD["coral source add"]
        CTEST["coral source test"]
    end

    subgraph Sources["9 Coral Source Specs\nregistered via coral source add --file"]
        PAT["careops_patients\npatient demographics"]
        MED["careops_medications\nmedication records"]
        LAB["careops_lab_reports\nlab test results"]
        CHAT["careops_doctor_chats\ndoctor instructions"]
        PHARM["careops_pharmacy_receipts\nrefill evidence"]
        SYMP["careops_symptom_logs\nsymptom tracking"]
        APPT["careops_appointments\nappointment calendar"]
        OCR["careops_prescription_ocr\nOCR prescriptions"]
        NOTES["careops_family_notes\ncaregiver notes"]
    end

    subgraph Data["Data Layer"]
        JSONL["JSONL Files\n9 files, 73 total rows"]
        CSV["CSV Files\n9 files (SQLite fallback)"]
    end

    subgraph Agent["Agent Layer"]
        AGT["CareOps Packet Generator\n10+ query pipeline"]
        QRY["Query Builders\n8 typed SQL templates"]
        SAFE["Safety Rules Engine\nno diagnosis/prescription"]
    end

    NEXT --> CC
    CC --> CCLI
    CCLI --> CSQL
    CSQL --> CLINT
    CSQL --> CADD
    CSQL --> CTEST
    CCLI --> CP
    CP --> AGT
    CSQL --> Sources
    Sources --> JSONL
    Sources --> CSV
    AGT --> QRY
    AGT --> SAFE
    QRY --> Sources

🪸 About Coral

Coral is an open-source SQL-based abstraction layer over disparate data sources. Instead of writing multiple API clients, Coral lets you query all sources with SQL JOINs.

Coral repository: https://github.com/withcoral/coral

CareOps Coral Sources

9 custom Coral source specs are registered with the real Coral CLI:

Source	Table	Format	Rows	Status
`careops_patients`	patients	JSONL	5	✅ 2/2 tests pass
`careops_medications`	medications	JSONL	9	✅ 2/2 tests pass
`careops_lab_reports`	lab_reports	JSONL	12	✅ 2/2 tests pass
`careops_doctor_chats`	doctor_chats	JSONL	7	✅ 2/2 tests pass
`careops_pharmacy_receipts`	pharmacy_receipts	JSONL	11	✅ 2/2 tests pass
`careops_symptom_logs`	symptom_logs	JSONL	11	✅ 2/2 tests pass
`careops_appointments`	appointments	JSONL	6	✅ 2/2 tests pass
`careops_prescription_ocr`	prescription_ocr	JSONL	5	✅ 2/2 tests pass
`careops_family_notes`	family_notes	JSONL	7	✅ 2/2 tests pass

18/18 declared test queries pass on registration.

🚀 Features

Dashboard: Coral runtime status card showing mode, sources, and connection status
Interactive Data Sources: 9 source cards with clickable CLI actions (lint → add → test → query) and live execution logs
Coral SQL Evidence Panel: Verify Sources / Run Live Query / Generate Packet — all via real coral sql
Doctor Visit Packet Builder: 10+ Coral SQL calls assembled into a 1-page visit summary
Care Timeline: Chronological timeline across 7 Coral sources, sorted by date
Export: Download the packet as Markdown
Safety Guardrails: Never diagnoses, prescribes, or recommends medicine changes

💻 Tech Stack

Next.js 15 (App Router) + TypeScript
Tailwind CSS + Lucide Icons
Coral CLI v0.2.0 — real query engine
better-sqlite3 — test/fallback only
Vitest

🛠️ Setup

Prerequisites

Node.js 18+
npm
Coral CLI v0.2.0+ (npm install -g @withcoral/cli)

Quick Start

# 1. Clone and install
git clone https://github.com/FiscalMindset/careops.git
cd careops
npm install

# 2. Verify Coral CLI
coral --version

# 3. Register all 9 Coral sources
coral source add --file coral/sources/careops/patients/manifest.yaml
coral source add --file coral/sources/careops/medications/manifest.yaml
coral source add --file coral/sources/careops/lab_reports/manifest.yaml
coral source add --file coral/sources/careops/doctor_chats/manifest.yaml
coral source add --file coral/sources/careops/pharmacy_receipts/manifest.yaml
coral source add --file coral/sources/careops/symptom_logs/manifest.yaml
coral source add --file coral/sources/careops/appointments/manifest.yaml
coral source add --file coral/sources/careops/prescription_ocr/manifest.yaml
coral source add --file coral/sources/careops/family_notes/manifest.yaml

# 4. Start the app (Coral CLI mode — default)
npm run dev

Quick Registration Script

for f in coral/sources/careops/*/manifest.yaml; do
  coral source add --file "$f"
done

Alternative Modes

# SQLite fallback (requires: npm run seed first)
CAREOPS_QUERY_MODE=sqlite npm run dev

# Mock mode (for tests only)
CAREOPS_QUERY_MODE=mock npm run dev

🧪 Testing

npm test              # Unit tests (vitest) — 16 tests
npm run test:coral    # Coral integration tests — real coral sql

📸 Demo Workflow

npm run dev → open http://localhost:3000
/data-sources → click Lint → Add → Test → Query on any source to see real Coral CLI in action
/evidence → click "Verify Coral Sources" to see coral source list output
Click "Run Live Coral Query" to execute a cross-source JOIN
Click "Generate Packet from Coral" to see the full 10-query pipeline
/packet → select patient + purpose, generate a doctor-ready packet
Export as Markdown

🔧 Configuration

Env Var	Default	Description
`CAREOPS_QUERY_MODE`	`coral_cli`	`coral_cli`, `sqlite`, or `mock`
`CORAL_CLI_PATH`	`coral`	Path to Coral CLI binary
`CORAL_CLI_TIMEOUT`	`20000`	Timeout (ms) for Coral CLI calls
`DATABASE_URL`	`file:./careops.db`	SQLite database path (fallback mode)

⚠️ Known Coral CLI Limitations

backend: file is not supported in v0.2.0 — use backend: jsonl instead
format property in table definitions causes errors with jsonl backend — omit it
Template variables ({{input.DATA_PATH}}) are not resolved when using coral source add --file — hardcode absolute paths in manifests

🧑‍💻 About Me

FiscalMindset

Open-source builder exploring Coral-powered personal agents

I build practical AI systems, source specs, and agent workflows that turn scattered data into useful products.

Name		Name	Last commit message	Last commit date
Latest commit History 18 Commits
AGENT_HANDOFF		AGENT_HANDOFF
AGENT_STATUS		AGENT_STATUS
app		app
coral		coral
data		data
docs		docs
exports		exports
graphify-out		graphify-out
graphify		graphify
public/screenshots		public/screenshots
scripts		scripts
src		src
tests		tests
video_demo		video_demo
.env.example		.env.example
.gitignore		.gitignore
CONTRIBUTING.md		CONTRIBUTING.md
README.md		README.md
index.js		index.js
next-env.d.ts		next-env.d.ts
next.config.ts		next.config.ts
package-lock.json		package-lock.json
package.json		package.json
postcss.config.js		postcss.config.js
tailwind.config.ts		tailwind.config.ts
tsconfig.json		tsconfig.json
vitest.config.ts		vitest.config.ts

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

CareOps Agent

🩺 The Problem

💡 The Solution: CareOps

🆕 What's New

🌊 Why Coral? (Track 2)

Architecture

Tech Stack

🪸 About Coral

CareOps Coral Sources

🚀 Features

💻 Tech Stack

🛠️ Setup

Prerequisites

Quick Start

Quick Registration Script

Alternative Modes

🧪 Testing

📸 Demo Workflow

🔧 Configuration

⚠️ Known Coral CLI Limitations

🧑‍💻 About Me

FiscalMindset

About

Uh oh!

Releases

Packages

Uh oh!

Contributors

Uh oh!

Languages

Folders and files

Latest commit

History

Repository files navigation

CareOps Agent

🩺 The Problem

💡 The Solution: CareOps

🆕 What's New

🌊 Why Coral? (Track 2)

Architecture

Tech Stack

🪸 About Coral

CareOps Coral Sources

🚀 Features

💻 Tech Stack

🛠️ Setup

Prerequisites

Quick Start

Quick Registration Script

Alternative Modes

🧪 Testing

📸 Demo Workflow

🔧 Configuration

⚠️ Known Coral CLI Limitations

🧑‍💻 About Me

FiscalMindset

About

Resources

Contributing

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Uh oh!

Contributors

Uh oh!

Languages

Packages