Beyond ClickUp Dashboards: Building Custom Reporting with Claude, Supabase and Cursor

ClickUp's native dashboards are genuinely good for a single workspace's operational view — but they hit a ceiling the moment a business needs to report across systems (ClickUp plus a CRM plus an accounting package), needs a calculation the built-in widgets don't support, or wants to hand a client a live view of their own data without giving them a ClickUp seat. That's the point where a thin custom reporting layer — a Supabase database assembled with AI coding tools like Claude Code or Cursor — starts to make sense, not as a replacement for ClickUp's dashboards but as the next layer up for decisions that need data ClickUp alone can't give you.

I'm Jack Lenton, a ClickUp Verified Consultant and Zapier Silver Solutions Partner running Toki, an automation consultancy based in Norwich. If you've read my piece on what owners should actually track in ClickUp, this is what comes after that dashboard stops being able to answer the question you actually need answered.

Where do native ClickUp dashboards actually stop being enough?

Three places, consistently. Cross-system data — a number that only makes sense once ClickUp task data is combined with figures from your accounting package or CRM, which neither tool can do on its own. Custom calculations — a metric specific enough to your business that no dashboard widget was built to produce it. And client-facing reporting — wanting to give an external party a live, read-only view of their own numbers without the cost, admin or security question of a full workspace seat.

What does "Claude, Supabase and Cursor" actually mean in practice?

Supabase is a hosted Postgres database with a built-in API, quick to set up and run without a dedicated database administrator — it's the place the combined data actually lives. Claude Code and Cursor are AI coding assistants that can write and maintain the glue code: pulling data in from ClickUp, Zapier or other systems, shaping it, and rendering a simple page or dashboard that reads from it. Together, they let someone who understands the business problem — not necessarily a software developer — get a working reporting layer built far faster than commissioning custom software the traditional way. Supabase also has its own MCP server, which means an AI assistant can query and manage the database directly as part of the build, in much the same way Zapier's MCP server connects an assistant to thousands of apps.

What does a first version of this actually look like?

Small, deliberately. A single Supabase table holding the handful of numbers that actually matter — the same kind of shortlist I've written about for owner-level ClickUp reporting — populated by a scheduled job or a Zapier automation pulling from the systems that hold them, and one simple page that reads from that table. Not a full application, not a client login system on day one — just proof that the combined number is right and useful before anything more gets built on top of it.

Is this actually worth it for a small business?

Not for every business, and it's worth saying that plainly. If ClickUp's native dashboards already answer the questions you're asking, adding a custom reporting layer is extra maintenance for no real gain. It earns its place specifically when the reporting need has genuinely outgrown what a single-system dashboard can do — cross-system figures, bespoke calculations, or a client who needs their own view — not as a default upgrade because it sounds more advanced.

Frequently asked questions

Do I need to replace ClickUp dashboards with this?
No. This sits alongside ClickUp's native dashboards for the specific reporting they can't do — cross-system numbers, custom calculations, or client-facing views — not as a general replacement.

Do I need to be a developer to use Claude Code or Cursor for this?
For a first, narrow version, increasingly no — these tools are built to let someone who understands the business problem build and iterate without a traditional development background. Anything handling sensitive client data at scale is still worth a proper technical review.

What's the first thing to build if I want to try this?
One Supabase table holding the handful of numbers that actually matter to your business, fed from your existing systems, and one simple page reading from it — not a full custom application on day one.

Almost done! When you're ready, here are four ways I can help you:

1. Read it. A guide on how to use ClickUp and actually make it work for you.
2. Connect it. Let's be LinkedIn pals. I make funny videos sometimes.
3. Workshop it. Book a 30-minute chat to talk processes and build a Miro together.
4. Go for it. Fill in my contact form — let's talk ClickUp or Automations. Whatever tickles your pickle.

Wanna hear from the unfiltered version of me? Sign up to my newsletter. The Working Notes. 2 minute reads. Behind the scenes. Hopefully helpful. Maybe funny.