DreamFactory

DreamFactory is a self-hosted platform for turning databases and other data sources into governed APIs. It is aimed at experienced developers and data architects with varied or sensitive data estates. The central trade-off is clear: deployment and policy control are extensive, but access beyond a PostgreSQL starting point is expensive.

Overview

DreamFactory generates documented REST APIs rather than requiring a separate service for each database. Its self-hosted model suits organizations that need to keep the gateway on their own Linux infrastructure, virtual machines, containers, Kubernetes clusters, or even air-gapped networks. It is a specialist choice for teams able to manage infrastructure and API governance; smaller teams looking for a low-cost hosted API layer should look elsewhere.

Key features

The API generator exposes CRUD operations plus filtering, pagination, and sorting. More than 30 database connectors are supported, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA. That breadth is valuable when one API layer must span relational, document, and enterprise systems, although connector access is tied closely to the paid tiers.

Role-based access controls can narrow permissions by endpoint, table, field, operation, and row, with identity passthrough. Authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. API-call logging records user identity, while an ELK stack supports reporting on traffic. These controls make DreamFactory more credible for governed data access than a basic CRUD generator, but the open-source edition has limited features; all-database access, advanced customization, and stronger security capabilities require the commercial offering.

Server-side scripts can run before or after endpoints in Node.js, PHP, or Python. That gives developers a practical extension point for validation and workflow logic without abandoning generated APIs. Its built-in MCP server exposes databases, file stores, and stored procedures as tools, protected by OAuth 2.0 and DreamFactory roles. A governed LLM gateway can route application traffic to Anthropic, OpenAI, Google Gemini, xAI, Ollama, and OpenAI-compatible models, which is a useful combination for teams adding AI access while retaining centralized permissions.

Pricing

The Open Source plan costs nothing and includes the PostgreSQL connector. It is a sensible evaluation route or a fit for a PostgreSQL-only project, but it is not a broad production edition: the open-source build has limited features.

DF Linux Lite costs $1,500 a month, billed annually. It includes one connector of choice and unlimited roles, keys, API creation, and API requests. This fits a single-system deployment that needs commercial capabilities, but adding another database means moving up rather than simply expanding the allowance.

DF Linux Professional costs $4,000 a month, billed annually. It adds all connectors, including Oracle, Snowflake, and DB2, while retaining unlimited connectors, roles, keys, API creation, and API requests. It is the more appropriate Linux tier for mixed enterprise estates.

DF Docker/Kubernetes and DF Kubernetes each cost $6,000 a month, billed annually, priced per vCPU from four vCPUs with 1500.00 USD for each additional vCPU. Both include all connectors, including Oracle, Snowflake, and DB2. Their pricing makes capacity planning important for containerized deployments. Federal and Enterprise Docker has custom pricing and includes all connectors plus a full SBOM and CVE scan.

A limited hosted trial is offered, while licensing, installation, and self-hosted pricing are discussed with an engineer. Support packages are separate from these plan prices, so budget accordingly.

Platforms

DreamFactory runs as a self-hosted API service on Linux, virtual machines, Docker containers, and Kubernetes. Air-gapped deployment is supported. Its platform coverage favors infrastructure-controlled environments rather than a browser-first hosted workflow.

Who it's for

Choose DreamFactory when experienced engineering or data-architecture teams need one governed API surface across numerous databases, granular row- and field-level permissions, auditable traffic, and controlled MCP or LLM access. It is less suitable for a small project that needs multiple connectors at modest cost, or for teams without the operational capacity to run self-hosted software.

Pros and cons

Pros

More than 30 connectors can unify APIs across databases such as Oracle, Snowflake, MongoDB, and SAP HANA.

Permissions can reach rows, fields, operations, and tables, with identity passthrough for tighter governance.

Identity-aware API logs, ELK reporting, scripting, MCP, and an LLM gateway cover both operations and newer AI workloads.

Linux, Docker, Kubernetes, and air-gapped deployment support gives infrastructure teams substantial placement control.

Cons

The free edition is limited to PostgreSQL and has limited features, so it is a narrow long-term choice.

Commercial access starts at $1,500 a month billed annually, with all-connector Linux access at 4000.00 USD.

Container plans start at $6,000 a month and increase by vCPU, which can make scaling costly.

Self-hosted licensing, installation, and support involve separate commercial discussions rather than a simple all-in price.

Alternatives

For a broader gateway comparison, see API Management Software.

Kong Gateway is a better fit when a 30-day free trial with no gateway limits and 30 days of analytics retention is more important than DreamFactory's database-centric generation.

Gravitee API Gateway suits teams wanting an Apache 2.0 community edition alongside a paid Planet plan.

Jitterbit App Builder is the alternative for app-building plans covering mobile, web, and self-hosted platforms.

Algolia is designed for search and recommendations, with a free tier capped at 10K search requests per month and 50K records.

Google Cloud Endpoints fits teams preferring a usage-based Google Cloud API service with a free tier of 1,999,999 API calls.

WSO2 API Designer provides a 30-day trial and managed-interface plans for API design workflows.

Apiman is a fully open-source, self-hosted alternative with no features hidden behind paywalls in its community edition.

Hasura is a lower-cost database API option whose free plan allows two databases per project, 100MB of data passthrough per month, and 3M API requests per month.

Verdict

DreamFactory is a strong choice for seasoned teams that need self-hosted, policy-heavy API access across heterogeneous databases, especially when MCP and governed model routing matter. Look elsewhere if your budget cannot support annual plans from $1,500 a month or if a PostgreSQL-only free edition cannot cover the project.