Imagine being able to ask a question about millions of UK property and business records as easily as asking a colleague—and receive a clear, data-backed answer within seconds.

That is the opportunity offered by the Doorda MCP server.

MCP stands for Model Context Protocol, a technology that enables AI assistants to connect securely to external data and software. The Doorda MCP server, powered by Metabase, allows customers to explore Doorda’s connected property and business intelligence through compatible AI tools such as ChatGPT, Claude, Cursor and VS Code.

Customers simply add the Doorda MCP server address to their chosen AI client and sign in. Once authenticated, you can ask questions about the Doorda data you are authorised to access. Your existing DoordaOnline permissions continue to determine which datasets and information are available to you.

Instead of navigating multiple tables or writing every query manually, you can begin with a straightforward business question, such as:

“Show me the average rateable value of retail properties in Manchester, grouped by postcode district.”

The AI client can use the Doorda MCP server to find the relevant information, construct the query and return the results. Depending on the client, it can also present the findings as a table or chart.

Here are five key benefits of using the Doorda MCP server.

1. Ask questions in everyday language

Exploring complex data has traditionally required knowledge of SQL, database structures or specialist analytical tools. The Doorda MCP server makes that information accessible through natural-language questions.

Rather than identifying tables, fields and joins before beginning an analysis, you can start with what you want to know. You might be interested in finding out which locations have the highest commercial rents, identify businesses connected to particular properties or compare commercial activity across different areas.

The AI client interprets the request and uses the Doorda MCP server to find and query the appropriate information. This shortens the journey from asking a question to receiving a useful, evidence-based answer.

The technology is not limited to non-technical users. Experienced analysts can also use it to accelerate initial research, test ideas and identify relevant datasets before refining or validating an analysis.

2. Explore connected Doorda datasets more easily

One of Doorda’s greatest strengths is its ability to bring together information that is normally fragmented across numerous public sources.

Doorda’s datasets cover areas including property, companies, directors, planning, energy performance, business rates and financial risk. Connecting these records can reveal relationships that would be difficult to identify when looking at each source separately.

A single investigation might combine property characteristics, occupier details, company records and business rates. Finding and joining that information manually can be time-consuming, particularly for someone unfamiliar with the underlying data structure.

The Doorda MCP server helps the AI client locate the tables, metrics and models most relevant to a question. This makes it easier to move from a broad market enquiry to a detailed investigation.

For example, you could examine whether a company owns or rents the property it occupies, investigate the companies associated with a property portfolio or compare patterns of commercial activity across neighbouring locations.

3. Retain control over data access

Making data easier to interrogate should not mean weakening the controls around it.

You connect to the Doorda MCP server by authenticating through Metabase. Your access remains governed by your existing DoordaOnline permissions, so connecting an AI client does not automatically provide unrestricted access to every Doorda dataset.

Each user can only interrogate the information they are authorised to see. Access to collections and databases can be controlled, native SQL can be restricted, and row- or column-level security can provide additional protection where required.

This enables organisations to introduce AI-assisted analysis while maintaining control over who can access particular information.

When implementing you should also consider the privacy and retention policies of your chosen AI client, as information returned through the Doorda MCP server may be processed by your AI provider.

4. Move from questions to insights faster

Traditional data analysis often requires several separate steps. First you need to locate the right dataset, understand its structure, write a query, check the results and then create a visualisation.

The Doorda MCP server can streamline much of this exploratory process. You can easily can ask follow-up questions, introduce additional filters and request new comparisons within the same conversation.

For example, you could begin by asking for retail properties in a particular region. You could then narrow the results to properties above a specified rateable value, compare different occupier types and request a visual breakdown by location.

This conversational process allows you to explore an emerging line of enquiry without starting again each time the question changes. It can help teams assess opportunities, test assumptions and identify potential risks while the information is still relevant.

5. Combine Doorda intelligence with other business data

The Doorda MCP server becomes even more valuable when an AI client is connected to other approved business systems.

Organisations could combine Doorda’s property and company intelligence with internal information from a customer relationship management platform, an internal property portfolio or another operational database.

A sales team might compare its existing customers with Doorda’s data to identify gaps in market coverage or potential new opportunities. A lender could combine internal portfolio information with property, ownership and company indicators to support risk analysis. An insurer could enrich its customer records with relevant location, business and property characteristics.

Each data source still requires appropriate security and permissions, but MCP provides a common way for an AI assistant to work across different systems. This can create a more complete view of customers, properties, markets and risks.

A new way to unlock the value of Doorda’s data

The Doorda MCP server does not replace data expertise, carefully designed analytical models or human judgement. Results should always be checked, particularly when they are used to support financial, investment or risk decisions.

What it offers is a more intuitive way for you to interact with Doorda’s connected data. You can begin with a question, explore the answer through follow-up prompts and uncover relationships that may otherwise take much longer to identify.

By combining natural-language interaction with DoordaOnline’s governed analytics environment, the Doorda MCP server can help organisations make UK property, location and business intelligence accessible to more people—and turn complex data into useful evidence more quickly.