--- title: How to Connect LLM Chat and AI Agents to Enterprise Data Using Built-In MCP in DreamFactory description: Connect LLM Chats and AI agents to enterprise data securely with DreamFactory's built-in MCP, offering fast setup, role-based access, and audit logging. image: https://blog.dreamfactory.com/hubfs/HowToMCP.jpg --- [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) Products & Services [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) API Management [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) Use Cases AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) #### [Spotlight How enterprises run on DreamFactory From healthcare to energy to finance — governance baked into every endpoint. Browse case studies →](https://www.dreamfactory.com/case-studies) Connectors SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) ![hamburger](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/menu-hamburger.svg) ![close](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/close-menu.svg) Back to main menu Products & Services Use Cases Industries Connectors [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) AI Data Models [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [![back arrow](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/orange-arrow.svg) Blog](https://blog.dreamfactory.com/) # How to Connect LLM Chat and AI Agents to Enterprise Data Using Built-In MCP in DreamFactory by Kevin Hood ![calendar icon](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/calendar-icon.svg) February 6, 2026 Table of contents RECOMMENDED ARTICLES - [A Complete Guide to API Generation](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) - [10 Best API Management Tools](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools) - [Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory](https://blog.dreamfactory.com/creating-a-microsoft-sql-server-api-in-less-than-5-minutes-with-dreamfactory) - [Hasura vs. DreamFactory: A Comprehensive Comparison](https://blog.dreamfactory.com/hasura-vs-dreamfactory) - [Build A Snowflake REST API in Less Than 5 Minutes](https://blog.dreamfactory.com/generate-a-snowflake-rest-api-in-less-than-5-minutes) ### *Secure AI Data Access for ChatGPT, Claude, Perplexity, and Any MCP-Compatible LLM* TL;DR: DreamFactory 7.4+ includes a built-in MCP **(Model Context Protocol) server** that lets you connect any LLM—ChatGPT, Claude, Perplexity, or custom AI agents—to your enterprise databases through **governed, role-based APIs**. Setup takes minutes: create an MCP service in the admin console, copy the OAuth credentials, and point your AI application to the generated endpoint. All queries are enforced with **RBAC, row-level security, and full audit logging**—so each user only sees the data they're authorized to access. --- MCP (Model Context Protocol) is becoming the standard way for AI apps to connect to tools and data—but enterprises still need governed access, least privilege, and auditability. DreamFactory is a **secure, self-hosted enterprise data access platform** that provides governed API access to any data source, connecting enterprise applications and on-prem and hybrid LLMs with role-based access and identity passthrough. With **instant API generation** (connect a database and generate a full REST API in under 60 seconds), built-in auth, **RBAC and row-level security**, audit logging, and API proxying—plus MCP now built directly into the DreamFactory platform—you get a production-ready path to connect LLMs to enterprise data, returning only what each user is allowed to see. ## New Feature: MCP Server Integration for AI Applications The most significant addition in DreamFactory 7.4+ is the new [df-mcp-server integration](https://docs.dreamfactory.com/AI/mcp-server), which implements the Model Context Protocol specification. MCP has emerged as a standard interface for connecting AI applications—including large language models, AI agents, and copilot systems—to external data sources and tools. ### What You Get for Enterprise Teams Organizations running DreamFactory can now expose their existing REST APIs to AI applications without writing custom integration code. This capability enables several high-value use cases: Conversational data access:Allow AI assistants to query data from databases, retrieve records, and perform CRUD operations through natural language interfaces—enabling true "chat with your database" experiences. AI-powered automation: Enable AI agents to interact with enterprise systems through DreamFactory's unified API layer, supporting agentic workflows across your data stack. Custom AI tooling: Build internal AI applications that leverage existing database connections and business logic without writing new integration code. Secure AI integration: Maintain DreamFactory's role-based access controls when AI systems interact with sensitive data, ensuring enterprise AI governance at every step. The MCP Server integration includes support for custom login pages, allowing organizations to maintain consistent authentication experiences across human and AI-driven access patterns. ## [![DreamFactory_blog_CTA_163x200@2x-May-07-2024-08-15-34-3229-AM](https://no-cache.hubspot.com/cta/default/44870387/interactive-167690643360.png)](https://blog.dreamfactory.com/hs/cta/wi/redirect?encryptedPayload=AVxigLIrGZ5sKaBgtRkFYOOUs6sND6bxHAr2%2FIiprRTy0Aa3esnUL2ed37tGFBbtruofSQtKnMbFH8muHkWc%2BaohnX13NbGegJrYFTg2MFrDPPSpFGv56G57aDqrOWMBsGUkIugXqJK0nPqnIqQ8PXQ38UANT7sbgZE%2FlWXZXcELCVD74kgukw%3D%3D&webInteractiveContentId=167690643360&portalId=44870387) ## Why This Matters: AI Innovation with Enterprise-Grade Data Security Customers want to roll out "chat with your data" and agentic automation quickly—but connecting LLMs to real systems raises security and governance stakes. DreamFactory + MCP helps teams move fast **without** over-exposing sensitive data. **Common risks when LLMs touch enterprise data** - Over-broad access that exposes sensitive records - Missing identity context (no per-user enforcement) - Prompt/SQL injection leading to unintended data retrieval - Lack of audit trails for compliance and incident response - Inconsistent access patterns across multiple data sources and APIs **What DreamFactory + MCP enables** - Standard MCP integration backed by a governed enterprise data/API layer - Identity passthrough with least-privilege RBAC and row-level security - Instant, consistent APIs across 20+ supported databases and systems (plus API proxying) - Auditing and logging by default to prove who accessed what - "Only return what the user is allowed to see" enforcement for production AI deployments ## Prerequisites Before you start, make sure you have: - **DreamFactory installed and running (v7.4.1 or later)** with access to the Admin Console - **An LLM client that supports MCP** — such as ChatGPT (Developer Mode), Claude Desktop, Perplexity, or any MCP-compatible AI agent framework (e.g., LangChain, LlamaIndex) - **A database to connect** (any supported database is fine—use a dev/test dataset if you're getting started) --- ## Phase 1: Creating Your MCP Service in DreamFactory DreamFactory makes the backend setup simple by automatically generating the necessary OAuth credentials and endpoints. ### Step 1: Initialize the Service 1. Log in to your DreamFactory instance as an administrator. 2. Navigate to the **AI** tab on the top menu. 3. Click the **+ (Plus)** button to create a new connection. 4. Select **MCP Server** from the available service types. ### Step 2: Basic Configuration - **API Name:** Enter a lowercase, alphanumeric name (e.g., `my_mcp_service`). This becomes part of your API URL. - **Label & Description:** Provide a friendly name and description for reference in the admin console. ### Step 3: Advanced Options Scroll down to the **Advanced options** section to link your data: - **Database Service:** Select the existing DreamFactory database service you want to expose. - **OAuth Credentials:** DreamFactory will automatically generate an **OAuth Client ID** and **OAuth Client Secret**. Save these—you'll use them to connect your LLM client. ### Step 4: Get Your MCP Endpoint 1. Go to the **API Docs** tab. 2. Find your new MCP service and run a **GET** request to view the service details. 3. Locate the **`mcp_endpoint`** field. This URL is the handshake address your LLM client will use to connect to your MCP service. --- ## Phase 2: Connecting an LLM Client to Your MCP Service Now that your MCP service is live, connect it to ChatGPT so you can start chatting with your data. **Additional instructions will be provided for additional LLMs in the near future.** In the meantime, [contact DreamFactory](https://www.dreamfactory.com/demo) to get set up with any LLM. ### Step 1: Enable Developer Mode To use custom MCP servers, ensure **Developer Mode** is enabled in your ChatGPT settings. ### Step 2: Create the AI App 1. In ChatGPT, go to **Settings → Apps → Advanced Settings**. 2. Click **Create app**. 3. Fill in the application details: - **Endpoint:** Paste the `mcp_endpoint` URL you copied from DreamFactory. - **Authentication:** Set to **OAuth**. - **Client ID & Secret:** Paste the credentials DreamFactory generated in Phase 1. ### Step 3: Connect and Authenticate 1. Open a new chat in ChatGPT. 2. Use the **Attach** (or **Plugins/Apps**) menu to select your newly created MCP application. 3. When prompted, log in via your DreamFactory instance to authorize the connection. ### Step 4: Run a Test Query Once connected, try a quick natural-language prompt such as: - "Show me the tables in my database." - "List the first 10 records from the `Users` table." ChatGPT will use MCP to fetch schema and data and present results directly in the chat. --- ## Conclusion By bridging your database and any LLM client via DreamFactory's MCP service, you turn a static data source into an interactive, AI-accessible asset. Whether you're enabling "chat with your data," building agentic workflows, or connecting an LLM database connector to your enterprise systems, this setup provides a secure, scalable foundation—so AI systems only retrieve what users are authorized to see. Ready to start? See the full [MCP service creation documentation](https://docs.dreamfactory.com/AI/mcp-service-creation) for detailed configuration options.  Or contact [DreamFactory](https://www.dreamfactory.com/demo-ai) for assistance. --- ## FAQ Q1: What is MCP (Model Context Protocol) and why does it matter for enterprise AI? MCP is a standard way for AI applications to connect to tools and data sources. For enterprises, MCP matters because it reduces custom integration work and makes it easier to standardize how LLM chat experiences and AI agents access internal systems—when paired with governance controls like RBAC, identity passthrough, and audit logging. Q2: Does DreamFactory's built-in MCP work for both "chat with your data" and AI agents? Yes. Both use cases rely on the same core capability: secure tool/data access. DreamFactory's MCP service provides a standardized connection for AI clients, while DreamFactory enforces authentication, RBAC, row-level security, and auditing so responses include only authorized data. Q3: How does DreamFactory ensure an LLM only returns data a user is allowed to see? DreamFactory uses identity passthrough (where applicable) plus authentication and role-based access control, and can enforce row-level security policies. This ensures queries are evaluated under the correct user context and restricted to the permitted tables, fields, and records. Q4: What do I need to connect ChatGPT to DreamFactory using MCP? You need DreamFactory v7.4.1+ with an MCP Server service configured, an existing database service to expose, and access to ChatGPT Developer Mode. DreamFactory generates OAuth credentials and provides an `mcp_endpoint` URL that you add in ChatGPT when creating the app connection. Q5: What LLMs and AI clients are compatible with DreamFactory's MCP server? DreamFactory's MCP server works with any client that supports the Model Context Protocol specification. This includes ChatGPT, Claude Desktop, Perplexity, LangChain, LlamaIndex, and custom AI agent frameworks. Because MCP is an open standard, any compliant client can connect using the OAuth credentials and endpoint URL that DreamFactory generates. Q6: How long does it take to set up MCP in DreamFactory? Most teams can configure their first MCP service in under 10 minutes. The process involves creating the MCP service in the admin console, selecting a database, and copying the auto-generated OAuth credentials into your LLM client. No custom integration code is required. Q7: Can AI agents write data back to the database through DreamFactory? Yes. DreamFactory's MCP integration supports full CRUD operations (Create, Read, Update, Delete), so AI agents can not only query data but also insert, update, and delete records—all governed by the same RBAC policies and audit logging that apply to read operations. Q8: How does DreamFactory's built-in MCP compare to building a custom MCP server? Building a custom MCP server requires writing and maintaining integration code, implementing authentication, managing access controls, and building audit logging from scratch. DreamFactory provides all of this out of the box: instant API generation across 20+ database types, built-in OAuth, RBAC with row-level security, and full audit trails. Teams typically save weeks of development time by using DreamFactory's built-in MCP instead of building a custom solution. Q9: Does DreamFactory MCP support streaming responses? DreamFactory's MCP server follows the MCP specification for transport, which supports Server-Sent Events (SSE) for streaming. This means LLM clients that support streaming can receive data incrementally rather than waiting for a complete response. TAGS: [DreamFactory,](https://blog.dreamfactory.com/tag/dreamfactory) [AI Data Gateway,](https://blog.dreamfactory.com/tag/ai-data-gateway) [AI Governance,](https://blog.dreamfactory.com/tag/ai-governance) [AI Data Access](https://blog.dreamfactory.com/tag/ai-data-access) ![Kevin Hood](https://blog.dreamfactory.com/hs-fs/hubfs/Imported%20sitepage%20images/T9J6AH3S5-U08J3CS0K7C-ef0996ecbb6c-512.jpg?width=100&height=100&name=T9J6AH3S5-U08J3CS0K7C-ef0996ecbb6c-512.jpg) Kevin Hood Kevin Hood is an accomplished solutions engineer specializing in data analytics and AI, enterprise data governance, data integration, and API-led initiatives. Stay Connected with The Connector Newsletter! Subscribe to stay up-to-date with DreamFactory's latest product updates, API best practices, and tech humor in your inbox. [![Dreamfactory Logo](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/Megamenu-logo.svg)](https://www.dreamfactory.com/) [Call Sales +1 (415) 993-5877](tel:+14159935877) Open – Mon–Fri 9–5 PT [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) #### Follow us - [GitHub](https://github.com/dreamfactorysoftware/dreamfactory) - [Facebook](https://www.facebook.com/dfsoftwareinc/) - [X (Twitter)](https://twitter.com/dfsoftwareinc) - [LinkedIn](https://www.linkedin.com/company/dreamfactory-software) - [YouTube](https://www.youtube.com/c/dreamfactorysoftware) ### Features [Features](https://www.dreamfactory.com/features) [Self hosted](https://www.dreamfactory.com/features#self) [API Generation](https://www.dreamfactory.com/features#api) [Security](https://www.dreamfactory.com/features#secure) [Customization](https://www.dreamfactory.com/features#custom) [Pricing](https://www.dreamfactory.com/pricing) ### Installers [Linux](https://www.dreamfactory.com/features#installer) [Docker](https://www.dreamfactory.com/features#installer) [Kubernetes](https://www.dreamfactory.com/features#installer) ### API Resources [Documentation](https://docs.dreamfactory.com/) [Case Studies](https://www.dreamfactory.com/stories) [White Papers](https://www.dreamfactory.com/resources/whitepapers) [Academy](https://www.dreamfactory.com/academy) [API Calculator](https://calculator.dreamfactory.com) [Open Source](https://github.com/dreamfactorysoftware) ### Company [Blog](https://blog.dreamfactory.com/) [Hub](https://www.dreamfactory.com/hub) [About us](https://www.dreamfactory.com/about) [Partners](https://www.dreamfactory.com/partners) [Support](https://www.dreamfactory.com/support) [Connectors](https://www.dreamfactory.com/connectors) [Contact Us](https://www.dreamfactory.com/demo) © 2025 DreamFactory. All rights reserved. [Terms of Use](https://www.dreamfactory.com/terms-of-use) [Privacy Policy](https://www.dreamfactory.com/privacy-policy) [LLMs](https://www.dreamfactory.com/llms.txt) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Kevin Hood", "url" : "https://blog.dreamfactory.com/author/kevin-hoo" }, "dateModified" : "2026-02-06T17:51:13.410Z", "datePublished" : "2026-02-06T17:51:13.000Z", "headline" : "How to Connect LLM Chat and AI Agents to Enterprise Data Using Built-In MCP in DreamFactory", "image" : [ "https://blog.dreamfactory.com/hubfs/HowToMCP.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.dreamfactory.com/how-to-connect-llm-chat-and-ai-agents-to-enterprise-data-using-built-in-mcp-in-dreamfactory", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dreamfactory.com/hubfs/DreamFactory%20-%20Orange%20-%20Transparent-1.png" } } } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "about" : [ { "@type" : "Thing", "name" : "Model Context Protocol (MCP)" }, { "@type" : "Thing", "name" : "Identity Passthrough" }, { "@type" : "Thing", "name" : "Role-Based Access Control" }, { "@type" : "Thing", "name" : "Row-Level Security" }, { "@type" : "Thing", "name" : "Audit Logging" }, { "@type" : "Thing", "name" : "Enterprise Data Access" } ], "alternativeHeadline" : "Secure AI Data Access for ChatGPT, Claude, Perplexity, and Any MCP-Compatible LLM", "articleSection" : [ "Overview & TL;DR", "New: Built-in MCP Server", "Enterprise Use Cases (chat with data, agentic automation, secure tooling)", "Security & Governance (RBAC, RLS, audit trails)", "Prerequisites", "Phase 1: Create MCP Service in DreamFactory", "Phase 2: Connect MCP Client (ChatGPT example)", "Test Queries & Validation", "Conclusion & Next Steps" ], "audience" : { "@type" : "Audience", "audienceType" : "Platform engineers, data teams, security/compliance, AI engineers" }, "description" : "DreamFactory 7.4+ includes a built-in Model Context Protocol (MCP) server that lets organizations connect ChatGPT, Claude, Perplexity, and other MCP clients to governed, role-based REST APIs over enterprise data. Setup takes minutes: create an MCP service, use the generated OAuth credentials and endpoint, and enforce RBAC, row-level security, identity passthrough, and audit logging so users only see authorized data.", "headline" : "How to Connect LLM Chat & AI Agents to Enterprise Data Using DreamFactory’s Built-in MCP", "inLanguage" : "en", "isPartOf" : { "@type" : "Blog", "name" : "Blog", "url" : "https://blog.dreamfactory.com/" }, "keywords" : "MCP, Model Context Protocol, DreamFactory 7.4, LLM, ChatGPT, Claude, Perplexity, AI agents, identity passthrough, RBAC, row-level security, audit logging, governed APIs, database REST API", "mainEntityOfPage" : { "@id" : "https://blog.dreamfactory.com/how-to-connect-llm-chat-and-ai-agents-to-enterprise-data-using-built-in-mcp-in-dreamfactory" }, "url" : "https://blog.dreamfactory.com/how-to-connect-llm-chat-and-ai-agents-to-enterprise-data-using-built-in-mcp-in-dreamfactory" } ``` ```json { "@context" : "https://schema.org", "@type" : "FAQPage", "mainEntity" : [ { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "MCP (Model Context Protocol) standardizes how LLMs connect to tools and data. Paired with DreamFactory’s governance (RBAC, identity passthrough, audit logging), it reduces custom integration work and ensures least-privilege, auditable access for chat and agent workflows." }, "name" : "What is MCP and why does it matter for enterprise AI?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Yes. The same MCP service powers conversational ‘chat with your data’ and agentic automations. DreamFactory enforces authentication, RBAC, row-level security, and logs every call." }, "name" : "Does DreamFactory’s MCP work for both chat and agents?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Requests are evaluated with identity passthrough and RBAC. Row-level security and field restrictions can be applied so results are filtered to the caller’s permissions, with full audit trails." }, "name" : "How does DreamFactory ensure an LLM only returns authorized data?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Use DreamFactory v7.4.1+ with an MCP Server service configured, select a database service, then copy the auto-generated OAuth Client ID/Secret and mcp_endpoint into ChatGPT (Developer Mode → Apps)." }, "name" : "What do I need to connect ChatGPT to DreamFactory via MCP?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Any MCP-compatible client, including ChatGPT (Developer Mode), Claude Desktop, Perplexity, and frameworks like LangChain or LlamaIndex. Provide the OAuth credentials and endpoint DreamFactory generates." }, "name" : "Which LLMs and clients are compatible?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Most teams configure an initial MCP service in under 10 minutes—no custom integration code required." }, "name" : "How long does setup take?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Yes. CRUD is supported and governed by the same RBAC, row-level policies, and audit logging as reads." }, "name" : "Can agents perform writes (CRUD) through MCP?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "DreamFactory provides instant REST APIs across 20+ databases, built-in OAuth, RBAC/RLS, identity passthrough, and auditing—saving weeks of custom MCP server work and reducing risk." }, "name" : "Why use DreamFactory’s built-in MCP instead of building my own?" }, { "@type" : "Question", "acceptedAnswer" : { "@type" : "Answer", "text" : "Yes. It follows the MCP spec transport, supporting Server-Sent Events (SSE) for clients that can stream." }, "name" : "Does DreamFactory MCP support streaming responses?" } ] } ```