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:
| Table | Description | Rows |
|---|---|---|
guest_cards | Prospective tenant inquiries with preferences | 100 |
nearby_units | Comparable rental listings in the area | 100 |
🛠️ Available Tools
Schema & Query
| Tool | Description |
|---|---|
get_schema() | View database schema and column descriptions |
query_database(sql) | Execute any SELECT query |
Guest Card Analytics
| Tool | Description |
|---|---|
guest_card_summary() | Comprehensive summary of all inquiries |
qualified_prospects(min_income, min_credit) | Find prospects meeting criteria |
Market Analytics
| Tool | Description |
|---|---|
market_rent_analysis() | Analyze nearby rental market conditions |
📧 Email Generation
| Tool | Description |
|---|---|
generate_leasing_email(...) | Create professional leasing update email |
📊 Visual Reports
| Tool | Description |
|---|---|
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 recipientsender_name: Your namecurrent_rate: Current advertised rentprevious_rate: Previous rent rateshowings_confirmed: Number of confirmed showingsshowings_attended: Number who attendedinterested_parties: Number who seemed interestedpending_applications: Current pending appswithdrawn_applications: Withdrawn appsupcoming_showings: Scheduled future showings
📊 Visual Reports
Full Market Report (create_market_report())
Generates a comprehensive 6-panel report including:
- Rent Distribution Histogram - Nearby rental price spread
- Credit Score Pie Chart - Prospect credit quality
- Pet Preferences Bar Chart - Pet ownership breakdown
- Budget Distribution Histogram - Prospect max rent budgets
- Price Comparison Bar Chart - Market vs our rate
- Activity Types Pie Chart - Prospect engagement
Individual Charts (create_individual_chart(type))
Available chart types:
rent_histogram- Distribution of nearby rental pricescredit_pie- Credit score distributionpet_bar- Pet preferences breakdownbudget_histogram- Prospect budget distributionprice_comparison- Market vs our pricingactivity_pie- Prospect activity typesincome_vs_rent- Income vs max rent scattersimilarity_rent- Property similarity vs rent scatter
🚀 Setup
Prerequisites
- Python 3.10+
uvpackage 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)