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)

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

Manual

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

Usage

# 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