nyc-property-intel
The NYC Property Intel server provides access to 20+ public record datasets for real estate due diligence on any NYC property. Key capabilities include:
Property Lookup: Resolve any address or BBL to a full profile — owner, building class, zoning, FAR, assessed value, and lot dimensions.
Violations & Complaints: Access HPD housing violations (Class A/B/C), DOB code violations, ECB/OATH penalties, HPD tenant complaints, and DOB complaints as early distress signals.
Sales & Ownership History: Track DOF sales records and ACRIS deed transfers (back to 2003) showing price trajectory, buyer/seller names, and document types.
Tax & Financials: Retrieve assessed/market values, tax class, taxable value, and active exemptions (421a, J-51, STAR).
Liens & Encumbrances: View DOF tax lien entries and ACRIS mortgage records including lender names, amounts, and satisfactions.
Building Permits: Review DOB job filings for new buildings, alterations, demolitions, and permits with status and cost estimates.
Rent Stabilization: Check rent-stabilized unit counts (2007–2017) to track deregulation trends.
HPD Registration & Litigation: Look up legal owner, managing agent, and head officer; identify housing court cases, open judgments, and harassment findings.
Comparable Sales & Neighborhood Stats: Find comps by zip code, building class, size, and time period; get area-level aggregates on median prices, violation rates, and rent stabilization share.
FDNY Fire Incidents: Access fire and emergency history (2013–present) including alarm level, spread, casualties, and duration.
311 Complaints: Query 311 service requests (2010–present) covering 200+ types like noise, rodents, and heat.
Evictions: Retrieve marshal-executed eviction records (2017–present) for residential and commercial properties.
NYPD Crime Data: Query crime complaints within a configurable radius with felony/misdemeanor breakdown and year-over-year trends.
Full Due Diligence Report: Run a single comprehensive analysis that concurrently queries all data sources to produce a complete property risk and investment profile.
NYC Property Intel
MCP server that gives Claude AI access to 20+ NYC public record datasets for real estate due diligence. Ask Claude about any NYC property in plain English — violations, liens, sales history, ownership, permits, rent stabilization, zoning, fire history, crime data, and more.
This is a due diligence tool, not an appraisal tool. It surfaces public record data only; it does not estimate property values.
Quickstart — Web Chat (no setup)
The fastest way to try it: open nycpropertyintel.com/chat and ask about any NYC property in plain English. 3 free queries, no signup (resets daily) — no install, no token, and no Claude client needed.
"What violations does 123 Atlantic Ave, Brooklyn have?"Related MCP server: NDI-MCP-Server
Quickstart — Claude Code / Desktop (hosted MCP)
Sign up at nycpropertyintel.com to get a free trial token (10 queries/day for 30 days, including up to 5 full due-diligence reports). Then:
Claude Code — run once in your terminal:
claude mcp add --transport http nyc-property-intel \
"https://nyc-property-intel-production.up.railway.app/mcp" \
--header "Authorization: Bearer YOUR_TOKEN" \
--scope userClaude Desktop — add to claude_desktop_config.json (Settings → Developer → Edit Config):
{
"mcpServers": {
"nyc-property-intel": {
"type": "http",
"url": "https://nyc-property-intel-production.up.railway.app/mcp",
"headers": {
"Authorization": "Bearer YOUR_TOKEN"
}
}
}
}Then ask Claude:
"Look up 350 5th Ave, Manhattan"
"What violations does 123 Atlantic Ave, Brooklyn have?"
"Full due diligence on 123 Atlantic Ave, Brooklyn"Self-Hosting
Prerequisites
1. Clone and install
git clone https://github.com/ccedacero/nyc-property-intel.git
cd nyc-property-intel
uv sync2. Configure environment
cp .env.example .env
# Edit .env:
# DATABASE_URL=postgresql://nycdb:nycdb@localhost:5432/nycdb
# NYC_GEOCLIENT_SUBSCRIPTION_KEY=your_key (optional, improves address resolution)
# SOCRATA_APP_TOKEN=your_token (optional, higher rate limits for 311/FDNY/NYPD)3. Set up the database
Option A: Restore from dump (~10 min)
createuser -s nycdb 2>/dev/null; createdb -O nycdb nycdb 2>/dev/null
pg_restore -U nycdb -d nycdb --no-owner --jobs=4 data/nycdb.dumpOption B: Load from source (~2.5 hours)
createuser -s nycdb 2>/dev/null; createdb -O nycdb nycdb 2>/dev/null
chmod +x scripts/seed_nycdb.sh
./scripts/seed_nycdb.sh # all phases
# or incrementally:
./scripts/seed_nycdb.sh --phase A # core data (~30 min)
./scripts/seed_nycdb.sh --phase B # sales + DOB (~45 min)
./scripts/seed_nycdb.sh --phase C # ACRIS + permits (~90 min)Then create indexes and materialized views:
psql -U nycdb -d nycdb -f scripts/create_indexes.sql
psql -U nycdb -d nycdb -f scripts/create_views.sql4. Add to Claude Desktop
{
"mcpServers": {
"nyc-property-intel": {
"command": "uv",
"args": ["run", "nyc-property-intel"],
"cwd": "/absolute/path/to/nyc-property-intel",
"env": {
"DATABASE_URL": "postgresql://nycdb:nycdb@localhost:5432/nycdb"
}
}
}
}5. Add to Claude Code
The .mcp.json in the project root auto-registers when you open this directory. Or add manually to ~/.claude.json:
{
"mcpServers": {
"nyc-property-intel": {
"command": "uv",
"args": ["run", "nyc-property-intel"],
"cwd": "/absolute/path/to/nyc-property-intel"
}
}
}18 Tools
Tool | Description |
| Resolve any NYC address or BBL to a full property profile: owner, building class, zoning, FAR, assessed value, lot dimensions. Always call this first. |
| HPD housing violations (Class A/B/C), DOB building code violations, and ECB/OATH monetary penalties. Filter by severity, status, and date. |
| DOF sales records and ACRIS deed transfers. Price trajectory, buyer/seller names, document types going back to 2003. |
| Tenant-reported HPD complaints — leading indicators of building distress before formal violations are issued. |
| HPD housing court cases, open judgements, and harassment findings against building owners. |
| Legal owner, managing agent, and head officer registration records. |
| DOB job filings: new buildings, alterations, demolitions, sign permits. Status, cost estimate, applicant name. |
| DOF tax lien sale list entries and ACRIS mortgage records. Outstanding liens, lender names, amounts, satisfactions. |
| Tax assessments, market value estimates, taxable value, and active exemptions (421a, J-51, STAR). |
| Rent-stabilized unit counts by year (2007–2017). Trend analysis for deregulation signal. |
| Comparable sales by zip code. Filter by building class, price, date. Includes quarterly market stats. |
| Area-level aggregates: property stock, median sale prices, violation rates, rent stabilization share. |
| FDNY fire and emergency incident history. Fire type, alarm level, spread, casualties, duration. 2013–present, loaded from NYC Open Data. |
| 311 service requests at or near a property. Noise, rodents, heat, illegal dumping, and 200+ types. 2010–present, loaded from NYC Open Data. |
| Marshal-executed evictions by address. Residential and commercial. 2017–present, loaded from NYC Open Data. |
| DOB complaints filed before formal violations — the earliest public signal of construction or safety issues. |
| NYPD crime complaints within a configurable radius (default 300 m ≈ 3 blocks). Felony/misdemeanor breakdown, top offenses, year-over-year trend. |
| Full due diligence summary — runs all sub-queries concurrently. Property profile, FAR analysis, financials, risk factors, rent stabilization, comparable sales, and key observations. |
Data Sources
Core data (~19 million rows) is loaded from nycdb. All datasets are loaded into PostgreSQL. Socrata API used as fallback only.
Dataset | Agency | Notes |
PLUTO | DCP | Property profiles, zoning, FAR, building class |
PAD | DCP | Address-to-BBL resolution |
HPD Violations | HPD | Housing code violations by class and status |
HPD Complaints | HPD | Tenant complaint records |
HPD Registrations | HPD | Owner/agent/officer registration |
HPD Litigations | HPD | Housing court cases |
DOB Violations | DOB | Building code violations |
ECB Violations | OATH/ECB | Environmental Control Board penalties |
DOF Rolling Sales | DOF | Recent property sales |
DOF Annual Sales | DOF | Historical sales 2003–present |
DOF Assessments | DOF | Tax valuations and assessment rolls |
DOF Exemptions | DOF | Tax exemption records (421a, J-51, STAR) |
DOF Tax Liens | DOF | Annual lien sale list |
Rent Stabilization | DOF | Stabilized unit counts by building, 2007–2017 (derived from DOF tax bills via taxbills.nyc / JustFix) |
ACRIS | DOF | Deeds, mortgages, liens, satisfactions, UCC filings |
FDNY Fire Incidents | FDNY | 2013–present |
311 Service Requests | 311/DOITT | 2010–present |
Marshal Evictions | DOI | 2017–present |
DOB Complaints | DOB | Loaded from NYC Open Data |
NYPD Crime Data | NYPD | 2006–present, geospatial radius |
Architecture
src/nyc_property_intel/
app.py # FastMCP instance + system prompt
server.py # Entry point: lifespan, auth middleware, tool registration
config.py # pydantic-settings (reads .env / environment variables)
db.py # asyncpg connection pool + query helpers
auth.py # Token validation, rate limiting, usage logging
analytics.py # PostHog event capture (fire-and-forget)
geoclient.py # NYC GeoClient API + PAD fallback for address resolution
socrata.py # Socrata Open Data API client — fallback for FDNY, 311, NYPD, evictions
loops_webhook.py # Loops.so webhook → auto-provision trial tokens on signup
tools/
lookup.py # lookup_property
issues.py # get_property_issues
history.py # get_property_history
hpd_complaints.py # get_hpd_complaints
hpd_litigations.py# get_hpd_litigations
hpd_registration.py# get_hpd_registration
permits.py # get_building_permits
liens.py # get_liens_and_encumbrances
tax.py # get_tax_info
rentstab.py # get_rent_stabilization
comps.py # search_comps
neighborhood.py # search_neighborhood_stats
fdny.py # get_fdny_fire_incidents
complaints_311.py # get_311_complaints
evictions.py # get_evictions
dob_complaints.py # get_dob_complaints
nypd_crime.py # get_nypd_crime
analysis.py # analyze_property
scripts/
seed_nycdb.sh # Downloads and loads all nycdb datasets
create_indexes.sql # Performance indexes on critical columns
create_views.sql # Materialized views for fast property lookup
manage_tokens.py # CLI for provisioning and managing customer tokensDevelopment
uv run pytest tests/test_utils.py -q # unit tests (no DB needed)
uv run pytest tests/ -m integration -q # integration tests (needs live DB)
uv run ruff check src/ # lint
uv run nyc-property-intel # run server locally (stdio)Fair Housing
NYC Property Intel provides building and property data from public city records only. It does not provide demographic data, tenant screening, or any analysis based on protected characteristics. See nycpropertyintel.com/#fair-housing for the full policy.
License
MIT
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/ccedacero/nyc-property-intel'
If you have feedback or need assistance with the MCP directory API, please join our Discord server