DreamFactory

DreamFactory is a self-hosted data gateway that generates documented REST APIs for databases and other data sources, with CRUD operations and filtering, pagination, and sorting options. It supports more than 30 databases, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA. Authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. Role-based controls can limit access by endpoint, table, field, operation, or row, and API activity is logged with user identity for ELK stack reporting. Server-side scripts can run before or after endpoints in Node.js, PHP, or Python. Its built-in MCP server exposes databases, file stores, and stored procedures as tools, with OAuth 2.0 and DreamFactory role permissions. The LLM gateway can route application traffic to Anthropic, OpenAI, Google Gemini, xAI, Ollama, or OpenAI-compatible models. DreamFactory runs on Linux servers, virtual machines, Docker, or Kubernetes, including air-gapped environments. The open-source version has limited features; the site directs users to book a demo for access to all databases and advanced customization and security features. The free plan includes a PostgreSQL connector. Paid plans start at $1,500 a month, billed annually, for Linux Lite.

DreamFactory combines API generation, access controls, auditing, scripting, and AI integrations for self-hosted data access. The free PostgreSQL option offers a starting point, while the listed paid plans have substantial annual pricing.

DreamFactory is aimed at seasoned developers and data architects who need governed API access to data sources. It may suit teams planning a self-hosted deployment and looking for database access controls, audit logs, or AI model routing.

DreamFactory is a self-hosted gateway that turns databases and other data sources into governed APIs. It is aimed at seasoned developers and data architects working across mixed systems, particularly where deployment control and detailed access policy matter. The strongest case is broad, auditable data access without hand-building every API; the main drawback is the sharp jump from a PostgreSQL-only free edition to expensive annual commercial plans.

Overview

DreamFactory generates documented REST APIs with CRUD operations, filtering, pagination, and sorting. Its 30-plus connectors cover SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, SAP HANA, and other databases, making it a practical fit for organizations with varied data estates. Teams with a single PostgreSQL source may find the broader platform unnecessary, while organizations that need one governed layer across many systems have a clearer reason to adopt it.

Key features

Role-based access controls can narrow permissions by endpoint, table, field, operation, and row, with identity passthrough. Authentication supports OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. That combination is suited to enterprise identity environments and fine-grained data exposure rather than simple internal prototypes.

DreamFactory logs API calls with user identity and provides an ELK stack for reporting on API traffic. Server-side scripts can run before or after endpoints in Node.js, PHP, and Python, giving development teams a way to add processing around generated APIs. The open-source edition has limited features; all-database access, advanced customization, and robust security features belong to the commercial offering.

Its built-in MCP server exposes databases, file stores, and stored procedures as tools, protected by OAuth 2.0 and DreamFactory role permissions. A governed LLM gateway can route application traffic to Anthropic, OpenAI, Google Gemini, xAI, Ollama, and OpenAI-compatible models. Those integrations make DreamFactory more relevant to controlled AI data access than a conventional API generator, but they will matter mainly to teams already operating AI-enabled applications.

Pricing

The Open Source plan costs nothing and includes the PostgreSQL connector. It is a useful entry point for evaluation or PostgreSQL-only deployments, but connector scope and open-source feature limits make it unsuitable when you need the full security and database catalog.

DF Linux Lite costs $1,500 a month, billed annually. It includes one connector of your choice plus unlimited roles, keys, API creation, and API requests. It fits a production deployment centered on one database; the single-connector ceiling is the important trade-off.

DF Linux Professional costs $4,000 a month, billed annually, with all connectors, including Oracle, Snowflake, and DB2, and unlimited connectors, roles, keys, API creation, and API requests. This is the more credible choice for multi-database enterprises, but the annual commitment is substantial.

DF Docker/Kubernetes and DF Kubernetes each cost $6,000 a month, billed annually, priced per vCPU from four vCPUs, with each additional vCPU costing $1,500. Both include all connectors, including Oracle, Snowflake, and DB2. They suit containerized or Kubernetes operations that can justify capacity-based pricing. Federal and Enterprise Docker uses custom pricing, includes all connectors, and adds a full SBOM and CVE scan.

A limited hosted trial is available. Licensing, installation, pricing for self-hosted software, and support packages are handled through the commercial process, so buyers should budget for an annual contract rather than assuming a short-term paid option.

Platforms

DreamFactory runs on Linux servers, virtual machines, Docker containers, and Kubernetes, including air-gapped environments. Its listed platform coverage is API, Linux, and self-hosted, with lifecycle management, access policies, and API analytics.

Who it's for

Choose it when experienced technical teams need consistent, policy-controlled API access across multiple databases, identity systems, and possibly AI models while retaining deployment control. It is a poor fit for a small project seeking a low-cost hosted API service, or for teams whose needs stop at a single PostgreSQL source and basic endpoints.

Pros and cons

• Pros: broad database coverage reduces one-off connector work; row-, field-, and operation-level controls support governed exposure; identity-aware audit logs and ELK reporting aid oversight; self-hosting supports Linux, containers, Kubernetes, and air-gapped environments; MCP and multi-model routing extend the gateway into controlled AI use.
• Cons: the free edition is limited to PostgreSQL and has restricted features; the first commercial tier is $1,500 a month billed annually; multi-database access requires the $4,000 tier or higher; Kubernetes pricing starts at four vCPUs and rises by $1,500 per additional vCPU.

Alternatives

For search-focused applications with a free tier capped at 10K search requests, 50K records, 5K recommendation requests, and 5K crawls per month, consider Algolia instead. Amazon API Gateway is the alternative for teams wanting a paid API gateway with a free tier across major client platforms. Pick Jitterbit App Builder when its app-and-instance plans better match your application-building needs.

Gravitee API Gateway offers a free Apache 2.0 community edition and a $2,500-per-month Planet plan. Kong Gateway provides a 30-day free trial with no Gateway limits and 30 days of analytics retention. Apigee API hub may suit eligible Apigee organizations seeking a no-additional-cost hub. Apiman is a self-hosted Apache-2.0 option with no features hidden behind paywalls, while Fusio is a free Apache 2.0 API management platform.

See the broader API Management Software list when you need to compare more gateway approaches.

Verdict

DreamFactory is a strong recommendation for technical organizations that need self-hosted, auditable API access across diverse databases and controlled AI integrations. Its fine-grained policies and deployment flexibility are the main reasons to choose it. Look elsewhere if annual pricing, a single-connector requirement, or a lightweight hosted gateway makes its commercial tiers excessive.