FREE 30 Minute Demo
AI Data Gateway

Overview

Why DreamFactory exists

Data Gov, Comp, Security

Policy enforcement at the API layer

Standard API Layer

One contract for every backend

API Gateway Functionality

Routing, auth, rate limits, observability

Deployment & Integration

Self-hosted, cloud, hybrid

Developer Productivity

Auto-generated, never hand-coded

AI App Architectures

Patterns for RAG, agents, MCP

AI Data Models

AIOpenAI GGoogle Gemini CAnthropic Claude LMeta Llama MMistral AI CoCohere

Services and support

Quickstart Service Packages

Expert-led Quickstarts to production

AI Data Models

Generate & Manage REST APIs

From any database, in seconds

Features

Security, scripting, self-hosted & more

API Generation

The complete guide to auto-generated APIs

API Management

Concepts, tools, and best practises

AI Use Cases

AI Data Access

Secure, governed reads for your LLMs

MCP Server

Drop-in Model Context Protocol

Legacy Modernization

Wrap mainframes with REST

Data Governance

Audit every call, enforce every policy
Customer Case Studies
Energy Modernization Government Modernization Government Business Intelligence Manufacturing Modernization Financial Services Investor Portal Non-Profit Partner Data Sharing Professional Services Exec Dashboards Education HR and External Data Sharing

Industries

Healthcare

HIPAA-grade APIs across EHR, claims, and labs.

Financial Services

Portfolios, partners, and portals on one layer.

Government

Modernize mainframes without re-platforming.

Manufacturing

SAP, MES, and shop-floor data, governed.

SQL Database

SQL SQL Server OR Oracle PG PostgreSQL My MySQL

NoSQL & Docs

Dy DynamoDB Do DocumentDB Mo MongoDB Cb CouchDB

Cloud Warehouses

S3 S3 Ab Azureblob FS FTP/SFTP LS Local Storage

C & SaaS

Sf Salesforce API REST / SOAP
See all 30+ connectors
MySQL, REST, DreamFactory, Data Sources, Filter, API

Filtering Related Columns within DreamFactory REST API Queries

Filtering related records when joining tables using DreamFactory REST API queries is simple and convenient. See how to join related tables below.

READ MORE

by Jason Gilmore • January 18, 2026

Installation, install

Upgrading Your DreamFactory Instance

by Jason Gilmore • January 18, 2026

Conferences

Get Involved at DeveloperWeek 2026!

by Spencer Nguyen • January 18, 2026

Social Links Menu

SOA is Not a Mobile Backend

by Terence Bennett • January 18, 2026

Social Links Menu

Announcing Our iPad Winner Sam Pretorius! | Dreamfactory

by Terence Bennett • January 18, 2026

API

Private vs. Internal APIs: Similarities and Differences

by Terence Bennett • January 18, 2026

Code Automation for Generating Robust REST APIs

Recent