Connector

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.

Get started free

Endpoints

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

Data schema

Open Holidays data schema

Public Holidays 7 fields · open_holidays_public_holidays
Open Holidays Public Holidays fields
FieldTypeDescription
idSTRINGUnique identifier for the holiday
dateDATEDate of the holiday
nameSTRINGName of the holiday in the specified language
typeSTRINGType of holiday (public, school, etc.)
regionalScopeSTRINGRegional scope of the holiday
temporalScopeSTRINGTemporal scope of the holiday
nationwideBOOLEANWhether the holiday is nationwide

In ChatGPT

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.

Trust

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

npm installs

156K

In Open Source We Trust

Customers

What users are saying

Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“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.”
C9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
E7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”

Turn your Open Holidays Connector to ChatGPT data into business decisions

Get started free