Data warehouse connector

Victron's data, in your AI assistant.

Ask Claude or ChatGPT about sales, stock, RMAs and orders in plain language. Every answer comes from the warehouse, with the SQL it ran.

https://dwh-mcp.ytec.nl/mcp
7 November 2026latest dataNightlyrefreshClaude · ChatGPTsupported assistants
Which countries grew most in Q3 compared with last year?
run_query · v_sales_monthly · 6 rows
The assistant answers in plain language, with a small table, and you can expand the tool call to see the exact SQL it ran.
Example

What you can ask

Questions colleagues ask today. The assistant finds the right table, writes the SQL and shows its work.

Connect your assistant

Once per device. You sign in with your Victron OneID account; an admin gives you access the first time.

Claude

  1. Open Settings → Connectors, find Victron DWH and click Connect.
  2. Sign in with your OneID account.
  3. In a new chat, enable the connector in the tools menu and ask your question.

ChatGPT

  1. Open Settings → Apps, find Victron Datawarehouse and click Connect.
  2. Sign in with your OneID account.
  3. In a chat, click +, tick the app, and ask your question.

Other MCP clients: use the server URL above. Full instructions are in the user guide.

Tools the assistant can use

Read-only by default. Writing is limited to your own tables, and access changes to admins.

ToolWhat it doesAccess
run_queryRun a read-only SELECT on the warehouse (60 seconds, logged with your name)Read
list_tables · describe_tableFind tables and their columns, with descriptionsRead
glossaryDefinitions of metrics such as gross margin and active customerRead
save_result · save_table · delete_tableKeep a result as your own table for later questionsYour own tables
suggest_definitionPropose a new or better definition for reviewReview
grant_access · list_accessGive a colleague accessAdmins only