MCP Hub
Back to servers

Tenant Leasing Analytics

A specialized MCP server for property managers to analyze prospective tenant guest cards and local market rent data through SQL queries, automated email generation, and visual reporting charts.

Tools
8
Updated
Dec 5, 2025

Tenant Leasing Analytics - MCP Server

A specialized MCP (Model Context Protocol) server for tenant leasing analytics, focused on guest card management and market rent comparisons.

📊 Data Architecture

This MCP server only uses data from the tenant-info/ folder:

TableDescriptionRows
guest_cardsProspective tenant inquiries with preferences100
nearby_unitsComparable rental listings in the area100

🛠️ Available Tools

Schema & Query

ToolDescription
get_schema()View database schema and column descriptions
query_database(sql)Execute any SELECT query

Guest Card Analytics

ToolDescription
guest_card_summary()Comprehensive summary of all inquiries
qualified_prospects(min_income, min_credit)Find prospects meeting criteria

Market Analytics

ToolDescription
market_rent_analysis()Analyze nearby rental market conditions

📧 Email Generation

ToolDescription
generate_leasing_email(...)Create professional leasing update email

📊 Visual Reports

ToolDescription
create_market_report()Full 6-chart visual report (bar, pie, histogram)
create_individual_chart(type)Generate specific chart types

📧 Email Generation

The generate_leasing_email() tool creates professional leasing update emails like:

Good Morning Chi,

Last week in total we received 17 inquiries and I had no groups confirm showings. 
As discussed, we decreased the rate to $2400 and have received 4 new inquiries...

Parameters:

  • recipient_name: Email recipient
  • sender_name: Your name
  • current_rate: Current advertised rent
  • previous_rate: Previous rent rate
  • showings_confirmed: Number of confirmed showings
  • showings_attended: Number who attended
  • interested_parties: Number who seemed interested
  • pending_applications: Current pending apps
  • withdrawn_applications: Withdrawn apps
  • upcoming_showings: Scheduled future showings

📊 Visual Reports

Full Market Report (create_market_report())

Generates a comprehensive 6-panel report including:

  1. Rent Distribution Histogram - Nearby rental price spread
  2. Credit Score Pie Chart - Prospect credit quality
  3. Pet Preferences Bar Chart - Pet ownership breakdown
  4. Budget Distribution Histogram - Prospect max rent budgets
  5. Price Comparison Bar Chart - Market vs our rate
  6. Activity Types Pie Chart - Prospect engagement

Individual Charts (create_individual_chart(type))

Available chart types:

  • rent_histogram - Distribution of nearby rental prices
  • credit_pie - Credit score distribution
  • pet_bar - Pet preferences breakdown
  • budget_histogram - Prospect budget distribution
  • price_comparison - Market vs our pricing
  • activity_pie - Prospect activity types
  • income_vs_rent - Income vs max rent scatter
  • similarity_rent - Property similarity vs rent scatter

🚀 Setup

Prerequisites

  • Python 3.10+
  • uv package manager

Installation

cd /Users/kkamalva/financial_analysis/MCP/kurt-data
uv sync

Claude Desktop Configuration

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

{
  "mcpServers": {
    "tenant-leasing": {
      "command": "/Users/kkamalva/financial_analysis/MCP/kurt-data/run_server.sh"
    }
  }
}

💬 Example Questions

Guest Card Questions

  • "Show me a summary of all guest cards"
  • "Find qualified prospects with income over $8,000"
  • "What's the credit score distribution of our prospects?"

Market Questions

  • "Analyze the nearby rental market"
  • "How does our price compare to the market?"
  • "What's the average rent in the area?"

Email & Reports

  • "Generate a leasing update email for Chi"
  • "Create a market report with charts"
  • "Generate a rent histogram"

📁 Data Files

This MCP server is self-contained within the kurt-data/ folder and only uses data from tenant-info/:

kurt-data/
├── server.py              ← MCP server
├── run_server.sh          ← Launch script
├── pyproject.toml         ← Dependencies
├── tenant-info/
│   ├── synthetic_guest_cards.csv
│   └── nearby_advertised_units.csv
└── charts/
    └── (generated visualizations)

Reviews

No reviews yet

Sign in to write a review