The DreamFactory AI Academy teaches you to connect ChatGPT, Claude, Cursor, or any AI agent to enterprise databases, with full security, RBAC, identity passthrough, and audit logging built in. Self-hosted. Your data never leaves your infrastructure.
The AI Academy teaches you to combine these layers into a single governed workflow. No new infrastructure, just new capability on top of DreamFactory.
Data stays put. Governance travels with every request. And you go from question to answer in minutes, not quarters. REST APIs, not SQL. Identity passthrough, not service accounts. Your security infrastructure, not ours.
Every DreamFactory API (every database connection, every stored procedure, every RBAC role) is a building block for AI. The gap isn't infrastructure. It's knowledge.
We built the AI Academy to bridge that gap. Whether you're already running DreamFactory in production or exploring it for the first time, you'll learn how to turn any database into a secure, AI-ready data source in minutes, not months.
With DreamFactory's native MCP Server, your APIs can be consumed by AI tools like ChatGPT, Claude, Cursor, and local LLMs, with full RBAC and identity passthrough intact. The Academy teaches you how.
"DreamFactory has allowed us to remove three or four layers of complexity out of handling the AI." Enterprise AI Implementation Team
AI tools like ChatGPT, Claude, or Cursor can connect directly to your DreamFactory instance via MCP. No new infrastructure, just a config pointing to your existing endpoints.
Identity passthrough means AI queries run as the actual user, not a shared service account. Your RBAC, stored procedure boundaries, and audit logs apply automatically. Research shows all five tested LLM applications were vulnerable to prompt-to-SQL injection. DreamFactory's parameterized queries prevent this by design.
One team eliminated $250K+ in vendor engagements and reduced 140MB of legacy code to kilobytes. Building your own LLM data layer costs $1.5M+ and takes 12-18 months. DreamFactory collapses that to days. AI responses return in 4-16 seconds.
RAG accuracy for structured enterprise data falls below 60%. Deterministic API queries through DreamFactory achieve 97%. No vector databases, no stale embeddings, no data duplication. Just real-time, governed access to your live data.
DreamFactory CTO Kevin McGahey connects ChatGPT to a live sales database through DreamFactory's MCP Server in under 5 minutes. No code. No SQL. Just plain English questions.
Each module maps to a real engineering blog post and a hands-on project. Build AI-powered features on your own DreamFactory instance, or follow along with a free trial.
Connect ChatGPT, Claude, Cursor, or any AI agent to your enterprise database through DreamFactory's AI Data Gateway, with full access controls and audit logging built in. Zero code. Zero SQL. Just questions and answers.
Configure DreamFactory's native MCP Server (v1.1.0) so AI tools like ChatGPT, Claude, or Cursor can discover and query your databases, with OAuth 2.0 + PKCE authentication and full RBAC.
Understand DreamFactory's layered security model: Role-Based Access Control, service-level permissions, table and field restrictions, and API key management. This is the foundation that governs every AI interaction.
Learn why letting AI generate raw SQL is dangerous and how stored procedures create security contracts that make AI data access predictable, auditable, and safe.
When an AI queries data on behalf of a user, who runs the query? Learn to implement identity passthrough so AI respects user permissions and generates meaningful audit trails.
Understand how REST APIs work under the hood, from Node.js/Express patterns to DreamFactory's zero-code generation, and how to design endpoints that AI agents consume efficiently.
Great API docs aren't just for humans anymore. Learn to generate documentation that both developers and AI agents can parse, discover, and act on reliably.
Walk through a real production implementation: connect a self-hosted LLM to SQL Server through DreamFactory's AI Data Gateway to generate AI-powered data summaries for any use case.
Copy-paste prompts optimized for each DreamFactory capability. Use with Claude, ChatGPT, Cursor, or any MCP-connected AI assistant.
A production pattern used by enterprise teams, achieving 4-16 second response times while eliminating layers of vendor complexity.
"We discovered our 14 billion parameter model actually outperformed our 120 billion parameter model for summarization tasks. The smaller model focused on language and context without overthinking."
Lesson: Always benchmark your specific use case. Bigger isn't always better, and smaller models mean faster responses and lower infrastructure costs.
Note: This is the scripted-service orchestration pattern (Module 08). Alternatively, AI agents can call stored procedures directly via MCP using {db}_call_stored_procedure (see Modules 01 to 04).
Vector databases and embeddings work for unstructured documents, but your structured enterprise data deserves deterministic, real-time access.
Source: The API-First Alternative to RAG for Structured Data
Every Academy module is backed by a deep-dive blog post from the DreamFactory engineering team. Start here.
CTO Kevin McGahey connects ChatGPT to a live sales database through DreamFactory's MCP Server in under 5 minutes. No code, no SQL. Just plain English questions and instant answers.
Watch video →Connect Anthropic's Claude to your enterprise data through DreamFactory. Real-time analytics, trend analysis, and root cause exploration, all through natural language conversation.
Read article →How to give AI agents enough access to unlock business value without compromising privacy, compliance, or control. A 7-step repeatable governance workflow for enterprise teams.
Read article →Building your own costs $1.5M+ and takes 12-18 months. One Fortune 500 integrated 50 data sources in 2 weeks. A clear-eyed analysis of build vs. buy for AI data infrastructure.
Read article →All five tested LLM applications were vulnerable to prompt-to-SQL injection. How API abstraction, parameterized queries, and field-level masking prevent the attacks that keep CISOs up at night.
Read article →Step-by-step guide to configuring DreamFactory's native MCP Server. Connect ChatGPT, Claude, or any MCP client with OAuth 2.0 authentication. Most teams finish in under 10 minutes.
Read article →RAG accuracy for structured data falls below 60%. Deterministic API queries achieve 97%. Why the API-first approach eliminates vector databases, reduces costs 70-80%, and cuts escalations by 90%.
Read article →A 5-layer security framework for AI database access: governed REST APIs, identity passthrough with RBAC, deterministic queries, rate limiting, and MCP for local LLMs.
Read article →A real integration story: connecting a self-hosted AI model to SQL Server via DreamFactory scripted services. Covers timeouts, auth issues, and production patterns.
Read article →Why letting AI generate ad-hoc SQL is dangerous, and how stored procedures create the security contracts AI agents need for safe, auditable enterprise data access.
Read article →When AI queries data, who runs the query? Why shared service accounts break security, and how token forwarding keeps user identity intact through the entire pipeline.
Read article →The release that made DreamFactory natively AI-ready. Native MCP Server support, Azure AD group-to-role mapping, and critical security hardening.
Read article →Complete reference for MCP server setup, 22 tool patterns, OAuth 2.0 authentication, custom login pages, and FAQ.
Read docs →We're giving away 10 DGX Sparks to help enterprises build local AI connected to their data. New and existing customers are eligible. First 10 to commit get one.
First come, first served. Book a call to discuss your AI project and DGX Spark eligibility, or DM Terence Bennett on LinkedIn.
Your DreamFactory instance is already AI-ready. Connect any AI agent to your database in about 5 minutes, then let anyone in your organization ask questions in plain English. The Academy shows you how, from first query to production AI pipelines.