Nyc Property Intel

io.github.ccedaceroPublished by GitHub account ccedacerov0.1.1Updated Nov 2, 2026

MCP server giving Claude AI access to 22+ NYC public-record databases for real estate due diligence

VerifiedStreamable HTTPWeb executableLocation & LifestyleData & Analytics

Overview

AI-generated overview

Remote MCP server that lets an assistant query 20+ NYC public-record datasets to research a property's violations, ownership, sales, liens and neighborhood…

What you can do
  • Resolve an address or BBL into a property profile with owner, zoning, FAR and assessed value
  • Pull violations, complaints, litigations, liens, tax info and rent-stabilization counts for a building
  • Review sales and deed history, comparable sales and neighborhood statistics
  • Check fire incidents, 311 requests, evictions and nearby NYPD crime
  • Run a full due-diligence summary that combines all of the above
When to use it
Useful when researching a NYC property before an offer, screening a building's public-record risk, or comparing sales and neighborhood conditions. It reports public records only and does not estimate property values.
Requirements
Remote HTTP endpoint with OAuth sign-in; a trial token from the provider's website is needed for Claude Code or Desktop use (10 queries/day for 30 days). Self-hosting instead requires Python 3.12+, uv, PostgreSQL 16+ and the nycdb CLI, plus a DATABASE_URL and optional GeoClient and Socrata keys.
Before you install
Access is token-based and metered, so usage limits and any paid plan apply. The hosted service logs usage and sends analytics events. Self-hosting means loading a large city dataset into your own PostgreSQL. Data is public record only and should not be treated as an appraisal or tenant screening.

Installation

In SourceWeft

  1. Open Nyc Property Intel in the dashboard and add it to a workspace.
  2. Connect the required credentials. They are stored privately and never shown on public pages.
  3. 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.ccedacero%2Fnyc-property-intel/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. The client completes OAuth sign-in on first connect.

{
  "mcpServers": {
    "nyc-property-intel": {
      "type": "http",
      "url": "https://nyc-property-intel-production.up.railway.app/mcp"
    }
  }
}

README

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 — no install, no token, and no Claude client needed.

"What violations does 123 Atlantic Ave, Brooklyn have?"

Free guides & lookups

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:

bash
claude mcp add --transport http nyc-property-intel \  "https://nyc-property-intel-production.up.railway.app/mcp" \  --header "Authorization: Bearer YOUR_TOKEN" \  --scope user

Claude Desktop — add to claude_desktop_config.json (Settings → Developer → Edit Config):

json
{  "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

  • Python 3.12+
  • uv package manager
  • PostgreSQL 16+
  • nycdb CLI (pip install nycdb)

1. Clone and install

bash
git clone https://github.com/ccedacero/nyc-property-intel.gitcd nyc-property-inteluv sync

2. Configure environment

bash
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)

bash
createuser -s nycdb 2>/dev/null; createdb -O nycdb nycdb 2>/dev/nullpg_restore -U nycdb -d nycdb --no-owner --jobs=4 data/nycdb.dump

Option B: Load from source (~2.5 hours)

bash
createuser -s nycdb 2>/dev/null; createdb -O nycdb nycdb 2>/dev/nullchmod +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:

bash
psql -U nycdb -d nycdb -f scripts/create_indexes.sqlpsql -U nycdb -d nycdb -f scripts/create_views.sql

4. Add to Claude Desktop

json
{  "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:

json
{  "mcpServers": {    "nyc-property-intel": {      "command": "uv",      "args": ["run", "nyc-property-intel"],      "cwd": "/absolute/path/to/nyc-property-intel"    }  }}

18 Tools

ToolDescription
lookup_propertyResolve any NYC address or BBL to a full property profile: owner, building class, zoning, FAR, assessed value, lot dimensions. Always call this first.
get_property_issuesHPD housing violations (Class A/B/C), DOB building code violations, and ECB/OATH monetary penalties. Filter by severity, status, and date.
get_property_historyDOF sales records and ACRIS deed transfers. Price trajectory, buyer/seller names, document types going back to 2003.
get_hpd_complaintsTenant-reported HPD complaints — leading indicators of building distress before formal violations are issued.
get_hpd_litigationsHPD housing court cases, open judgements, and harassment findings against building owners.
get_hpd_registrationLegal owner, managing agent, and head officer registration records.
get_building_permitsDOB job filings: new buildings, alterations, demolitions, sign permits. Status, cost estimate, applicant name.
get_liens_and_encumbrancesDOF tax lien sale list entries and ACRIS mortgage records. Outstanding liens, lender names, amounts, satisfactions.
get_tax_infoTax assessments, market value estimates, taxable value, and active exemptions (421a, J-51, STAR).
get_rent_stabilizationRent-stabilized unit counts by year (2007–2017). Trend analysis for deregulation signal.
search_compsComparable sales by zip code. Filter by building class, price, date. Includes quarterly market stats.
search_neighborhood_statsArea-level aggregates: property stock, median sale prices, violation rates, rent stabilization share.
get_fdny_fire_incidentsFDNY fire and emergency incident history. Fire type, alarm level, spread, casualties, duration. 2013–present, loaded from NYC Open Data.
get_311_complaints311 service requests at or near a property. Noise, rodents, heat, illegal dumping, and 200+ types. 2010–present, loaded from NYC Open Data.
get_evictionsMarshal-executed evictions by address. Residential and commercial. 2017–present, loaded from NYC Open Data.
get_dob_complaintsDOB complaints filed before formal violations — the earliest public signal of construction or safety issues.
get_nypd_crimeNYPD crime complaints within a configurable radius (default 300 m ≈ 3 blocks). Felony/misdemeanor breakdown, top offenses, year-over-year trend.
analyze_propertyFull 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.

DatasetAgencyNotes
PLUTODCPProperty profiles, zoning, FAR, building class
PADDCPAddress-to-BBL resolution
HPD ViolationsHPDHousing code violations by class and status
HPD ComplaintsHPDTenant complaint records
HPD RegistrationsHPDOwner/agent/officer registration
HPD LitigationsHPDHousing court cases
DOB ViolationsDOBBuilding code violations
ECB ViolationsOATH/ECBEnvironmental Control Board penalties
DOF Rolling SalesDOFRecent property sales
DOF Annual SalesDOFHistorical sales 2003–present
DOF AssessmentsDOFTax valuations and assessment rolls
DOF ExemptionsDOFTax exemption records (421a, J-51, STAR)
DOF Tax LiensDOFAnnual lien sale list
Rent StabilizationDOFStabilized unit counts by building, 2007–2017 (derived from DOF tax bills via taxbills.nyc / JustFix)
ACRISDOFDeeds, mortgages, liens, satisfactions, UCC filings
FDNY Fire IncidentsFDNY2013–present
311 Service Requests311/DOITT2010–present
Marshal EvictionsDOI2017–present
DOB ComplaintsDOBLoaded from NYC Open Data
NYPD Crime DataNYPD2006–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_propertyscripts/  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 tokens

Development

bash
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/                         # lintuv 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

Source: README.md at commit 2ece533

Tools

0
This server asks for a credential such as an API key, so SourceWeft could not read its tools without one and has not indexed them.

Version history

1
  1. v0.1.1LatestSep 16, 2026

Score

85% 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 listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts