# stelo-workaround-mcp

FastAPI service to import Dexcom Stelo/Clarity CSV exports into SQLite, with MCP endpoints for Simtheory.ai.

## Why?

Dexcom API v3 does not support Stelo device data. This workaround lets you:
1. Export CSV from Dexcom Clarity
2. Import into local SQLite database
3. Query via MCP endpoints

## Endpoints

| Method | Path | Description |
|--------|------|-------------|
| POST | `/import` | Upload Clarity CSV file |
| GET | `/glucose/latest?hours=24` | Last N hours of readings |
| GET | `/glucose/range?start=&end=` | Date range query |
| GET | `/glucose/stats?days=14` | TIR, avg, GMI, CV stats |
| GET | `/mcp` | MCP manifest for Simtheory.ai |
| GET | `/health` | Health check |

## Deployment

### Docker (Coolify)

```bash
docker build -t stelo-workaround-mcp .
docker run -d -p 8085:8085 -v ~/data:/data stelo-workaround-mcp
```

### Manual

```bash
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt
uvicorn main:app --host 0.0.0.0 --port 8085
```

## Usage

```bash
# Import CSV
curl -X POST -F "file=@clarity_export.csv" http://timserver:8085/import

# Get stats
curl http://timserver:8085/glucose/stats

# Last 24h
curl http://timserver:8085/glucose/latest
```

## Schema Migrations

Auto-migrations run on startup. To add a new migration:
1. Increment `LATEST_SCHEMA_VERSION`
2. Add migration function `_apply_migration_vN()`
3. Register in `MIGRATIONS` dict

## License

MIT