Connector

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.

Open HolidaysConnectedPublic Holidays
Data MartPublishedone definition
ClaudeDateIdNameDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

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

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

Endpoints

Open Holidays Endpoints

Documentation

1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

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 data 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
Open HolidaysHolidays by date
Claude
No link to orders
Data warehouseJoined by id
Web analyticsSessions by day
OrdersOrders by day

S01 · Step 1

Step 1: Load Open Holidays into your data warehouse first

Create a Data Mart with Open Holidays as the data 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
Open Holida…Data Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
open_holidays.public_holidays

S03 · Step 3

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 OWOX MCP.

  • Settings > Connectors > Add custom connector, paste the OWOX MCP URL and sign in
  • Claude sees only the Data Marts you publish
ClaudeConnectorsOWOX MCPAddConnected
Data martsOrdersSessionsCountries

S04 · Step 4

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
ClaudeWas last week's drop a holiday effect?get_relevant_data_marts_by_promptquery_data_martorders_totalconversion_rate

S05 · Step 5

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
Answerorders_total
ExportGoogle SheetsCSVXLSOne click

Recent updates

Why OWOX

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.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers