MCP Prompt Library

MCP Prompt Library

Use these ready-to-copy prompts to help you generate reports and insights from Loft47 using MCP.

Each prompt includes recommended filters and formatting instructions to help you get more accurate results.

How to Use

  • Select a prompt below.
  • Copy and paste it into Claude AI.
  • Replace the placeholders (date range, brokerage ID, office ID, agent name/ID, etc.) with your own values.
  • Run the prompt and customize it further as needed.

📈 Production & Agent Performance

YOY Agent GCI Comparison
Compare agent Gross Commission Income year-over-year using closed transaction dates.
➡️ [MCP Prompt: Year Over Year Agent GCI Comparison]
"For brokerage [X] on Loft47 Production, compare each agent's Gross Commission Income — defined as total commission before deductions (totalCommissions) — year-over-year using closedAt as the date field: Jan 1 through today's date, vs. the same period last year. Group by agent, show total GCI for each period, the dollar change, and the % change. Exclude voided and collapsed deals. Sort by % change descending."

If user actually wants the net-of-split definition instead, they'd swap that clause to: "defined as net commission after brokerage split."

Monthly Production Review
Review monthly brokerage production, including sales volume, GCI, units closed, and top producing agents.
➡️ [MCP Prompt: Monthly Production Review]
"For brokerage [X] on Loft47 Production, review this month's production using closedAt as the date field — the 1st through today (or last day of month if reviewing a completed month). Include: total sales volume, total Gross Commission Income (GCI, defined as total commission before deductions), units closed, and the top 5 agents by GCI. Exclude voided and collapsed deals. Group agent totals by office if the brokerage has multiple offices."

Agent Activity Review
Identify agents with no closed deals within a selected timeframe.
➡️ [MCP Prompt: Agent Activity Review]
"For brokerage [X] on Loft47 Production, list all active agents who have zero closed deals between [start date] and [end date], using closedAt as the date field. Include agents with no deals in any status during that window, not just no closed ones — flag whether they have deals in conditional or firm status that just haven't closed yet, versus agents with no activity at all. Exclude terminated/inactive agent profiles from the list."

💵 My Earnings This Month & Year
Show an individual agent how much they've actually been paid out, month-to-date and year-to-date.
➡️ [MCP Prompt:  Agent Earnings by Month & Year]
"For brokerage [X] on Loft47 Production, show all commission payouts transacted to [agent name] for two periods: month-to-date (1st of this month through today) and year-to-date (Jan 1 through today), using transactedAt as the date field. For each period, show total gross commission, total deductions, and net amount paid out. Exclude voided and collapsed deals."

🔮 Pipeline: What's Coming Up 
Show deals that haven't closed yet but are expected to, so an agent or broker can see what's ahead.
➡️ [MCP Prompt: Pipeline Forecast]
"For brokerage [X] on Loft47 Production, show all deals for [agent name / brokerage-wide] with status conditional or firm and an expected closing date (closedAt) between [start date] and [end date]. Include property address, sales price, current approval state, and estimated GCI (defined as total commission before deductions, if available). Sort by closing date ascending. Exclude voided and collapsed deals."

💰 Brokerage Revenue & Accounting

Brokerage Income Deduction Analysis
Review brokerage income deductions by agent and compare changes over time.
➡️ [MCP Prompt: Brokerage Income Deduction Analysis]
"For brokerage [X] on Loft47 Production, show income deductions — deductions where deductionType=income — grouped by agent and deduction template name, using closedAt as the date field for [start date] through [end date]. Compare totals to the same-length period immediately prior (or the same period last year, whichever comparison you want), showing dollar change and % change per agent and per deduction type. Exclude voided and collapsed deals."

Trust Ledger Sort by Deal
For audit/reconciliation — groups a raw trust ledger by deal and sorts chronologically within each, giving a clean audit trail of ins/outs per deal. Matches deals across inconsistent reference formats and flags ambiguous ones rather than guessing.
➡️ [MCP Prompt: "Attached: [spreadsheet name] (trust ledger export) and [PDF name] (formatting example, see page 2). Reorganize the spreadsheet grouped by deal, then chronologically within each deal, showing all trust ins/outs (deposits and disbursements). Match transactions to deals using these reference formats: (1) full deal number xxx-xxxx-xxxx = brokerage-year-dealnumber, (2) street address + last 4 digits of deal number, (3) street address only — flag these for my confirmation if more than one deal matches. Follow the layout style shown on page 2 of the PDF. Output as [Excel/Word/PDF]."

🏠 Transaction Analysis

Closed Deals by Title Company
Analyze closed transaction activity by title company, agent, and sales volume.
➡️ [MCP Prompt: Closed Deals by Title Company]
"For brokerage [X] on Loft47 Production, list all closed deals between [start date] and [end date] using closedAt as the date field, grouped by title company, then by agent, showing count of deals and total sales volume for each grouping. Exclude voided and collapsed deals."

Closing Forecast
Review upcoming closings and estimated commission income.
➡️ [MCP Prompt: Closing Forecast]
"For brokerage [X] on Loft47 Production, show all deals with a closing date (closedAt) between [start date] and [end date] that haven't closed yet — status conditional or firm. Include property address, agent(s), sales price, and estimated Gross Commission Income (GCI, defined as total commission before deductions). Sort by closing date ascending. Exclude voided and collapsed deals."

Bulk Enable/Disable "Allow Deal Creation" feature for Loft47 Agents via MCP (UpdateProfile)
➡️ [MCP Prompt: Set allowDealCreation to [true/false] for all agents at brokerage [ID] in [staging/production] via the Loft47 MCP UpdateProfile tool.  

Find duplicate profiles were both used on the same deals before merging
➡️ [MCP Prompt: Check [staging/production] brokerage id [ID]. I have two duplicate profile records for the same person: profile id [ID1] and profile id [ID2] — [name], e.g. [links if handy]. Pull the full deal list for each profile (paginate through all results, not just page 1), then tell me which deal(s) appear on BOTH lists. For each shared deal, give me the deal number, property address, sale status, and buyer/seller names as shown, plus a link to the deal.


More Prompts Coming Soon

Additional MCP prompt templates will be added as new reporting needs and use cases are identified.


    • Related Articles

    • Loft47 MCP Starter Guide: Getting Better Results with AI Prompts

      What is MCP? Loft47 MCP connects AI tools with your Loft47 data, allowing you to ask questions, analyze information, and get insights using natural language. Instead of manually building reports or searching through multiple screens, you can ask ...

    • Loft47 MCP Integration: Build Custom AI Tools, Reports, and Workflows

      Turn Your Loft47 Data Into Custom AI-Powered Insights Loft47 MCP allows approved AI tools to securely connect with your Loft47 data, helping you analyze brokerage performance, create custom reports, automate repetitive tasks, and generate insights ...

    • Loft47 API vs. MCP: Which Integration Is Right for You?

      If you’re exploring AI integrations with Loft47, you may wonder: “If Loft47 has MCP, why would someone need an API?” The short answer is: API = lets software communicate with Loft47 programmatically. MCP = gives AI assistants a standardized way to ...

    • Your Definitive Guide to Email Templates

      Welcome to the ultimate guide for creating and formatting Email Templates! Loft provides the capability to create & format your templates several different ways as outlined in our Key below: TEMPLATE KEY Email Body A template can be created for use ...

    • What's New in Loft47 (2026) - AI-Powered Features

      🤖 Work smart with AI Artificial Intelligence is transforming the way brokerages work in Loft47. Our AI-powered tools help eliminate repetitive tasks, improve data quality, and streamline transaction management so your team can work faster and more ...