CRE Intelligence

io.github.ZwondraPublished by GitHub account Zwondrav1.1.0Updated Oct 24, 2026

Live CRE analysis: Federal Reserve rates, Census 1/3/5-mile demographics, DCF models, IC memos.

VerifiedStreamable HTTPWeb executableFinanceData & AnalyticsBusiness & Commerce

Overview

AI-generated overview

A hosted CRE analysis server that gives an assistant live Federal Reserve rates, Census demographics, DCF modeling, lease and rent roll parsing, and IC memo and

What you can do
Fetch live Federal Reserve data: SOFR, Treasury yields, Fed Funds, CPI and rent inflation, CRE price index and credit spreads, with implied cap rate ranges and loan rate guidance. Look up Census demographics for a US address or for 1/3/5-mile trade-area rings. Screen a US county as a land-investing market and pre-screen a parcel for FEMA flood zone and federal wetlands. Parse pasted rent roll and lease text into structured tenant, lease and red-flag data, then flag rollover and concentration risk. Build a levered 10-year DCF with live rates and generate an acquisition or IC memo. Export a downloadable Excel underwriting model with live formulas and a sensitivity grid.
When to use it
Useful for commercial real estate underwriting, land screening and investment committee work where you want rates and demographics pulled from public sources rather than estimated. Best when you already have deal inputs such as address, NOI and price, or rent roll and lease text to analyze.
Requirements
The hosted endpoint needs no API keys or accounts; a stdio-only client needs the mcp-remote bridge via npx. Self-hosting needs Python 3.11+ and free FRED and Census API keys plus an Anthropic API key, set as environment variables.
Before you install
Document tools work by pasting rent roll or lease text into the prompt, so confidential deal documents are sent to the server and, for parsing and memo generation, to Anthropic. The hosted service is free during beta and may change. Excel export links expire after 60 minutes. Self-hosting requires the ANTHROPIC_API_KEY, FRED_API_KEY and CENSUS_API_KEY secrets.

Installation

In SourceWeft

  1. Open CRE Intelligence in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/io.github.Zwondra%2Fcre-intelligence-mcp/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "cre-intelligence": {
      "type": "http",
      "url": "https://cre-intelligence-mcp.onrender.com/mcp"
    }
  }
}

README

CRE Intelligence MCP

Live market data for commercial real estate analysis — inside Claude.

Connect this MCP to Claude Desktop and instantly access Federal Reserve interest rates, Census Bureau demographics, DCF modeling, rent roll parsing, lease abstraction, and IC memo generation — all from a single prompt.

"Analyze this deal: 2201 South Blvd, Charlotte NC. NOI $400k, asking $6M, retail strip."

→ Pulls live SOFR from the Fed. Pulls Census demographics for that exact block. Builds a full levered 10-year DCF. Writes an institutional-quality IC memo. 30 seconds.


Why this exists

The #1 problem with AI in CRE: 66% of professionals use it daily, but only 5% trust it for actual deal decisions.

The reason? AI guesses at rates and demographics. A DCF built on a hallucinated SOFR rate is worthless.

This MCP fixes that. Every number comes from a verified public source:

  • Interest rates → Federal Reserve (FRED API)
  • Demographics → US Census Bureau ACS
  • Document analysis → Claude AI with structured output

Zero data licensing fees. Zero hallucinations on financial inputs.


Tools

ToolWhat it doesData source
get_current_ratesLive SOFR, 10yr Treasury, Fed Funds + implied cap ranges by property typeFRED
get_inflation_dataCPI, shelter inflation, rent CPI + DCF rent growth guidanceFRED
get_cre_market_dataCRE price index, C&I loan trends, delinquency rates, credit spreadsFRED
get_market_demographicsMedian income, employment, vacancy, rents for any US addressCensus Bureau
get_radius_demographics1/3/5-mile trade-area rings: population, weighted income, renter share, rentsCensus Bureau
analyze_rent_rollPaste PDF text → structured JSON: tenant, SF, rent, dates, expirationsClaude AI
abstract_leasePaste lease text → term, rent schedule, TI, options, red flagsClaude AI
flag_lease_risksRent roll JSON → rollover risk, concentration risk, due diligence checklistClaude AI
build_dcf_modelFull levered 10-year DCF with live rates auto-fetched from FREDPython + FRED
generate_deal_memoAddress + NOI + price → full IC memo with live rates and demographicsClaude AI + FRED + Census
export_dcf_excelDownloadable .xlsx underwriting model with live formulas, sensitivity grid, market dataPython + FRED + Census

