Ask Claude about Open Holidays in your data
A sales dip on a public holiday is not a problem to fix. Load the holiday calendar into your data warehouse, join it to orders by date and country, then ask Claude which days were a calendar effect.
Claude plans next week's ad schedule without knowing which of your countries have a public holiday.
Paste this into your AI assistant. It loads Open Holidays into your data warehouse as a Data Mart by country and connects Claude through the OWOX MCP server, so answers use the real calendar.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/open-holidays-connector-to-claude.md. The task: connect Claude to my Open Holidays data, list which of our countries have a public holiday next week and say whether our ad schedule should change for them. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.
Why Open Holidays does not go straight to Claude
Claude can name a public holiday, but that does not show whether a drop in orders on that day was the calendar or a real problem. Holidays, sessions and orders sit apart, and a reliable, business-ready join belongs in a warehouse first.
- Open Holidays says which days are public holidays; the orders live in your store data
- A weak day is only a problem if no holiday explains it, so the join belongs in your data warehouse
- Claude answers from that linked data, controlled by the data analyst
Step 1: Load Open Holidays into your data warehouse first
Create a Data Mart with Open Holidays as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Public Holidays, with the date, name, type and regional scope of each holiday
- Set one country ISO code and a language per Data Mart, and refresh on a schedule
- Open the Open Holidays connector for your data warehouse below
Step 2: Link Open Holidays to sessions and orders
In your data warehouse the model joins the holiday calendar to orders and sessions by date and country. Use one Data Mart per country, with the country set as the key. Pick an industry to see the shape of its model.
- Holidays line up with orders and sessions by date and country
- A calendar effect is separated from a real drop by SQL keys, not VLOOKUP
- Measures such as conversion_rate are defined once
Step 3: Connect Claude to your Open Holidays data with OWOX MCP
Add the OWOX MCP server in Claude under Settings > Connectors > Add custom connector. Claude then sees the Data Marts you publish and queries them through MCP.
- Settings > Connectors > Add custom connector, paste the OWOX MCP URL and sign in
- Claude sees only the Data Marts you publish
Step 4: Ask Claude whether a drop was a holiday
Ask in plain words. Claude finds the right Data Mart and queries it, so the numbers come from your data warehouse and not from a guess.
- Ask about a day or a country in plain words
- The answer sets holiday days against orders and sessions, with measure names shown
Step 5: Export the answer to Google Sheets, CSV or XLS
Optional: in one click send Claude's answer, or the data behind it, to Google Sheets, CSV or XLS to check it or share it.
- Verify the answer in a sheet before it goes to stakeholders
- One Data Mart feeds the chat, the sheet and the file
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Support MCP protocol 2026-07-28 and alert on compatibility failures
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Destinations tab now promotes connecting an AI assistant alongside your existing destinations
Why OWOX for Open Holidays in Claude
Open Holidays in a chat names a holiday. OWOX adds the orders and sessions around it, from data you own.
- You own the data. It lands in your own data warehouse, in tables you control.
- Calendar effect or real drop. Holidays are joined to orders and sessions by date and country, not read from a calendar page.
- Zero hallucinations on your data. Claude answers from governed Data Marts and shows the measure names it used.
- Maintained for you. No scripts to fix when the Open Holidays API changes.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.
