`case_shiller_metro_compare`

Pack: housing-intel · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/case_shiller_metro_compare for the schema, then POST the same URL with its arguments for the data.

Compare Case-Shiller home price indices across multiple US metros in one call (the 20-city composite). For each metro returns latest level, 3-month change, 12-month change, all-time peak, drawdown from peak, and a softening flag. Output also ranks metros softest → strongest. Use for “which metros are softening”, “Case-Shiller for [list of cities]”, “compare housing prices in X, Y, Z” queries — picks the right per-metro FRED series IDs (DNXRSA, PHXRSA, TPXRSA, etc.) so callers don’t have to. Available metros: Atlanta, Boston, Charlotte, Chicago, Cleveland, Dallas, Denver, Detroit, Las Vegas, Los Angeles, Miami, Minneapolis, New York, Phoenix, Portland, San Diego, San Francisco, Seattle, Tampa, Washington DC. NOT A CURRENT-MARKET READ: Case-Shiller is monthly, published on a roughly two-month lag, and each value is a three-month moving average — so the newest observation is typically 90-120 days old and describes a trailing quarter. The freshness block states the exact age of the call you made.

Parameters

Name	Type	Required	Description
`_fredKey`	string	no	FRED API key (https://fred.stlouisfed.org/docs/api/api_key.html). Platform key used if omitted.
`metros`	array	yes	Metro names, case-insensitive. Example: [“Denver”, “Phoenix”, “Tampa”, “Charlotte”]. Pass any subset of the 20-city composite.
`items`	string	no

Example call

Arguments

{
  "metros": [
    "Denver",
    "Phoenix",
    "Tampa",
    "Charlotte"
  ]
}

curl

curl -X POST https://gateway.pipeworx.io/housing-intel/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"case_shiller_metro_compare","arguments":{"metros":["Denver","Phoenix","Tampa","Charlotte"]}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('case_shiller_metro_compare', {
  "metros": [
    "Denver",
    "Phoenix",
    "Tampa",
    "Charlotte"
  ]
});

More examples

{
  "metros": [
    "San Francisco",
    "Los Angeles",
    "Seattle"
  ]
}

Response shape

Field	Type	Description
`metros`	array	Ranked metros from softest to strongest
`softest_to_strongest`	array
`freshness`	object
`methodology`	string

Full JSON Schema

{
  "type": "object",
  "properties": {
    "metros": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "requested": {
            "type": "string"
          },
          "matched_name": {
            "type": "string"
          },
          "series_id": {
            "type": "string",
            "description": "FRED series ID (e.g., DNXRSA)"
          },
          "latest_date": {
            "type": [
              "string",
              "null"
            ]
          },
          "latest_age_days": {
            "type": [
              "number",
              "null"
            ]
          },
          "latest_value": {
            "type": [
              "number",
              "null"
            ]
          },
          "change_3m_pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "change_12m_pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "peak_value": {
            "type": [
              "number",
              "null"
            ]
          },
          "peak_date": {
            "type": [
              "string",
              "null"
            ]
          },
          "drawdown_from_peak_pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "softening": {
            "type": "boolean",
            "description": "True if 12-month change is negative"
          }
        }
      },
      "description": "Ranked metros from softest to strongest"
    },
    "softest_to_strongest": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "freshness": {
      "type": "object",
      "properties": {
        "as_of": {
          "type": "string"
        },
        "newest_observation_date": {
          "type": [
            "string",
            "null"
          ]
        },
        "oldest_observation_date": {
          "type": [
            "string",
            "null"
          ]
        },
        "age_days": {
          "type": "number"
        },
        "cadence": {
          "type": "string"
        },
        "release_schedule": {
          "type": "string"
        },
        "smoothing": {
          "type": "string"
        },
        "statement": {
          "type": "string"
        }
      }
    },
    "methodology": {
      "type": "string"
    }
  }
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the housing-intel pack

{
  "mcpServers": {
    "housing-intel": {
      "url": "https://gateway.pipeworx.io/housing-intel/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

case_shiller_metro_compare