Build a Patient Flow Board With ToolJet MCP for Bed Managers

Description and use

A live patient flow board was built with ToolJet MCP for a 600‑bed teaching hospital, consolidating admissions, occupancy, discharge queues, and delay trends into three pages that refresh every five minutes.

Problem

Hospital bed managers need a live, consolidated view of admissions, occupancy, discharges, and delay trends to make timely decisions, but printed reports become outdated quickly.

Outcome

The generated app contains 3 pages, 13 database tables, 26 queries, 52 components, and zero code files to maintain, with two repair cycles to fix a seed‑logic bug.

Workflow

• Gather live ward census and movement feed
• Group discharge reasons across the queue
• Calculate occupancy, waits, and the eight‑hour projection
• Rank the queue by total delay hours
• Review weekly delay trends and adjust priorities

Evidence

The first weekly check showed the same admissions total every day, so the trend chart looked flat and wrong. The cause was a random filter that PostgreSQL evaluated once per ward instead of once per generated day. Reworking the seed logic fixed the pattern.

Source

ToolJet MCP works through the whole application, from the data model and queries to the pages, components and wiring, and creates a structured ToolJet application inside ToolJet rather than handing back a codebase for you to assemble yourself or export into another build flow.

Source