What we've shipped

PropRaven's canonical parcel record grew from 230.9M to 234M+. The merge consolidates two prior physical tables into a single deduped truth, recovers 4.4M parcels that the May 6 rebuild had silently dropped, and exposes 37 newer fields that were sitting in source but not in any share.

• NEW fields available on every parcel — TIGER census geography (block / block group / tract / place / county subdivision / unified school district / urban area), parsed address components (street number / pre-direction / street name / street type / post-direction / unit type / unit number / ZIP+4), AVM lower and upper bands plus rental AVM (~86% coverage), REO and distress flags (~17% / ~10%), distance to interstate and coastline.
• Marquee share — PROPRAVEN_PARCEL_INTELLIGENCE customers get all 37 new fields as direct columns on CURATED.V_MARKETPLACE_NATIONAL. No code changes, no schema bump.
• Vertical shares (CRE / Insurance / GovTech / SFR / Lending) get a new join table: <vertical>.PARCEL_EXTENSIONS — 1:1 with PARCEL via prpv_parcel_id. Backward-compatible additive change.
• Data-quality recovery — Patched a merge regression that had silently nullified all latest-non-null fields for ~7M parcels with no upstream refresh timestamp. 5,414,428 parcels recovered their OWNER_NAME / ADDRESS / YEAR_BUILT / LATITUDE/LONGITUDE / TOTAL_ASSESSED_VALUE / LAST_SALE_PRICE from backup snapshots, with a corrected merge rule preserving information across NULL-timestamp groups.
• SILVER tables refreshed — SILVER.PARCEL / SILVER.PROPERTY / SILVER.OWNER all rebuilt from the corrected source. PRPV IDs are stable across the rebuild; existing customer joins keep working.
• Stable IDs — Every parcel that existed before keeps its prpv_parcel_id. Owner IDs likewise: 27.5M owners, of which 1.4M previously-orphaned IDs now resolve cleanly back to parcels (phantom rate dropped from 5.1% to 0.01%).

See the Marquee share docs for the new columns, and methodology for the per-share access pattern.

The full PropRaven distribution stack — Python SDK, TypeScript SDK, hosted MCP server, and the standalone MCP npm package — is now live, ahead of the strategy memo's August target. Every component publishes with OIDC trusted publishing and SLSA provenance, with zero long-lived publish credentials anywhere in the chain.

• @propraven/sdk@0.2.0 on npm with SLSA provenance. Isomorphic typed client for Node 18+, browsers, Deno, Workers.
• propraven 0.1.0 on PyPI via Trusted Publishing. Sync + async clients, Pydantic v2 typed responses, pandas/Polars/Arrow conversion.
• @propraven/mcp@0.1.1 on npm. Stdio MCP server for local Claude Desktop / Cursor / agent dev.
• Hosted MCP server at mcp.propraven.com — JSON-RPC over HTTP, 8 tools (parcel.lookup, parcel.search, parcel.compare, owner.pierce, hazard.score, valuation.estimate, permits.history, sales.history).
• Listed on Anthropic's MCP registry as io.github.jdw2111/propraven. Smithery and MCP.so sync from there. PropRaven is the first canonical property-data MCP server in the registry.
• OpenAPI 3.1 spec public at api.propraven.com/openapi.json — 35 endpoints, 38 schemas, with first-class webhooks top-level keyword for the parcel.sold event.
• Auto-rebuild loop: spec changes in the propzilla repo automatically trigger a Stainless build, release-please opens a version-bump PR, and merging it publishes new SDK versions to npm and PyPI with provenance. No human in the loop after the initial commit.

The PropRaven REST API is publicly documented at api.propraven.com. OpenAPI 3.1 spec, scoped per-tier rate limits, dual-mode auth (API key or session) on self-serve management endpoints, and dual-mode delivery via webhooks (parcel.sold live; expanded events shipping July).

Postman workspace ready at api.propraven.com/postman-collection.json — 37 requests across 8 domains, Postman Collection v2.1.0.