health_query
Run read-only DuckDB SQL queries on Apple Health export data to extract health metrics, using a semantic layer to prevent aggregation mistakes.
Instructions
Run a read-only DuckDB SQL query against the health tables. Call health_schema first so you know the columns and the correct aggregate function for each metric.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return (default 1000, maximum 5000). | |
| query | Yes | A single SELECT or WITH statement. |