Example output

Prompt: "Get me current interest rates"

SOFR:           3.63%   (June 8, 2026)SOFR 30-day:    3.59%10yr Treasury:  4.55%5yr Treasury:   4.29%Fed Funds:      3.63%
Implied cap rates (spread over 10yr T):  Core Multifamily:  5.30% – 6.05%  Core Industrial:   5.55% – 6.30%  Core Office:       6.05% – 7.05%  Value-Add:         6.05% – 7.05%
Loan rate guidance:  Floating: SOFR + 150–250bps = ~5.38%–5.88%  Fixed:    10yr T + 150–200bps = ~6.05%–6.55%

Prompt: "Analyze this deal: 2201 South Blvd Charlotte NC, NOI $400k, asking $6M, retail strip"

The MCP automatically chains get_current_rates + get_market_demographics + build_dcf_model + generate_deal_memo and returns a full IC memo including:

Entry Cap Rate:   6.67%  (+212bps over 10yr Treasury)Loan Rate:        5.38%  (derived from live SOFR 3.63% + 175bps)Year 1 DSCR:      1.53xIRR:              14.6%Equity Multiple:  3.11x
Census Tract demographics (2023 ACS):  Median HHI:       $141,419  Employment rate:  97.2%  College educated: 64.9%  Vacancy rate:     8.6%
Recommendation: GO — subject to rent roll review and comp analysis.

Setup

Option A — Hosted (fastest, no API keys)

Add this to your claude_desktop_config.json and restart Claude Desktop:

json
{  "mcpServers": {    "cre-intelligence": {      "type": "streamable-http",      "url": "https://cre-intelligence-mcp.onrender.com/mcp"    }  }}

If your MCP client only supports stdio servers, use the mcp-remote bridge instead:

json
{  "mcpServers": {    "cre-intelligence": {      "command": "npx",      "args": ["-y", "mcp-remote", "https://cre-intelligence-mcp.onrender.com/mcp"]    }  }}

Free during beta. All data fetching runs server-side.

Option B — Self-hosted

Prerequisites
Install
bash
git clone https://github.com/Zwondra/cre-intelligence-mcpcd cre-intelligence-mcppython3.11 -m venv venvvenv/bin/pip install -r requirements.txtcp .env.example .env# Add your API keys to .env

Connect to Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

json
{  "mcpServers": {    "cre-intelligence": {      "command": "/path/to/cre-intelligence-mcp/venv/bin/python3",      "args": ["/path/to/cre-intelligence-mcp/server.py"],      "env": {        "ANTHROPIC_API_KEY": "sk-ant-...",        "FRED_API_KEY": "your_fred_key",        "CENSUS_API_KEY": "your_census_key"      }    }  }}

Restart Claude Desktop. The tools will appear automatically.

Test it

Open Claude Desktop and say:

"Get me current interest rates"

You should see it call get_current_rates and return live Federal Reserve data.


Document analysis

The document tools (analyze_rent_roll, abstract_lease) work by pasting PDF text directly into the prompt. In Claude Desktop:

  1. Open your rent roll or lease PDF
  2. Copy all the text
  3. Say: "Analyze this rent roll: [paste text]"

The tool extracts every tenant, suite, SF, rent, lease dates, and expiration into structured JSON — then flag_lease_risks can immediately analyze it for rollover and concentration risk.


Data sources

SourceWhatCost
FRED (Federal Reserve)SOFR, Treasury yields, Fed Funds, CPI, CRE price indexFree
Census Bureau ACSIncome, employment, housing, rents by census tractFree
Anthropic ClaudeDocument parsing, risk analysis, memo generationPay per use

Roadmap

  • Comparable sales search (CREXI public listings)
  • Multi-property portfolio analysis
  • Sensitivity table generation (cap rate / NOI / LTV scenarios)
  • Export to Excel / Word
  • Deal history / comparison across sessions

License

MIT

Source: README.md at commit 6e3f241

Tools

13

get_current_rates

Get live interest rates from the Federal Reserve (FRED). Returns SOFR, 10-year Treasury, 5-year Treasury, Fed Funds Rate, and 30-day SOFR average. Also calculates implied cap rate ranges based on current treasury spreads. Use this BEFORE any DCF model or loan underwriting. These are real-time numbers Claude cannot access on its own.

Takes no parameters.

get_market_demographics

