# Build a Fishbowl Picking Dashboard with AI (Open Picks, Short Picks, Picker Leaderboard)

> A Fishbowl picking dashboard built live with ILC MCP: open picks, short picks and a picker leaderboard, no Jasper report required.

[Watch the video](https://customer-w58k7541hezxj5p9.cloudflarestream.com/e9b57d1f521c95f6705550ad7c9923a3/iframe)

Picking is a throughput problem, and throughput is hard to see. Fishbowl has the picks; what it doesn't give you is a live board of where they all stand right now.

In this video I don't build a report. I ask [ILC MCP](/fishbowl-mcp) for the Picking Operations Dashboard and it builds it live, against a Fishbowl database, writing the queries itself. No Jasper editor, no paid reporting add-on, no ticket to a consultant.

That's the point of the dual approach: Fishbowl's built-in reporting is rigid, and anything custom usually means iReport/Jasper or a third-party tool. Here the AI reads the live data through the MCP and lays the numbers out for you.

The Picking Operations Dashboard puts the picking questions on one screen:

- Open picks by status and age
- Short picks — stuck waiting on stock
- Picker leaderboard by throughput
- Orders ready to ship once picked

The demo runs on representative sample data, so nothing here is a real customer's numbers — but it's the same build you'd run against your own Fishbowl.

More on building live against Fishbowl this way: [How to write 4 reports with AI in Fishbowl](/blog/write-fishbowl-reports-with-ai).

---

*From Israel Lopez Consulting (ILC). Custom Fishbowl Inventory integrations and software, and Fishbowl experts since 2015. Written by Israel Lopez, published October 31, 2026. Questions about this topic, or want to reach the people who wrote it? Visit https://israellopezconsulting.com/contact*