Project Staffing Skills Matcher

The problem this kills

You staff projects from memory. The same three reliable people get grabbed for everything, they burn out, and the folks quietly building exactly the right skills never get the call. Meanwhile your skills matrix lives in one spreadsheet, everyone's availability in another, and the actual decision happens in a hallway conversation that nobody can reconstruct three weeks later when someone asks "why was she assigned to that?"

The result is over-allocation you only discover when something slips, no record of why anyone was chosen, and a development plan that never turns into actual stretch assignments because nobody can see the opportunity at the moment of staffing.

What you'll build

A private web app for your team that turns staffing into a repeatable, data-driven step:

• You enter a project's required skills, dates, and effort.
• The tool ranks your available people by how well their skills fit and how much real capacity they have left.
• It drafts a staffing proposal - including the skill gaps, partial allocations, and any stretch-assignment opportunities for people who are almost there.
• A resource manager reviews and approves before anyone is committed or notified. Over-allocation is flagged and must be resolved before approval.
• Approved assignments are recorded with a full audit trail and the assigned people are notified by email.
• You can export the whole staffing plan as a CSV in the columns your existing systems expect.

What's inside the Implementation Plan

The plan is a single file you paste into Claude Code. It builds the whole tool with you, step by step, in plain language.

It starts by interviewing you about your business. Before any code is written, the plan has the AI ask you about your current staffing process, the systems and spreadsheets you use, exactly how your skills and ratings are named, your real capacity and allocation rules, and your messy edge cases. It reflects a short tailored spec back to you for a thumbs-up - so the tool fits your org, not a generic template.

From there it covers:

• The exact data model for your skills matrix, roster, capacity, and projects - shaped by your answers.
• The ranking logic for skill fit plus available capacity, with skill gaps surfaced (not hidden).
• The staffing-proposal screen, the approval gate, and the over-allocation flag.
• Email notifications for approved assignments.
• The "No API yet?" path: import your matrix and availability from Google Sheets or CSV, and export a clean staffing CSV - so it is fully buildable today.
• Copy-paste prompts for every step.

The governance it includes (this is the point)

This is not a toy. Every plan bakes in the controls that make an internal tool safe to actually use:

• Login so only your team can open it.
• Row-level security so people only ever see their own organization's data.
• A complete audit trail - who ranked, who approved, who was assigned, and when.
• A hard human-in-the-loop approval gate - the AI drafts the staffing proposal, the resource manager reviews and approves, and only then are assignments recorded and people notified.
• Duplicate guards so the same person can't be double-committed to the same project and date range twice.

Who it's for

Resource managers, project managers, and ops leads who staff projects from memory and keep overloading the same reliable people. If you want staffing to be defensible, balanced, and a genuine development tool - and you are not a developer - this is for you.

You've got this - paste the first prompt and let the plan interview you.