# NCREIF Custom Query MCP for AI Agents AI Agent Connect

> NCREIF Custom Query lets you pull institutional real estate data directly into your AI client. It handles NPI and ODCE indices, timberland, and farmland data using SQL-like queries. Stop manually digging through reports and start getting precise, filterable numbers on cap rates, occupancy, and returns for major US property types across various regions and CBSAs.

## Overview
- **Category:** real-estate
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_VzyCbnu9T8cxJnoytEbL04bohh0vpWL42CP9VtUG/ai-agent-connect
- **Tags:** investment-data, sql-queries, property-index, financial-analysis, institutional-data, market-intelligence

## Description

Researching institutional real estate usually feels like a scavenger hunt. You're jumping between spreadsheets, trying to track the latest NPI returns or digging for specific farmland yields across different regions. It's a lot of manual heavy lifting just to get a clear picture of the market. This Connector changes that by letting your AI client do the heavy lifting for you. Instead of copy-pasting data from a portal, you can ask your agent to pull specific metrics on property types or regional performance. It handles the data extraction for the NCREIF Property Index and Fund Index so you can focus on the actual analysis. When you use this through the Vinkius catalog, you're basically giving your AI a direct line to professional-grade market intelligence. You can filter by CBSA, property type, or specific dates without having to navigate a complex web of menus. It turns a tedious data-gathering process into a conversation where you just ask for the numbers you need and get them back ready for your next report. This means you can build out a portfolio comparison or a regional risk assessment in a single prompt. You're no longer limited by what you can quickly find in a single PDF. You have the ability to slice and dice institutional data by any parameter the index supports, giving you a much sharper edge in your investment research.

## Tools

### execute_query
You can run custom SQL-like queries to pull specific property datasets. This lets you use where clauses to filter by region, property type, or specific years.

### get_historical_npi
You can pull historical return data for the NPI index. This is useful for building multi-year trend lines for your investment reports.

### get_predefined_kpi
You can get standard metrics like cap rates and occupancy percentages. This saves you from writing custom queries for the most common market benchmarks.

## Prompt Examples

**Prompt:** 
```
What were the NPI total returns for the last 3 quarters?
```

**Response:** 
```
I've pulled the NPI returns for the last three quarters. Here is the breakdown:

| Quarter | Total Return |
| --- | --- |
| Q1 2025 | 1.1% |
| Q2 2025 | 0.9% |
| Q3 2025 | 1.2% |

The trend shows a steady increase in returns over the last nine months.
```

**Prompt:** 
```
Give me the cap rates for industrial properties in the Northeast.
```

**Response:** 
```
Here are the current cap rates for industrial properties in the Northeast region:

* **New York**: 5.8%
* **Pennsylvania**: 6.2%
* **New Jersey**: 6.0%
* **Massachusetts**: 5.5%

These figures represent the most recent data available from the NCREIF index.
```

**Prompt:** 
```
Show me the farmland yields for the last 5 years.
```

**Response:** 
```
Here are the farmland yields for the last 5 years:

* **2021**: 3.2%
* **2022**: 3.5%
* **2023**: 3.8%
* **2024**: 4.1%
* **2025**: 4.3%

The data shows a consistent upward trend in annual yields for this asset class.
```

## Capabilities

### Run custom SQL-like queries
Pull specific property datasets using complex filters like region or property type.

### Pull historical NPI returns
Fetch multi-year performance data for the NPI index to identify long-term trends.

### Get predefined real estate KPIs
Retrieve standard metrics like cap rates and occupancy percentages instantly.

### Filter property data by region
Narrow down market data to specific CBSAs or geographic areas using where clauses.

### Analyze timberland and farmland yields
Access specialized agricultural and timberland performance data for diversification studies.

### Monitor real-time fund index performance
Track the latest performance metrics for major US real estate fund indices.

## Use Cases

### Comparative Cap Rate Analysis
An analyst needs to compare cap rates for retail properties in three different states. They ask the agent to pull the data for all three using `get_predefined_kpi`.

### Multi-Year Trend Reporting
A manager wants to see a 5-year trend of NPI returns. They ask the agent to fetch the data using `get_historical_npi` and format it into a table.

### Regional Yield Research
A researcher needs a list of farmland yields in a specific region. They use `execute_query` with a where clause for the region and property type.

### CBSA Occupancy Checks
A broker wants to check occupancy percentages for a specific CBSA. They ask the agent to run a query for that specific location.

## Benefits

- Stop manual data scraping by using `execute_query` to pull exactly the numbers you need for your reports.
- Get accurate historical NPI returns with `get_historical_npi` to build reliable trend lines without manual lookups.
- Quickly grab standard benchmarks like cap rates using `get_predefined_kpi` instead of searching through long PDF reports.
- Filter by specific CBSAs or property types to get hyper-local data that actually matters for your specific deals.
- Analyze specialized assets like timberland and farmland yields using the same query language you already know.

## How It Works

The bottom line is you get professional-grade real estate data without the manual data entry.

1. Connect your NCREIF member credentials to the Connector.
2. Tell your AI client what specific data or metrics you need for your analysis.
3. Receive a structured data set or a summary of the results directly in your chat.

## Frequently Asked Questions

**What kind of real estate data does the NCREIF Custom Query MCP provide?**
It provides institutional real estate data, including the NCREIF Property Index (NPI), Fund Index (ODCE), and specialized yields for timberland and farmland.

**Can I use NCREIF Custom Query to get cap rates for specific regions?**
Yes. You can ask your agent to pull cap rates for specific regions or property types using the predefined KPI tools.

**Do I need a special subscription for the NCREIF Custom Query MCP?**
You will need valid NCREIF member or subscriber credentials to connect the Connector to your account.

**Can this Connector help me with farmland and timberland analysis?**
Yes, it includes specific data for these asset classes, making it easier to track yields and performance trends.

**How does NCREIF Custom Query handle historical data?**
It allows you to pull historical NPI returns, which is perfect for building out multi-year trend lines for your research.

**Can I filter results by property type or CBSA?**
Yes, you can use specific where clauses in your queries to narrow down results by property type, region, or CBSA.

**Who can access this API?**
Access is limited to NCREIF Data Contributor Members and paid Data Subscribers. You must use your website login credentials.