drafty
Mercury logo

Build a Mercury cash dashboard with Claude

Connect the Mercury MCP server to Claude, ask for a balance, burn, and runway dashboard from your live numbers, and publish it to a link your team comments on directly — no spreadsheet, no screenshots pasted into Slack.

What you'll build
A self-contained cash dashboard — total balance across accounts, net monthly burn, runway in months, balance trend, and recent transactions — generated by Claude from your real Mercury data, then published to a drafty.im/canvas/… link. Your team clicks the exact tile or number they want changed and leaves a note. Claude reads the comments and ships a revised version to the same URL.

This is an end-to-end example: connect a data source over MCP, generate a dashboard from live numbers, and close the review loop on one link. Total time, start to shared link, is under fifteen minutes. The same shape works for any of the other examples — only the connection step changes.

Here's the finished dashboard, published to a canvas — click any tile or number to leave a comment, exactly as your team would:

Live canvas — comment on any elementOpen ↗

The three moving parts

  1. The Mercury MCP server gives Claude read access to your Mercury account — account balances, transactions, statements, recipients, cards — through a controlled set of tools. It's read-only by design; the AI can analyze your data but can't move money.
  2. Claude pulls the numbers and writes a single self-contained HTML dashboard. You iterate on it in the artifact panel until it's right.
  3. Drafty turns that HTML into a stable link your team reviews. Comments pin to the exact element; Claude ships the fix to the same URL.

The generation step is fast now. The part this example is really about is the third one — getting the dashboard in front of people without losing their feedback to a screenshot circled in Preview.

Step 1 — Connect the Mercury MCP server

Mercury runs an official remote MCP server at https://mcp.mercury.com/mcp. You connect once; it authenticates over OAuth, so no API token is pasted into a config file. The server is read-only — it exposes balances, transactions, and statements, not money movement.

In Claude Code:

claude
claude mcp add --transport http mercury https://mcp.mercury.com/mcp

Then run /mcp inside Claude Code and follow the OAuth prompt to authorize the account.

In Claude Desktop: open Settings → Connectors → Add custom connector, paste https://mcp.mercury.com/mcp, and authorize with OAuth the same way.

Safety first
Mercury's MCP server is read-only by design, so it can never initiate a transfer. If you'd rather wire up the raw Mercury API for an unattended agent instead of OAuth, generate a read-only API token (Mercury supports read-only, read-write, and custom tokens) — never a read-write one for a reporting dashboard, and never commit it to a repo.

Step 2 — Pull the numbers

Ask Claude in plain language. It uses the MCP server's read tools to fetch real data:

claude
Using the Mercury MCP server, pull everything we need for a cash dashboard: total balance across all accounts, the per-account breakdown, net cash burn over the last 30 days (inflows minus outflows), the same for the prior 30 days for comparison, runway in months at the current burn rate, the daily balance over the last 90 days, and the 10 most recent transactions. Summarize the figures before you build anything.

Claude calls Mercury, returns the figures, and you sanity-check them against the Mercury dashboard before going further. This is the moment to catch a wrong assumption — an account you forgot to include, a one-off transfer skewing the burn, a credit card balance counted as cash — while it's cheap.

Step 3 — Build the dashboard

Once the numbers look right, ask for the artifact:

claude
Build a single self-contained HTML dashboard from those figures. Total balance as the hero number with month-over-month change, then tiles for net monthly burn and runway in months, a 90-day balance trend chart, a per-account breakdown, and a recent-transactions table at the bottom. Clean, no external dependencies — inline the CSS and any chart code.

Claude renders it live in the artifact panel. Iterate in place — you're not regenerating from scratch:

Step 4 — Publish to Drafty for review

A Claude artifact link is a preview, not a stable URL — iterate the artifact and the link you already sent now shows the old version. Ask Claude to publish it to a Drafty canvas instead, so the link you share always stays current:

claude
Publish this dashboard to Drafty as a canvas and give me the shareable link.

Claude pushes the dashboard and hands back a drafty.im/canvas/… link that renders on any device. Send it — your team opens it in a browser, no login and no Claude account needed.

Step 5 — The review loop

This is the part that's not obvious until you've done it once.

A reviewer clicks the specific tile, chart, or number they want changed and leaves a pinned comment — "this runway looks optimistic, are we counting the annual SaaS renewals that hit next month?" The comment is anchored to that element, not floating in a Slack thread. Claude reads the comments through the CLI, reruns the relevant Mercury query if needed, and pushes a revised dashboard to the same URL. The reviewer refreshes and sees the change; the thread stays attached to the element.

The mechanic matters because of what it removes. A Slack message about a chart produces "the number on the left looks wrong." A pinned comment on the actual tile produces "this — exclude the inter-account transfer from the burn." One of those produces a correct revision; the other produces a guess.

Keeping it fresh

An MCP-generated dashboard is a snapshot — it holds the numbers Claude pulled when it built it; it doesn't re-query Mercury when someone opens the link. For a weekly cash review or a board-ready snapshot, that's fine.

To make it a live canvas that always shows today's figures, copy this prompt — Claude sets up the refresh for you and schedules it to run on its own:

claude
Turn this Mercury dashboard into a live canvas: every morning, re-pull the latest balances, burn, and runway from Mercury via the MCP server, rebuild the dashboard, and push a new version to the same canvas URL so the link always shows today's figures. Schedule it to run daily on its own.

The link stays stable while the content updates underneath it — see keeping a canvas updated automatically.

What to watch for

Mercury dashboard with Claude — FAQ

Do I need to paste my Mercury API token anywhere?
No. The remote Mercury MCP server at mcp.mercury.com authenticates over OAuth, so you authorize the account through a consent screen instead of pasting a token. If you'd rather wire up the raw Mercury API for an unattended agent, use a read-only API token — never a read-write one, and never committed to a repo.
Is the dashboard live or a snapshot?
A snapshot. It contains the numbers Claude pulled when it built the file; it does not re-query Mercury when someone opens the link. To refresh it, ask Claude to repull and re-push to the same URL — or put that on a daily schedule so the stable link always shows current balances.
Can my team comment without a Mercury or Claude account?
Yes. The dashboard is published to a Drafty canvas link that renders in any browser. Reviewers click the exact element they want changed and leave a pinned comment with no login required. Only the person connecting Mercury needs access to the account.
Is it safe to give Claude access to my Mercury account?
Mercury's MCP server is read-only by design — it can query balances and transactions but cannot move money or initiate transfers. You authorize over OAuth and can revoke access at any time. For a reporting dashboard that's exactly the access you want and nothing more.
How is this different from exporting Mercury statements to a spreadsheet?
A spreadsheet export is a static file you maintain by hand and re-share every time the numbers change. This approach is for a fast, shareable dashboard you spin up in minutes by talking to Claude, then collect feedback on inline — and can put on a daily refresh so the same link always shows current cash. Different jobs: one is a manual artifact, the other is a quick reviewable deliverable that stays current.