Festival Noise Monitoring Dashboard

Expert assistant for working with a Next.js 15 application that monitors noise levels and weather data across multiple stations, featuring real-time monitoring, data visualization, CSV processing, and administrative tools.

What This Skill Does

This skill provides specialized knowledge for developing and maintaining a noise monitoring dashboard application. It understands the project's architecture, database schema, API endpoints, testing setup, and deployment considerations specific to this real-time monitoring system.

Key Technologies & Stack

Instructions for AI Assistant

1. Understanding the Project Structure

When working with this codebase, be aware of these key directories:

2. Database Schema & Data Management

The SQLite database has these critical tables:

**Important:** Always consider the aggregated data table when optimizing queries or implementing new features that display time-series data.

3. Core Features to Maintain

When modifying or extending the application, preserve these key features:

1. **Real-time Monitoring:** Station data updates automatically

2. **Data Visualization:** Chart.js and Recharts for time-series display

3. **CSV Processing:** Automatic processing with file watchers

4. **Admin Panel:** Configuration and data management tools

5. **Alert System:** Browser notifications for threshold violations

6. **Performance:** Caching strategies and aggregated data views

7. **Pagination:** Efficient loading for large datasets

4. API Endpoint Structure

Primary endpoints include:

When creating new endpoints, follow the existing patterns for error handling, logging, and response formatting.

5. Development Workflow

**Before making changes:**

```bash

Type check

pnpm type-check

Run tests

pnpm test

Lint code

pnpm lint

```

**After making changes:**

```bash

Run tests with coverage

pnpm test:coverage

Build to verify production readiness

pnpm build

```

6. Testing Requirements

All new features should include:

7. Database Operations

**For schema changes:**

```bash

Run migrations

pnpm migrate

Verify with health check

pnpm health-check

```

**For data management:**

```bash

Create backup before major changes

pnpm db:backup

Restore if needed

pnpm db:restore

```

8. Performance Optimization

When implementing features that query large datasets:

1. Use the `measurements_15min_agg` table for time-series queries

2. Implement pagination for list views

3. Apply appropriate caching strategies

4. Monitor query performance in logs

5. Consider impact on cron job performance

9. Error Handling & Logging

10. Deployment & Monitoring

Before deploying:

11. Code Quality Standards

Example Usage Scenarios

**Adding a new monitoring station:**

1. Update database schema with new station entry

2. Add station to threshold configurations

3. Ensure CSV processing handles new station data

4. Update dashboard UI to display new station

5. Test with sample CSV data

6. Verify aggregated data generation

**Optimizing chart performance:**

1. Check if aggregated data table is being used

2. Implement data point limiting for large time ranges

3. Add appropriate caching headers

4. Test with maximum data volume

5. Monitor query execution time in logs

**Implementing new admin feature:**

1. Create protected API endpoint under `/api/admin/`

2. Add authentication checks

3. Implement comprehensive error handling

4. Write integration tests

5. Update admin UI components

6. Test with various permission levels

Constraints & Important Notes

When to Use This Skill

Invoke this skill when: