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.
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:
The three moving parts
- 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.
- Claude pulls the numbers and writes a single self-contained HTML dashboard. You iterate on it in the artifact panel until it's right.
- 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:
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.
Step 2 — Pull the numbers
Ask Claude in plain language. It uses the MCP server's read tools to fetch real data:
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 renders it live in the artifact panel. Iterate in place — you're not regenerating from scratch:
- "Make runway the most prominent number after balance."
- "Color the trend line red if burn is accelerating."
- "Exclude the inter-account transfers from the burn calculation."
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 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:
The link stays stable while the content updates underneath it — see keeping a canvas updated automatically.
What to watch for
- Read-only, always. A cash dashboard needs read access and nothing more. Mercury's MCP server is read-only by design; if you use a raw API token instead, scope it read-only.
- Check the figures before you share. The MCP returns exactly what you ask for — if your "burn" query includes a one-off equity inflow or counts inter-account transfers, the runway will be confidently wrong. Reconcile against the Mercury dashboard once.
- The link is the deliverable, not the artifact. Share the Drafty URL, not the Claude artifact preview — that's the one you can update in place.
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.