MCP App Store
by KeenEthics
citytracker.ai icon

citytracker.ai MCP Server for Claude

By CityTracker

Overview

CityTracker provides a free, read-only query interface to New York City's public real-estate and property data — the datasets from NYC and NY State open-data portals, cleaned and joined so they can be searched together. Coverage spans all five boroughs (Manhattan, Brooklyn, Queens, the Bronx, Staten Island) and includes: Department of Buildings (DOB) construction permits and job filings; DOB and HPD building and housing violations, complaints, litigations, and vacate orders; ACRIS property documents — deeds, mortgages, liens, and the parties on them; tax lots (PLUTO/BBL) with owner, year built, zoning, land use, units, and assessed value; certificates of occupancy; facade compliance filings (FISP / Local Law 11); 311 requests; HPD registrations; property assessments; tax lien sales; and resolved company and representative (owner and contractor) records. It also covers NY State liquor licenses and retail food stores. Use it to answer questions like: Who owns this building or address? What permits and construction have been filed here? Does this property have open DOB or HPD violations? Which homes recently sold, and which were built before a given year? Which buildings are flagged as structurally compromised or need repairs? What are a lot's zoning, size, and assessed value? Who is the mortgage lender on a deed? Well suited to real-estate research, property due diligence, construction and contractor lead generation, ownership and title research, code-compliance monitoring, and market analysis. Read-only, sourced from public datasets.

How to connect

  1. Claude: Open the citytracker.ai listing in the Claude connectors directory and choose Connect. Claude listing citytracker.ai exposes 4 tools here.

Tools

describe_table

Claude
Describe the columns and data types for a table in the public schema of the read-only replica. For tables that are curated assets, the result is enriched with an asset slug, label, entity-level notes, and a per-column description. These come from the curated data model and may NOT cover every raw column (uncovered columns get description: null). The notes are the authoritative domain rules — column semantics vary by table (e.g. ACRIS party roles depend on doc_type), so read notes before querying. Foreign-key columns also carry a references object ({table, column}) naming the exact join target — join to that, not to a table you infer from the column name (e.g. filing.filing_company_id references company_raw_data, not company).

list_tables

Claude
List the base tables in the public schema of the read-only replica database. Returns a flat tables list of names plus a labels map of table -> human-readable label for tables that are curated assets (tables with no asset are omitted from labels). Use it to confirm a table exists before querying it — table names are not always the obvious ones (NYC PLUTO tax-lot data is tax_lot, not pluto). Takes no arguments.

overview

Claude
Return an orientation overview of the CityTracker data model (NYC real-estate: DOB filings/permits, ACRIS documents, HPD violations, tax lots, companies) plus the list of documented curated assets. Call this first to learn what data exists and how to explore it. The overview also states what is NOT in the schema, so it is the fastest way to tell a question this data can answer from one it cannot. Takes no arguments.

query

Claude
Run a single read-only SQL SELECT against the NYC real-estate replica and return up to 1000 rows as {columns, rows, truncated}. Writes, multiple statements and EXPLAIN ANALYZE are rejected; the database connection is read-only, so nothing this tool does can modify data. Target: the CityTracker NYC real-estate replica, documented at https://citytracker.ai/api/asset/docs (one page per dataset, with columns, filters and source links). Call describe_table before writing a query: this schema has per-table traps (foreign keys that point at *_raw_data rather than the table their name suggests, and columns whose meaning varies by table) that the entity-level notes spell out. Limits: a 15s statement timeout, a 1000-row cap and a total response-size cap. truncated: true means rows were dropped — the result is a partial prefix, NOT a complete answer, so never total or count it as if it were; re-run with an aggregate (COUNT/SUM/GROUP BY) or a narrower filter instead. A timeout means the query was too broad, not that the data is missing: add a filter on an indexed key or a date range and retry.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/citytracker-ai"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/citytracker-ai)