Get Census Bureau demographics for any US property address. Returns median income, population, employment rate, housing vacancy, median rents, and education levels for the census tract. This is address-specific data from the actual Census tract — not estimates. Claude cannot access this without the MCP. For 1/3/5-mile trade-area rings, use get_radius_demographics instead.

Parametersaddressrequired

get_radius_demographics

Get aggregated Census demographics for radius rings around a US property address — the standard 1/3/5-mile trade-area format used in CRE site analysis. Aggregates every census tract whose centroid falls within each radius: population, household-weighted median income, employment rate, college attainment, housing vacancy, renter share, and median rent. Use this for trade-area / site analysis. Use get_market_demographics for the single census tract immediately around the address.

Parametersaddressrequiredradii_miles

screen_land_market

Screen a US county as a LAND-INVESTING market (raw-land flip / Podolsky style). Grades the county on the signals that matter for buying cheap rural land and reselling on terms: population growth, demographics, owner share, and affordability. IMPORTANT: This screens on FREE Census data only (growth + demographics + a home-value affordability proxy). It does NOT include actual land sale prices or comps — those require county records or a paid service, and must be verified per-parcel before buying. Use this to rank/shortlist markets, not to buy.

Parametersstaterequiredcountyrequired

screen_parcel_dd

Pre-screen a land parcel's location for the AUTOMATABLE due-diligence red flags: FEMA flood zone and federal wetlands. Pulls live from FEMA's National Flood Hazard Layer and the US Fish & Wildlife National Wetlands Inventory. Use this to kill obviously-bad parcels (flood zone, wetlands) at scale BEFORE spending time on manual due diligence. IMPORTANT: Checks flood + wetlands only. It does NOT check legal ACCESS (landlocked — the #1 land deal-killer), title/liens, or zoning — those stay MANUAL, per-parcel checks via county records. A clean screen here is necessary, NOT sufficient.

Parameterslatrequiredlngrequired

get_inflation_data

Get current CPI and rent inflation data from the Federal Reserve. Returns overall inflation, shelter inflation, and rent-specific CPI with YoY changes. Use this to calibrate rent growth assumptions in your DCF model — don't guess.

Takes no parameters.

get_cre_market_data

Get Commercial Real Estate price index and broader market data from the Federal Reserve. Returns CRE price trends, office/retail/industrial vacancy proxies, and credit spreads. Provides macro context for deal underwriting and cap rate analysis.

Takes no parameters.

analyze_rent_roll

Extract structured tenant and lease data from a rent roll document. Paste the text content of your rent roll PDF here (copy-paste from PDF reader). Returns tenant list, suite/SF, lease dates, monthly rent, escalations, and options.

Parameterstextrequiredproperty_name

abstract_lease

Extract all key terms from a commercial lease document. Returns term, base rent schedule, escalations, TI allowance, CAM structure, renewal options, termination rights, exclusivity, co-tenancy, and red flags.

Parameterstextrequired

flag_lease_risks

Analyze a parsed rent roll for investment risks. Feed the output from analyze_rent_roll directly into this tool. Returns: rollover risk, tenant concentration, credit risk, and actionable recommendations.

Parametersrent_roll_jsonrequired

build_dcf_model

Build a levered DCF model using live Federal Reserve rates. Automatically fetches current SOFR to derive the loan rate if not provided. Returns: annual cash flows, IRR, equity multiple, cash-on-cash, DSCR, and exit analysis.

Parametersloan_ratenoi_year1requiredequity_pcthold_yearsexit_cap_ratepurchase_pricerequirednoi_growth_rateamortization_years

generate_deal_memo

Generate a formatted CRE acquisition memo / Investment Committee memo. Automatically pulls live rates from FRED and demographics from Census Bureau to provide real market context — not guesses.

Parametersnoirequiredasking_pricerequiredproperty_typerequiredproperty_addressrequiredrent_roll_summaryadditional_context

export_dcf_excel

Generate a downloadable Excel (.xlsx) underwriting model with LIVE formulas — editable assumptions, PMT/FV amortization, IRR, equity multiple, a sensitivity grid, live Fed rates, and (if an address is given) Census trade-area demographics. Returns a download link valid for 60 minutes.

Parametersaddressloan_ratenoi_year1requiredequity_pcthold_yearsexit_cap_rateproperty_namepurchase_pricerequirednoi_growth_rateamortization_years

Version history

1
  1. v1.1.0LatestSep 16, 2026

Score

100% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listedRequired15 pts
  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts