DreamFactory review

DreamFactory is a self-hosted gateway for giving applications and local LLMs governed API access to enterprise data. It sits between data sources and the software that needs to use them, generating REST APIs from schemas and services rather than requiring teams to build every endpoint by hand. It also supports MCP access for AI agents and LLMs.

The product is built around centralized access controls: it can apply role-, attribute- and field-level policies and pass through existing identity, roles and entitlements. Gateway features include routing, rate limits, throttling, quotas, caching and observability. Deployment options listed include on-premises, private cloud, edge and hybrid environments.

DreamFactory offers a free Open Source plan with a PostgreSQL connector. Paid plans start at $1,500 per month, billed annually, according to the published pricing information. That makes it an infrastructure and governance product—not simply a low-cost way to expose a database as an API.

The main draw is combining API generation with controls for who can access which data. DreamFactory can create CRUD and custom endpoints from schemas and services, then apply centralized policies rather than leaving every application to enforce access rules independently. Identity passthrough is relevant for organizations that want to use existing roles and entitlements instead of creating a parallel permission system.

Its deployment range is another practical advantage. The product supports on-premises, private cloud, edge and hybrid setups, which gives teams options when data or security requirements rule out a single hosted environment. REST and MCP access also cover both conventional applications and AI agents, while gateway controls include routing, rate limits, throttling, quotas, caching and observability.

The paid plans scale connector access in clear steps. DF Linux Lite lists one connector of choice, while Professional lists unlimited connectors and includes Oracle, Snowflake and DB2. Docker/Kubernetes plans also list those connectors and unlimited connectors, connections, roles, keys, API creation and requests. For teams that need governed access across multiple data sources, those inclusions are more consequential than the API-generation pitch alone.

The free tier is narrow: the Open Source plan lists only a PostgreSQL connector. A user on r/selfhosted reported that the free version did not support MySQL, so teams needing another database should confirm connector availability before building around it.

Paid entry is expensive. DF Linux Lite is listed at $1,500 per month billed annually, but allows one connector and excludes Oracle, Snowflake and DB2. Professional is $4,000 per month billed annually. Docker/Kubernetes starts at $6,000 per month billed annually, priced per vCPU from four vCPU, with each additional vCPU listed at $1,500. No month-to-month prices are published, and Docker/Kubernetes is also labeled custom pricing.

Support pricing is unclear in the published pricing information: Pro Support appears as both $1,000 and $1,667 per month, and Enterprise Support as both $3,500 and $7,000, each billed annually. One commenter on r/laravel also described a service-rename cache issue; another said clearing the affected service cache addressed it. That is a reported quirk, not evidence of a widespread defect.

DreamFactory’s Open Source plan is free, but includes only a PostgreSQL connector. The first paid option, DF Linux Lite, costs $1,500 per month when billed annually ($18,000 a year) and allows one connector; Oracle, Snowflake and DB2 are excluded. DF Linux Professional is $4,000 per month billed annually, with unlimited connectors and those databases included—a $2,500 monthly jump from Lite. Docker/Kubernetes and DF Kubernetes list $6,000 per month, billed annually, starting at four vCPUs; each additional vCPU is $1,500. Federal and Enterprise Docker is custom-priced. The pricing page also labels Docker/Kubernetes custom pricing, so confirm the quote. No month-to-month rates are published. Support adds more: Basic is $500 per month for one seat. Pro is listed inconsistently at $1,000 or $1,667 for two seats; Enterprise at $3,500 or $7,000 for five. The pricing page does not resolve those discrepancies.

Plan for API and access-control mapping, not just a connector swap. DreamFactory generates CRUD and custom endpoints from schemas and services, and supports identity passthrough, role and field controls, scripts, and REST and MCP access. Before switching, inventory the endpoints and policies applications rely on, plus their data connectors and API consumers. Those dependencies may need to be recreated or adapted on either side; the published materials do not describe an automated migration path. Export options for schemas, scripts, policies, logs, and configuration are not published here, so confirm what can be exported before committing. The free plan’s PostgreSQL-only connector and the $1,500-per-month paid entry point may also make DreamFactory a poor fit if your needs or budget change. The published published material includes no Reddit reports, so we can’t substantiate what users say makes them leave.