Open Holidays Connector to Claude
Ask Open Holidays questions in Claude using OWOX Data Marts. Collect Open Holidays data into a governed data mart, then get answers in Claude via OWOX's MCP server — every number traces back to analyst-written SQL.
Open Holidays endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your warehouse.
Public Holidays
Contains public holidays data for different countries and languages
7 fieldsTime seriesopen_holidays_public_holidays
Open Holidays data schema
Public Holidays 7 fields · open_holidays_public_holidays
| Field | Type | Description |
|---|---|---|
id | STRING | Unique identifier for the holiday |
date | DATE | Date of the holiday |
name | STRING | Name of the holiday in the specified language |
type | STRING | Type of holiday (public, school, etc.) |
regionalScope | STRING | Regional scope of the holiday |
temporalScope | STRING | Temporal scope of the holiday |
nationwide | BOOLEAN | Whether the holiday is nationwide |
Ask Open Holidays questions in Claude
- You
Which countries have a public holiday next week?
- Claude
From open_holidays_public_holidays I returned the holidays whose date falls next week, grouped by country.
It is read from your governed Open Holidays Data Mart through the OWOX MCP server and reflects that Data Mart's last scheduled refresh.
- You
Should our ad schedule change for them?
- Claude
Joined with your ad performance by date and country, past holiday dates show whether clicks and conversions rise or fall on those days, which tells you whether to raise or lower budgets for the next ones.
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
Every claim has a receipt.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
“We regained time. And time is the one resource that never comes back.”


