Living Room Air Quality Monitor

This skill manages automated collection and reporting of air quality data from the living room ALPSTUGA air sensor connected to the IKEA Dirigera hub.

What It Does

• Collects data every hour via cron for detailed tracking
• Stores in SQLite database with schema: datetime, temperature, humidity, pm25, co2
• Skips incomplete readings — only saves when all sensor values are present
• Provides query functions for retrieving data by datetime, day, month, or interval
• Calculates averages for any metric (temperature, humidity, PM2.5, CO2) by day or month
• Generates line charts for day, week, month, 3 months, 6 months, or year views
• Sends reports via email or WhatsApp (requires CONTACTS.json configuration)

Note: For smoke/fire detection with alerts, use the separate living-room-smoke-detector skill.

Setup

1. Database Initialization