Connector

Enable business reporting from your AWS Redshift data

Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Claude.

AWS RedshiftConnected
Data MartPublishedone definition
ClaudeDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

A quarter-on-quarter question to Claude ends in SQL nobody reviewed, run on AWS Redshift tables it barely knows.

Paste this into your AI assistant. It connects Claude to the AWS Redshift Data Marts you expose through the OWOX MCP server, so it runs them for both periods and every number comes from governed SQL.

The prompt

connect Claude to my AWS Redshift Data Marts through the OWOX MCP server and compare this quarter with last quarter: main measures side by side, with the change for each

S01 · Step 1

Start from your AWS Redshift data

Connect OWOX to your Amazon Redshift database, Serverless workgroup or provisioned cluster. Your Data Marts read the tables and views in its schemas.

  • Nothing to move or copy.
AWS RedshiftYour data warehouseSchema
Unified Ad SpendConnected dataNothing to move or copy

S02 · Step 2

Build a reporting library in AWS Redshift

Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the data model.

  • Business users browse reports, not tables.
Data martsUnified Ad SpendAISessionsAI
Unified Ad SpendData modelplatform_roas · platform_cpa
Unified Ad Spend + Sessions
SessionsJoined by a shared key

S03 · Step 3

Ask Claude about your AWS Redshift data

Add the OWOX MCP server in Claude (Settings > Connectors). Claude finds the right Data Mart and queries it, and sees only the Data Marts you expose.

  • Business questions answered from trusted data.
ClaudeWhich ad platform had the lowest CPA last week?get_relevant_data_marts_by_promptquery_data_martplatform_roasplatform_cpa

S04 · Step 4

Keep Claude connected to the same data

Ask in Claude, export to a sheet, share with the boss.

  • One source, every tool.
Unified Ad SpendOne source
ClaudeAsk in chat
Google SheetsExport to a sheet
Your bossShare the answer

Recent updates

Why OWOX

Why OWOX for AWS Redshift to Claude

An assistant is only as good as the data it sees. OWOX gives it governed Data Marts on your AWS Redshift data, not the whole database.

  • Yours in AWS. The data stays in your own Redshift database, under your access rules.
  • Your access key. OWOX connects with the AWS access key you create, to the workgroup or cluster you choose.
  • Governed answers. The assistant queries only the Data Marts you expose, with SQL your analysts wrote.
  • An audit trail. See what Claude asked and what it got back.

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