Open Holidays Connector to ChatGPT
Ask Open Holidays questions in ChatGPT using OWOX Data Marts. Collect Open Holidays data into a governed data mart, then get answers in ChatGPT 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 ChatGPT
- You
Did public holidays affect our sales last quarter?
- ChatGPT
Public Holidays (open_holidays_public_holidays) lists holidays by date and country. I marked each holiday date in your sales Data Mart for last quarter and compared those days with ordinary days on the same weekday.
This comes from your governed Data Marts through the OWOX MCP server, so it is as fresh as their last scheduled refresh.
- You
Which upcoming holidays should we plan campaigns around?
- ChatGPT
Filtering the same table to future dates, for the countries you sell in, gives the calendar. I listed them by date so you can set budgets before each one.
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.”


