How to Use the NCREIF Custom Query MCP in Windsurf

Windsurf connects directly to NCREIF so Cascade can pull institutional property indices and drop them into your analysis models.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect NCREIF Custom Query MCP to Windsurf

Create your Vinkius account to connect NCREIF Custom Query to Windsurf and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup NCREIF Custom Query with Windsurf

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Windsurf automates benchmark data retrieval

This MCP Server connects your IDE directly to institutional real estate benchmarks. Tell Cascade you need quarterly office sector returns out West, and it fires off `get_historical_npi` to pull the raw index values without you clicking a single button. Cascade reads the context of your current Python script and formats the incoming data to match your pandas dataframe. It chains the retrieval directly into your workflow, sparing you the usual CSV export headache.

Custom SQL for property indices

Sometimes the standard NPI cuts do not fit your LP reporting requirements. You can instruct Cascade to run `execute_query` to slice the database using custom SQL-like syntax right from your editor using this MCP Server. The agent handles the query construction and pagination automatically. You just ask for the specific submarket yields, and the data populates your local markdown or code files instantly.

Predefined institutional KPIs

Portfolio managers track specific metrics that rarely change structure. Windsurf uses `get_predefined_kpi` to fetch these standard figures when you are building out quarterly performance summaries. Because Cascade operates autonomously, it can cross-reference these KPIs against your existing local valuation models. It grabs the exact benchmark figures and inserts them where your code expects them.

Setup guide

Set up NCREIF Custom Query MCP in Windsurf

Prerequisites

Windsurf IDE installed (macOS, Windows, or Linux)
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Click the Cascade assistant icon in the sidebar, then click the hammer icon (🔨) at the top of the panel. Select "Configure" to open ~/.codeium/windsurf/mcp_config.json.
2

Add the NCREIF Custom Query MCP

Paste the JSON snippet shown on the right into the mcpServers object. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Refresh MCPs

Go back to the hammer icon (🔨) in Cascade and click "Refresh". Windsurf will detect the new server. No full restart is needed — the connection is hot-reloaded.
4

Verify in Cascade

Start a new Cascade conversation and ask something like "Show my NCREIF Custom Query payment history." If connected, Cascade will call the NCREIF Custom Query tools directly. You will see a green dot next to the server name in the MCP panel.

mcp_config.json

{
  "mcpServers": {
    "ncreif-custom-query-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by NCREIF. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect NCREIF Custom Query now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about NCREIF Custom Query MCP in Windsurf

Open Settings, navigate to the Cascade tab, and find the MCP Servers UI. Add the server details under the mcpServers array and click Refresh in the MCP panel. You can also grab it directly from the built-in marketplace.

Yes. Cascade parses your natural language request into the exact SQL-like syntax the database requires. It handles the specific field mapping behind the scenes.

It figures that out based on your prompt. If you ask for standard returns, it hits the historical endpoint, but if you ask for a weird cross-section of industrial assets, it writes a custom query.

The API pulls the most recent restatements directly from the source. Static files get stale the moment you download them, while this integration fetches the live index.

Vinkius runs this MCP Server in an isolated V8 sandbox that only talks to the official endpoints. Your local proprietary valuation models stay on your machine while the agent fetches the NPI index returns via ephemeral connections.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript