Use WaterfallBridge with AI Agents (MCP)

An AI-callable KPI bridge analysis engine.

Your users don't want to learn a workflow — they just want to ask a question. WaterfallBridge exposes an MCP server so an AI agent can open the app, prepare the data, run the bridge, read the result and explain the drivers, all from one plain-language sentence. The math is always the deterministic WaterfallBridge engine; the AI is only the operator.

How Claude, Cursor, Codex and ChatGPT call it

Install the WaterfallBridge AI Agent (a small Windows app). In the installer, tick the AI tools you use — it registers an MCP server named waterfall-bridge for you, with no JSON editing.
Restart your AI tool. You'll see waterfall-bridge listed as a tool source (e.g. in Cursor under Settings → MCP).
Sign in once from the chat, then point the agent at a file and ask your question.

You → any MCP client
"Use waterfall-bridge to analyze D:\Data\sales-2024.xlsx and tell me why 2024 Q4 margin % dropped versus 2023 Q1, broken down by product."

The full step-by-step setup for each tool — including the in-app "Ask AI" panel — is in the AI Assistant guide.

Inputs and outputs

Supported inputs

CSV files
Excel files (.xlsx / .xlsm)
Dimension — what to break the change down by
Key — the contribution-analysis breakdown
Result — the KPI you want explained
SumY — numerator for rate metrics
SumN — denominator for rate metrics

Returned outputs

Bridge / chart table (baseline → comparison)
Driver contribution analysis by key
Added data and removed data rows
Plain-language root-cause insight
Optional Excel / report export (on request)

The MCP tool surface

The waterfall-bridge server exposes a focused set of tools that an agent chains together:

open_app  →  check_data_preparation  →  suggest_bridge_schema  →  prepare_bridge_xlsx
        →  upload_file  →  run_bridge  →  set_baseline / set_comparison  →  run_analysis
        →  get_chart_data + get_contribution_table + get_insights  →  export (optional)

Tool	What it does
open_app	Starts the WaterfallBridge engine session.
check_data_preparation	Validates the file is a flat, one-row-per-record table and lists fixes if not.
suggest_bridge_schema	Proposes the Dimension / Key / Result / SumY / SumN mapping for confirmation.
run_bridge / run_analysis	Runs the deterministic bridge math on the baseline and comparison.
get_chart_data / get_contribution_table / get_insights	Returns the bridge, the driver contribution by key, and a root-cause narrative.
export_xlsx / export_report	Produces a deliverable file — only when you ask.

Security & data handling

No user data is stored on our servers. Your file is processed locally and only lightweight algorithm requests reach the server to run the bridge math. The deterministic, closed-form algorithm runs through your account; the AI never invents numbers. Your login session and AI keys stay encrypted on your machine, and the agent can only read folders you approve (by default Downloads, Desktop and Documents).

Account required. Full analysis needs a WaterfallBridge account with an active subscription. You can try the free demo first. The AI Agent is currently Windows-only; macOS support is coming.

Frequently asked questions

How do I call WaterfallBridge from Claude, Cursor, Codex or ChatGPT?

Install the WaterfallBridge AI Agent on Windows and tick the AI tools you use. The installer registers WaterfallBridge as an MCP server named waterfall-bridge. Restart the AI tool, then ask in plain language, for example: "Use waterfall-bridge to analyze sales-2024.xlsx and explain why Q4 margin dropped versus Q1."

What inputs does the WaterfallBridge MCP server accept?

It accepts CSV and Excel (.xlsx/.xlsm) files. You configure the bridge schema with Dimension, Key, Result, SumY (numerator) and SumN (denominator). The agent can suggest the schema automatically and ask you to confirm.

What outputs does WaterfallBridge return to the AI agent?

It returns a bridge / chart table, a driver contribution analysis broken down by the chosen key, added and removed data rows, and a plain-language root-cause insight. The agent uses these to write the explanation.

Is user data stored on the server and does the algorithm run on the server?

No user data is stored on WaterfallBridge servers. Files are processed locally; only lightweight algorithm requests reach the server to run the deterministic bridge math. Login sessions and AI keys stay encrypted on your machine. A WaterfallBridge account with an active subscription is required for full analysis.

Use WaterfallBridge with AI Agents