MCP Server
GUTHMANN® Berlin Real Estate
estate.guthmann/mcp
What this MCP does
Searches Berlin property listings and provides granular Berlin real-estate, neighborhood, demographic, and market statistics.
Capabilities
Tools
37
tools
berlin_borough_details
Borough Details
Returns details for one Berlin borough (Bezirk) by ID, optionally with all its districts.
Parameters:
- bezirk_id (required): 2-digit ID ("01" to "12")
- ortsteile: "true" to include all districts of the borough
Key response fields: { bezirk_id, bezirk_name, ortsteile?: [...] } (ortsteile = districts)
Example: bezirk_id="03" â Pankow with 13 districts (Prenzlauer Berg, WeiÃensee, etc.)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['bezirk_id'], 'properties': {'include': {'type': 'string'}, 'bezirk_id': {'type': 'string', 'pattern': '^\\d{2}$'}, 'ortsteile': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}}}
berlin_boroughs
Berlin Boroughs
Returns all 12 Berlin boroughs (Bezirke) with IDs and names.
Key response fields: array of { bezirk_id, bezirk_name }
- bezirk_id: 2 digits ("01" to "12")
- bezirk_name: e.g. "Mitte", "Friedrichshain-Kreuzberg", "Pankow"
Use when:
- You need an overview of Berlin's administrative structure
- You need a bezirk_id for market data queries
Do NOT use when:
- You already know the bezirk_id â use berlin_borough_details directly
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {}}
berlin_conservation_area_details
Conservation Area Details
Returns a single Berlin social conservation area (Milieuschutzgebiet) by ID. For main areas, associated extensions are embedded automatically.
Parameters:
- id (required): 12-character hex string (deterministic area ID)
- include: comma-separated geo attributes; available: "centroid". Polygons are provided as GeoJSON URLs in geometry_urls
Key response fields: { id, name, kategorie_id, kategorie_name, parent_id, beschreibung (description), datum (date), flaeche_km2 (area in km²), geometry_urls, centroid?, erweiterungen? (extensions) }
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': '12-stelliger Hex-String der Gebiets-ID'}, 'include': {'enum': ['centroid'], 'type': 'string', 'description': 'Geo-Attribute: centroid. Polygone kommen als GeoJSON-URLs in geometry_urls'}}}
berlin_conservation_areas
Berlin Conservation Areas
Berlin social conservation areas (Milieuschutzgebiete, §172 BauGB). 124 areas in 6 categories with polygon geometry.
Parameters:
- kategorie_id: filter by category ("erhaltungsgebiet" | "erweiterung" | "aufstellungsbeschluss" | "untersuchungsgebiet" | "beobachtungsgebiet" | "aufgehoben")
- erweiterungen: "true" to embed extensions as a nested array inside their main area
- include: comma-separated geo attributes; available: "centroid". Polygons are provided as GeoJSON URLs in geometry_urls
- lat/lon: WGS84 point lookup. Returns only areas containing the point (typically 0 or 1 match). lat and lon must be provided together.
Key response fields: array of { id, name, kategorie_id, kategorie_name, parent_id, beschreibung (description), datum (date), flaeche_km2 (area in km²), geometry_urls, centroid?, erweiterungen? (extensions) }
Use for: "Is this address in a social conservation area?" (with lat/lon), overview of all Milieuschutz areas.
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'lat': {'type': 'number', 'description': 'Breitengrad WGS84 für Punkt-Lookup (mit lon)'}, 'lon': {'type': 'number', 'description': 'Längengrad WGS84 für Punkt-Lookup (mit lat)'}, 'include': {'enum': ['centroid'], 'type': 'string', 'description': 'Geo-Attribute: centroid. Polygone kommen als GeoJSON-URLs in geometry_urls'}, 'kategorie_id': {'enum': ['erhaltungsgebiet', 'erweiterung', 'aufstellungsbeschluss', 'untersuchungsgebiet', 'beobachtungsgebiet', 'aufgehoben'], 'type': 'string', 'description': 'Filter nach Kategorie'}, 'erweiterungen': {'enum': ['true', 'false'], 'type': 'string', 'description': 'Erweiterungen als nested Array einbetten'}}}
berlin_district_details
District Details
Returns details for one Berlin district (Ortsteil) by ID, optionally with its neighborhoods.
Parameters:
- ortsteil_id (required): 4-digit ID (e.g. "0301")
- planungsraeume: "true" to include all neighborhoods of the district
Key response fields: { ortsteil_id, ortsteil_name, bezirk_id, bezirk_name, planungsraeume?: [...] } (planungsraeume = neighborhoods)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['ortsteil_id'], 'properties': {'include': {'type': 'string'}, 'ortsteil_id': {'type': 'string', 'pattern': '^\\d{4}$'}, 'planungsraeume': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}}}
berlin_districts
Berlin Districts
Returns all 97 Berlin districts (Ortsteile), optionally filtered by borough.
Parameters:
- bezirk_id (optional): filter to the districts of one borough
- bezirke: "true" to include borough references
Key response fields: array of { ortsteil_id, ortsteil_name, bezirk_id?, bezirk_name? }
- ortsteil_id: 4 digits (e.g. "0301" for Prenzlauer Berg)
Examples of well-known districts:
- Prenzlauer Berg (0301), Kreuzberg (0201), Mitte (0101)
- Charlottenburg (0401), Neukölln (0801), Friedrichshain (0202)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'bezirke': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}, 'include': {'type': 'string'}, 'bezirk_id': {'type': 'string', 'pattern': '^\\d{2}$'}}}
berlin_neighborhood_details
Neighborhood Details
Returns details for one Berlin neighborhood (LOR Planungsraum) by ID, optionally with its blocks.
Parameters:
- planungsraum_id (required): 8-digit ID
- bloecke: "true" to include all blocks of the neighborhood
Key response fields: { planungsraum_id, planungsraum_name, bezirk_id, bezirk_name, ortsteil_id, ortsteil_name, bloecke?: [...] } (bloecke = blocks)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['planungsraum_id'], 'properties': {'include': {'type': 'string'}, 'planungsraum_id': {'type': 'string', 'pattern': '^\\d{8}$'}}}
berlin_neighborhoods
Berlin Neighborhoods
Returns all 542 Berlin neighborhoods (LOR Planungsräume), optionally filtered by borough or district.
Parameters:
- bezirk_id (optional): filter by borough
- ortsteil_id (optional): filter by district
- bezirke/ortsteile: "true" to include parent references
Key response fields: array of { planungsraum_id, planungsraum_name, ... }
- planungsraum_id: 8 digits (e.g. "03010101")
Neighborhoods are the finest statistical level in Berlin.
Ideal for granular market analyses.
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'bezirke': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}, 'include': {'type': 'string'}, 'bezirk_id': {'type': 'string', 'pattern': '^\\d{2}$'}, 'ortsteile': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}, 'ortsteil_id': {'type': 'string', 'pattern': '^\\d{4}$'}}}
berlin_neighborhood_search
Neighborhood Search
Searches Berlin neighborhoods (LOR Planungsräume) by name.
Parameters:
- q (required): search term (min. 3 characters)
- limit: max. results (default: 25)
- bezirk_id/ortsteil_id: optional filters to narrow the search
Example: q="Kollwitz" finds the "Kollwitzplatz" neighborhood
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['q'], 'properties': {'q': {'type': 'string', 'minLength': 3}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'bezirke': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}, 'include': {'type': 'string'}, 'bezirk_id': {'type': 'string', 'pattern': '^\\d{2}$'}, 'ortsteile': {'enum': ['true', 'false'], 'type': 'string', 'default': 'false'}, 'ortsteil_id': {'type': 'string', 'pattern': '^\\d{4}$'}}}
field_metadata
Field Metadata
Returns field definitions for interpreting API responses.
Use this to understand fields, units, data types, and sources.
Parameters:
- domain (optional): specific domain for detailed field information
- locale: "de" (default) | "en"
Available domains:
- berlin: geographic reference data â Boroughs (Bezirke), Districts (Ortsteile), Neighborhoods (LOR Planungsräume)
- immobilienmarkt.berlin.wohnungen: Berlin apartment market
- immobilienmarkt.berlin.mehrfamilienhaeuser: Berlin apartment buildings
- makrooekonomie.kapitalmarkt: mortgage lending rates, Bund yields
- makrooekonomie.geldpolitik: ECB policy rates
- makrooekonomie.arbeitsmarkt: unemployment, employment
Without a domain parameter: returns an overview of all available domains.
Read only
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'domain': {'enum': ['berlin', 'immobilienmarkt', 'immobilienmarkt.berlin.wohnungen', 'immobilienmarkt.berlin.mehrfamilienhaeuser', 'immobilienmarkt.de.wohnungen', 'immobilienmarkt.de.mehrfamilienhaeuser', 'makrooekonomie', 'makrooekonomie.kapitalmarkt', 'makrooekonomie.geldpolitik', 'makrooekonomie.arbeitsmarkt', 'makrooekonomie.preise', 'makrooekonomie.wirtschaft', 'soziodemografie', 'soziodemografie.berlin.zensus', 'soziodemografie.berlin.bautaetigkeit', 'soziodemografie.berlin.wanderung', 'soziodemografie.berlin.wanderung.matrix', 'soziodemografie.berlin.einwohner', 'soziodemografie.berlin.einwohner.altersgruppen', 'soziodemografie.berlin.einwohner.herkunft'], 'type': 'string', 'description': 'Domain für Feld-Metadaten. Weglassen für Ã\x9cbersicht aller Domains.'}, 'locale': {'enum': ['de', 'en'], 'type': 'string', 'default': 'de', 'description': 'Sprache für Labels und Beschreibungen (Standard: de)'}}}
listing_details
Listing Details
One GUTHMANN listing in detail: prices and running costs, areas, amenities, energy certificate, exposé texts, images, contact and the exposé URL on guthmann.estate. When the address is not released, street/house number are null and the coordinate is deterministically offset by 150-300 m (koordinaten_versetzt = true).
Parameters:
- public_id: public listing id (hex, from listings or the exposé URL)
- locale: "de" | "en" (default: en)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['public_id'], 'properties': {'locale': {'enum': ['de', 'en'], 'type': 'string', 'default': 'en'}, 'public_id': {'type': 'string', 'pattern': '^[0-9a-f]{4,12}$'}}}
listings
GUTHMANN Listings
The GUTHMANN listings: the broker's active inventory in Berlin (for sale: owner-occupier apartments, investment apartments, apartment buildings, commercial). Every card carries its exposé URL on guthmann.estate. Addresses only for released listings, otherwise ZIP/District (Ortsteil)/Borough (Bezirk).
Parameters:
- segment: "APARTMENT_LIVING" | "APARTMENT_INVEST" | "APARTMENT_BUILDING" | "COMMERCIAL"
- bezirk / ortsteil: name filter, e.g. "Pankow" / "Prenzlauer Berg"
- preis_min / preis_max: purchase price in EUR
- zimmer_min, flaeche_min: lower bounds for rooms / living area (m²)
- locale: "de" | "en" for title, texts and exposé URL (default: en)
- limit: 1-100 (default: 50)
Key response fields:
- public_id (key for listing_details), titel (title), teaser, expose_url
- kaufpreis (purchase price), kaufpreis_pro_qm (price per m²), kaltmiete (net rent), bruttorendite (gross yield), mietfaktor (price-to-rent multiple)
- wohnflaeche (living area), anzahl_zimmer (rooms), baujahr (construction year), energie_wertklasse (energy class)
- bezirk (Borough), ortsteil (District), plz (ZIP), adresse (null when adresse_verborgen), bild (small first-party preview image, suitable for inline display)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'bezirk': {'type': 'string', 'maxLength': 40, 'minLength': 2}, 'locale': {'enum': ['de', 'en'], 'type': 'string', 'default': 'en'}, 'segment': {'enum': ['APARTMENT_LIVING', 'APARTMENT_INVEST', 'APARTMENT_BUILDING', 'COMMERCIAL'], 'type': 'string'}, 'ortsteil': {'type': 'string', 'maxLength': 40, 'minLength': 2}, 'preis_max': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'preis_min': {'type': 'integer', 'maximum': 9007199254740991, 'minimum': 0}, 'zimmer_min': {'type': 'number', 'minimum': 1}, 'flaeche_min': {'type': 'number', 'minimum': 1}}}
macro_bund_yields
Bund Yields
Yields on German government bonds (Bunds). Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
- limit, fields, include: "metadata"
Key response fields (German names):
- rendite_10j: 10-year Bund yield
- rendite_15j: 15-year Bund yield
- rendite_30j: 30-year Bund yield
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_construction_prices
Construction Prices
Construction price index for residential buildings. Source: Bundesbank.
Quarterly data (2015=100).
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- preisindex: construction price index
- preisindex_delta_1q: change vs. previous quarter
- preisindex_delta_1j: change vs. previous year
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_ecb_policy_rates
ECB Policy Rates
ECB key interest rates. Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
- limit, fields, include: "metadata"
Key response fields (German names):
- zinssatz_hauptrefinanzierungssatz: main refinancing rate (the ECB's key rate)
- zinssatz_einlagefazilitaet: deposit facility rate
- zinssatz_spitzenrefinanzierungsfazilitaet: marginal lending facility rate
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_gdp
GDP Data
GDP data (gross domestic product). Source: Bundesbank.
Quarterly data, price-adjusted, seasonally and calendar-adjusted (2015=100).
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- kettenindex: GDP chain-linked index
- kettenindex_delta_1q: change vs. previous quarter
- kettenindex_delta_1j: change vs. previous year
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_inflation_hicp
Inflation (HICP)
Inflation data (HICP - harmonized index of consumer prices). Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- hvpi_gesamt: overall HICP
- hvpi_gesamt_ohne_energie_nahrungsmittel: core inflation (HICP excluding energy and food)
- hvpi_energie, hvpi_nahrungsmittel, hvpi_dienstleistungen, hvpi_mieten: energy, food, services, rents
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_labor_employment
Employment
Employment statistics. Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- erwerbstaetige: persons in employment (seasonally adjusted)
- sv_beschaeftigte: employees subject to social insurance contributions
- geringfuegig_beschaeftigte: marginally employed (mini-jobs)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_labor_short_time_work
Short-Time Work
Short-time work (Kurzarbeit) statistics. Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- kurzarbeiter: short-time workers (seasonally adjusted)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_labor_unemployment
Unemployment
Unemployment statistics. Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
Key response fields (German names):
- arbeitslose: registered unemployed (seasonally adjusted)
- arbeitslosenquote: unemployment rate (%)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
macro_mortgage_lending
Mortgage Rates
Mortgage rates for residential housing loans. Source: Bundesbank.
Parameters:
- start/end: YYYY-MM-DD
- recent: number of most recent periods
- limit, fields, include: "metadata"
Key response fields (German names):
- zinssatz_gesamt: average rate across all fixed-interest periods
- zinssatz_5_bis_10j: rate for 5-10 year fixed-interest periods
- zinssatz_ueber_10j: rate for fixed-interest periods over 10 years
- volumen_gesamt: new lending volume
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}}}
market_berlin_apartment_buildings
Berlin Apartment Buildings
Berlin apartment building market (rental buildings, "Zinshäuser") - transaction data. Source: transaction data from the Berlin committee of valuation experts (GAA, Gutachterausschuss).
Parameters:
- rbs: "stadt" | "bezirk" | "stadtteil" | "ortsteil" â bezirk = Borough, ortsteil = District
Time filters:
- start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD)
- recent: number of most recent periods (alternative to start/end)
Additional filters:
- bezirk_id, stadtteil_id, ortsteil_id
- limit, fields, include: "metadata"
Key response fields:
- transaktionspreis: average total purchase price (â¬)
- transaktionen: number of transactions
- vielfaches: purchase price multiplier (purchase price / annual net cold rent)
- vielfaches_delta_*j: absolute change of the multiplier (1y, 5y, 10y, 15y)
- transaktionspreis_m2: price per m² of living space
Ideal for: investment market analysis, yield comparisons across locations
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}, 'bezirk_id': {'type': 'string'}, 'ortsteil_id': {'type': 'string'}}}
market_berlin_apartments
Berlin Apartments
Berlin apartment market data (listings + transactions). Sources: listing/offer data (IMV) + transaction data from the Berlin committee of valuation experts (GAA, Gutachterausschuss).
Parameters:
- zeitraum: "jahr" (default) | "monat" | "quartal" (abgeschlossene Quartale)
- jahr: transaction data (GAA) + listing data (IMV), finest level: block
- monat: listing data (IMV) only, finest level: District (Ortsteil)
- quartal: listing data (IMV) only, closed quarters, finest level: District (Ortsteil)
- rbs: spatial aggregation level â bezirk = Borough, ortsteil = District, planungsraum = Neighborhood (LOR Planungsraum)
- For zeitraum=jahr: "stadt" | "bezirk" | "stadtteil" | "ortsteil" | "planungsraum" | "block"
- For zeitraum=monat or quartal: "stadt" | "bezirk" | "stadtteil" | "ortsteil"
Time filters:
- start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD)
- recent: number of most recent periods (alternative to start/end)
Additional filters:
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id, block_id
- baualtertyp: "neubau" (new construction) | "bestand" (existing stock)
- limit, fields, include: "metadata"
Key response fields (depending on zeitraum):
- zeitraum=jahr: transaktionspreis_m2 (transaction price per m²), anzahl_transaktionen (number of transactions), kaufangebotspreis_m2 (asking sale price per m²), mietangebotspreis_m2 (asking rent per m²)
- zeitraum=monat: kaufangebotspreis_m2, anzahl_kaufangebote (number of sale listings), kaufangebot_vermarktungszeit (time on market)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil', 'planungsraum'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string'}, 'fields': {'type': 'string'}, 'recent': {'type': ['string', 'number']}, 'include': {'type': 'string'}, 'bezirk_id': {'type': 'string'}, 'baualtertyp': {'enum': ['bestand', 'neubau'], 'type': 'string'}, 'ortsteil_id': {'type': 'string'}, 'planungsraum_id': {'type': 'string'}}}
market_germany_apartment_buildings
Germany Apartment Buildings
National price index data for the German apartment building market. Source: vdp.
Quarterly data for apartment buildings (rental buildings, "Mehrfamilienhäuser") across Germany.
Time filters:
- start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD)
- recent: number of most recent periods (quarters)
Response controls:
- limit, fields, include: "metadata"
Key response fields:
- preisindex: price index for apartment buildings
- preisindex_delta_1q: quarter-over-quarter change
- preisindex_delta_1j: year-over-year change
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende des Zeitraums (YYYY, YYYY-MM oder YYYY-MM-DD)'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn des Zeitraums (YYYY, YYYY-MM oder YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}}}
market_germany_residential
Germany Residential
National market data for the German residential real estate market. Sources: DESTATIS, vdp, HYPOPORT.
Includes price AND transaction indices for various market segments.
Time filters:
- start/end: flexible date values (YYYY, YYYY-MM, YYYY-MM-DD)
- recent: number of most recent periods
Response controls:
- limit, fields, include: "metadata"
Key response fields:
PRICE INDICES:
- preisindex_gesamt_destatis, preisindex_gesamt_vdp, preisindex_gesamt_hypoport (overall price index per source)
- preisindex_grossstaedte_top_7 (top-7 major cities), preisindex_staedte_top_127 (top-127 cities)
TRANSACTION INDICES:
- transaktionsindex_grossstaedte_top_7, transaktionsindex_staedte_top_127
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende des Zeitraums (YYYY, YYYY-MM oder YYYY-MM-DD)'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn des Zeitraums (YYYY, YYYY-MM oder YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}}}
search
Search guthmann.estate
Semantic search over guthmann.estate â market insights, reports, neighborhood portraits, listing exposés, project pages and the company's own pages. Hybrid retrieval (vector + keyword, no reranking); one result per page with title, description, image, best-matching snippet and score. Use it for questions that need prose (analysis, context, advice); use the data tools for exact numbers and `listings` for what is currently for sale â the search index follows the website with up to six hours of delay.
Parameters:
- q: natural-language query, in the language of the pages you want (min 2 characters)
- locale: "de" | "en" â language of the indexed pages (default: en)
- section: comma-separated filter â "listings" (exposés), "projects" (new-build projects), "market-intelligence" (insights, reports, portraits), "pages" (company, services, guides); omit for all
- limit: 1-20 pages (default: 10)
Key response fields:
- url, title, description, image, section, language
- snippet (best-matching text passage), score (0-1)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'required': ['q'], 'properties': {'q': {'type': 'string', 'maxLength': 200, 'minLength': 2}, 'limit': {'type': 'integer', 'maximum': 20, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 20)'}, 'locale': {'enum': ['de', 'en'], 'type': 'string', 'default': 'en'}, 'section': {'type': 'string', 'pattern': '^(listings|projects|market-intelligence|pages)(,(listings|projects|market-intelligence|pages))*$'}}}
socio_berlin_age_groups
Population by Age Group
Berlin population by 8 age groups, additionally by population group. Source: Amt für Statistik Berlin-Brandenburg.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- bevoelkerungsgruppe: "alle" (all) | "mit_migrationshintergrund" (with migration background) (optional)
- altersgruppe: age group, e.g. "alter_unter_6", "alter_65_und_mehr" (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- bevoelkerungsgruppe_id/_name (population group), altersgruppe_id/_name (age group), anzahl_einwohner (number of residents)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}, 'altersgruppe': {'type': 'string', 'description': 'Altersgruppe (z.B. alter_unter_6)'}, 'bevoelkerungsgruppe': {'enum': ['alle', 'mit_migrationshintergrund'], 'type': 'string', 'description': 'Bevölkerungsgruppe: alle, mit_migrationshintergrund'}}}
socio_berlin_census_buildings
Census Buildings
Zensus 2022 building data for Berlin. Source: Statistisches Bundesamt, Zensus 2022.
Without a category: total number of buildings.
With a category:
- bauweise: construction type (detached, row house, semi-detached)
- eigentumsform: ownership type (private individual, cooperative, municipality)
- heizungsart: heating type (central heating, per-floor heating, individual stoves)
- energietraeger: energy source (gas, oil, district heating, electricity)
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- kategorie: "bauweise" | "eigentumsform" | "heizungsart" | "energietraeger" (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'kategorie': {'enum': ['bauweise', 'eigentumsform', 'heizungsart', 'energietraeger'], 'type': 'string', 'description': 'Kategorie: bauweise, eigentumsform, heizungsart, energietraeger'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_census_dwellings
Census Dwelling Stock
Zensus 2022 dwelling stock data for Berlin. Source: Statistisches Bundesamt, Zensus 2022.
Without a category: total number of dwellings.
With a category:
- raeume: breakdown by number of rooms
- flaeche: breakdown by floor-area cluster (under 40 m², 40-59 m², etc.)
- nutzung: breakdown by type of use (owner-occupied, rented, vacant)
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- kategorie: "raeume" | "flaeche" | "nutzung" (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil', 'planungsraum'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'kategorie': {'enum': ['raeume', 'flaeche', 'nutzung'], 'type': 'string', 'description': 'Kategorie: raeume, flaeche, nutzung'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}, 'planungsraum_id': {'type': 'string', 'description': 'Planungsraum-ID (8-stellig)'}}}
socio_berlin_census_households
Census Households
Zensus 2022 household data for Berlin. Source: Statistisches Bundesamt, Zensus 2022.
Without a category: total number of households.
With a category:
- groesse: household size (1 person, 2 persons, etc.)
- wohndauer: length of residence (under 1 year, 1-5 years, etc.)
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- kategorie: "groesse" | "wohndauer" (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'kategorie': {'enum': ['groesse', 'wohndauer'], 'type': 'string', 'description': 'Kategorie: groesse, wohndauer'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_census_rents
Census Rents
Zensus 2022 rent data for Berlin. Source: Statistisches Bundesamt, Zensus 2022.
Without a category: weighted average across all dwellings (net cold rent, net cold rent per m², count).
With category "flaeche": rent per m² by floor-area cluster.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- kategorie: "flaeche" (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- nettokaltmiete: average net cold rent (EUR)
- nettokaltmiete_m2: net cold rent per m² (EUR)
- anzahl_wohnungen: number of dwellings
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'kategorie': {'enum': ['flaeche'], 'type': 'string', 'description': 'Kategorie: flaeche. Ohne: Gesamtdurchschnitt'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_census_vacancy
Census Dwelling Vacancy
Zensus 2022 dwelling vacancy data for Berlin. Source: Statistisches Bundesamt, Zensus 2022.
Breakdown by vacancy category (duration or reason).
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- kategorie: "dauer" (duration) | "grund" (reason) (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- kategorie_id, kategorie_label: vacancy category
- anzahl: number of vacant dwellings
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'kategorie': {'enum': ['dauer', 'grund'], 'type': 'string', 'description': 'Kategorie: dauer, grund'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_construction_activity
Berlin Construction Activity
Construction activity data for Berlin. Source: Amt für Statistik Berlin-Brandenburg.
Shows net changes: building balance, dwelling balance, living-space balance.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end: period (YYYY, YYYY-MM, YYYY-MM-DD)
- recent: number of most recent periods
- limit, fields, include: "metadata"
Key response fields:
- gebaeude_saldo: net change in number of buildings
- wohnungen_saldo: net change in number of dwellings
- wohnflaeche_m2_saldo: net change in living space (m²)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_migration_external
Berlin External Migration
External migration for Berlin: migration across the city boundary, annual, by nationality. Source: Amt für Statistik Berlin-Brandenburg.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- staat_code: filter by country code (e.g. "000" for Germany)
- alpha2: filter by ISO 3166-1 alpha-2 code (e.g. "TR")
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- zuzuege: move-ins to Berlin
- fortzuege: move-outs from Berlin
- saldo: net migration (move-ins minus move-outs)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'alpha2': {'type': 'string', 'description': 'ISO 3166-1 Alpha-2 (z.B. "TR")'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'staat_code': {'type': 'string', 'description': 'Staatencode (3-stellig, z.B. "000")'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}}}
socio_berlin_migration_matrix
Berlin Migration Matrix
Migration matrix for Berlin: migration flows between areas (moves within Berlin, annual). The RBS level applies to both origin and destination. Source: Amt für Statistik Berlin-Brandenburg.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum) (default: bezirk)
- von_rbs_id: filter by origin-area ID
- nach_rbs_id: filter by destination-area ID
- min_personen: lower bound on number of persons (default 1)
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- von_rbs_id/von_rbs_name: origin area
- nach_rbs_id/nach_rbs_name: destination area
- anzahl_personen: number of moves
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['bezirk', 'ortsteil'], 'type': 'string', 'default': 'bezirk'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'von_rbs_id': {'type': 'string', 'description': 'Filter Herkunftsraum-ID'}, 'nach_rbs_id': {'type': 'string', 'description': 'Filter Zielraum-ID'}, 'min_personen': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Untere Schranke Anzahl Personen (Default 1)', 'exclusiveMinimum': 0}}}
socio_berlin_origin
Population by Origin
Berlin population with a migration background, by area of origin. Source: Amt für Statistik Berlin-Brandenburg.
â ï¸ herkunft_ebene: "eu_gesamt" is the aggregate over the individual "eu_land" entries. The default (drittland,eu_gesamt,nicht_zuordenbar) prevents double-counting EU countries.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood, LOR Planungsraum)
- herkunft_ebene: origin level, comma-separated, e.g. "drittland,eu_gesamt" (optional; default prevents double counting)
- herkunftsgebiet: area of origin, e.g. "tuerkei", "ukraine", "eu" (optional)
- top: top N areas of origin by count (optional)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- herkunftsgebiet_id/_name (area of origin), herkunft_ebene (origin level), anzahl_einwohner_mit_migrationshintergrund (residents with a migration background)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil'], 'type': 'string', 'default': 'stadt'}, 'top': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Top-N Herkunftsgebiete nach Anzahl', 'exclusiveMinimum': 0}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}, 'stadtteil_id': {'type': 'string', 'description': 'Stadtteil-ID (2-stellig)'}, 'herkunftsgebiet': {'type': 'string', 'description': 'Herkunftsgebiet (z.B. tuerkei, ukraine, eu)'}, 'planungsraum_id': {'type': 'string', 'description': 'Planungsraum-ID (8-stellig)'}}}
socio_berlin_population
Berlin Population
Population stock for Berlin (headline figures) at the Neighborhood level (LOR Planungsraum), semi-annual. Source: Amt für Statistik Berlin-Brandenburg.
Parameters:
- rbs: "stadt" (city) | "bezirk" (Borough) | "stadtteil" | "ortsteil" (District) | "planungsraum" (Neighborhood)
- bezirk_id, stadtteil_id, ortsteil_id, planungsraum_id: geographic filters
- start/end, recent, limit, fields, include: "metadata"
Key response fields:
- einwohner_gesamt (total population), einwohner_maennlich/_weiblich (male/female)
- einwohner_deutsch/_auslaendisch (German/foreign nationals), einwohner_ohne/_mit_migrationshintergrund (without/with migration background)
- frauen_anteil, auslaender_anteil, migrationshintergrund_anteil: shares of women, foreign nationals, migration background (0â1)
Read only
Open world
Idempotent
Input schema
{'type': 'object', '$schema': 'http://json-schema.org/draft-07/schema#', 'properties': {'end': {'type': 'string', 'description': 'Ende (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'rbs': {'enum': ['stadt', 'bezirk', 'ortsteil', 'planungsraum'], 'type': 'string', 'default': 'stadt'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Maximale Anzahl Ergebnisse (öffentlich bis 1000)'}, 'start': {'type': 'string', 'description': 'Beginn (YYYY, YYYY-MM, YYYY-MM-DD)'}, 'fields': {'type': 'string', 'description': 'Komma-getrennte Feldnamen'}, 'recent': {'type': 'integer', 'maximum': 9007199254740991, 'description': 'Anzahl der aktuellsten Perioden', 'exclusiveMinimum': 0}, 'include': {'type': 'string', 'description': 'metadata für Feld-Metadaten inline'}, 'bezirk_id': {'type': 'string', 'description': 'Bezirk-ID (2-stellig, z.B. "03")'}, 'ortsteil_id': {'type': 'string', 'description': 'Ortsteil-ID (4-stellig, z.B. "0301")'}, 'planungsraum_id': {'type': 'string', 'description': 'Planungsraum-ID (8-stellig)'}}}
History
Recent tool changes
Changed
berlin_districts
Oct. 1, 2026, 2:43 a.m.
Added
search
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_census_households
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_census_buildings
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_census_rents
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_census_vacancy
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_census_dwellings
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_origin
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_age_groups
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_population
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_migration_matrix
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_migration_external
Sept. 17, 2026, 12:39 p.m.
Added
socio_berlin_construction_activity
Sept. 17, 2026, 12:39 p.m.
Added
field_metadata
Sept. 17, 2026, 12:39 p.m.
Added
macro_gdp
Sept. 17, 2026, 12:39 p.m.
Added
macro_construction_prices
Sept. 17, 2026, 12:39 p.m.
Added
macro_inflation_hicp
Sept. 17, 2026, 12:39 p.m.
Added
macro_labor_short_time_work
Sept. 17, 2026, 12:39 p.m.
Added
macro_labor_employment
Sept. 17, 2026, 12:39 p.m.
Added
macro_labor_unemployment
Sept. 17, 2026, 12:39 p.m.
Added
macro_bund_yields
Sept. 17, 2026, 12:39 p.m.
Added
macro_mortgage_lending
Sept. 17, 2026, 12:39 p.m.
Added
macro_ecb_policy_rates
Sept. 17, 2026, 12:39 p.m.
Added
listing_details
Sept. 17, 2026, 12:39 p.m.
Added
listings
Sept. 17, 2026, 12:39 p.m.
Added
market_germany_apartment_buildings
Sept. 17, 2026, 12:39 p.m.
Added
market_germany_residential
Sept. 17, 2026, 12:39 p.m.
Added
market_berlin_apartment_buildings
Sept. 17, 2026, 12:39 p.m.
Added
market_berlin_apartments
Sept. 17, 2026, 12:39 p.m.
Added
berlin_conservation_area_details
Sept. 17, 2026, 12:39 p.m.
Discover
Similar MCP servers
Microburbs Australian Property Data
au.com.microburbs/property-data
Provides Australian property, suburb, valuation, sales, rental, zoning, school, risk, geospatial, and census statistics.
Fema Nfhl
io.github.pipeworx-io/fema-nfhl
Queries FEMA's National Flood Hazard Layer for flood zones, base flood elevations, floodways, map panels and related property or …
Parcellaire — cadastre, DVF & DPE
re.parcellai/parcellaire
Provides French cadastral, property transaction, energy diagnostic, parcel context, geocoding, and property price estimation data.
Agentic House Search
io.github.asturksever/agentic-house-search
Provides UK postcode geography and neighborhood reports using government datasets covering property, crime, transport, schools, a…
mcp
ai.parceled/mcp
Provides US parcel boundaries, ownership, sales history, permits, and hail-related real estate data.
DoorProfit Crime & Neighborhood Data
com.doorprofit/doorprofit
Provides US crime, neighborhood, demographic, rent, and offender information for addresses.
SupplyGraph.AI Data
io.github.SupplyGraphAI/daasmart
Provides China-focused location, surrounding-area, company, industry-chain, property, population, retail, and regional business i…
DFX Real Estate Intelligence
io.github.Capital-W-Holdings/us-property-parcel-real-estate-debt
Provides US commercial real estate, parcel, debt maturity, bank CRE exposure, private capital, investor, ownership, occupancy, an…