- How long since I last took a holiday?
- What's the day I most commonly go to the gym?
You already track your life in your calendar, now create useful insights from that data.
QueryCal lets you answer these questions and more by letting you query your calendar with SQL.
QueryCal works with any service that lets you share your calendar in iCal format. Whatever your calendar, you can easily give QueryCal read-only access.
QueryCal uses the SQLite database engine to execute your queries. Calculate metrics as complicated as you like using the full power of SQL.
Whether it's Grafana, Google Sheets, or Home Assistant, QueryCal easily connects with your existing tools.
This demo lets you query the Holidays in United Kingdom calendar. It's running the same SQLite query engine that's used by the rest of QueryCal so can run any SQL query you like. The database schema is described here in the docs.
The example query calculates how many holiday days there are in each month.