Jez | Jeremy Dawes
Back to projects
mcp active

Australian Holidays & School Terms MCP

Public holidays and school term dates for all 8 Australian states/territories. Official government data with daily refresh.

MCPCloudflare WorkersD1KV

Overview

An MCP server providing Australian public holidays and school term dates for AI assistants. Covers all 8 states and territories with data sourced from official government APIs and education departments.

5
MCP Tools
8
States/Territories
500+
Holidays
96
School Terms

The Problem

AI assistants frequently need to answer questions about Australian dates:

  • “When’s the next public holiday in Victoria?”
  • “Is next Monday a school day in NSW?”
  • “What are the Term 2 dates for Queensland?”

Currently this requires manual lookups across multiple state government websites. Each state has different data formats, APIs, and update schedules.

Solution

Unified MCP server with 5 tools covering all date queries:

Public Holidays2

List and next upcoming

School Terms3

Terms, dates, holiday check

MCP Tools

ToolDescription
get_public_holidaysList holidays for a state within date range
get_next_holidayNext upcoming public holiday from a date
get_school_termsGet all term dates for a state and year
get_term_datesSpecific term (1-4) start/end dates
is_school_holidayCheck if a date falls during school holidays

Data Sources

Public Holidays

SourceCoverage
data.gov.au APIAll states, 2021-2026
Weekly refreshAutomatic via cron trigger

School Terms

StateSource
VICdeveloper.vic.gov.au API
NSWeducation.nsw.gov.au ICS
QLDeducation.qld.gov.au
WAeducation.wa.edu.au
SAeducation.sa.gov.au
TASdecyp.tas.gov.au
ACTACT Education Directorate
NTNT Department of Education

Features

  • Complete Coverage - All 8 states/territories (ACT, NSW, NT, QLD, SA, TAS, VIC, WA)
  • Official Data - Government sources only
  • Daily Refresh - Cron trigger updates data automatically
  • Multi-Year - 2024-2026 coverage
  • Fast Edge - Sub-100ms responses via Cloudflare Workers

Architecture

MCP Request

Cloudflare Workers (Hono)

Check KV Cache

Query D1 Database

Return ISO 8601 Dates

Scheduled Refresh (Daily):
├── data.gov.au → Public Holidays
├── VIC API → VIC Terms
├── NSW ICS Parser → NSW Terms
└── State Parsers → Other 6 States

Tech Stack

  • Runtime: Cloudflare Workers
  • Framework: Hono
  • Database: D1 (SQLite at edge)
  • Cache: KV for fast lookups
  • Protocol: Model Context Protocol
  • Scheduling: Cron Triggers

Use Cases

Calendar Integration - AI assistants can check availability around holidays

School Planning - Answer parent queries about term dates and school holidays

Business Scheduling - Avoid booking meetings on public holidays

Travel Planning - Know peak holiday periods for travel advice

Event Planning - Schedule events outside school terms or on long weekends

Interested in a similar solution?

Let's talk about your project