Build a Patient Flow Board With ToolJet MCP for Bed Managers

说明与用途

使用 ToolJet MCP 为 600 座位教学医院构建了实时患者流动板，将入院、占用、出院队列和延迟趋势整合到三页中，并每5分钟自动刷新。

问题

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.

结果

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.

工作流

• 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

证据

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.

来源

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.

来源