Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

DreamFactory

dreamfactory.com

  • Free plan
  • Linux
  • API
  • Self-hosted
6.9 Club score Visit dreamfactory.com

What DreamFactory is

DreamFactory is a self-hosted data access platform and AI data gateway that gives applications governed API access to databases and other data sources. It generates documented REST APIs with create, read, update, and delete operations, plus filtering, pagination, and sorting. DreamFactory says it supports more than 30 databases, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA. Access can be managed with role-based rules for endpoints, tables, fields, operations, and rows, alongside identity passthrough. Authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. The platform logs API calls with user identity and includes an ELK stack for traffic reporting. Server-side scripts can run around API endpoints using Node.js, PHP, or Python. A built-in MCP server can expose databases, file stores, and stored procedures as tools, while its LLM gateway can route traffic to several named model providers. DreamFactory runs on Linux servers, virtual machines, Docker, or Kubernetes, including air-gapped environments. A free plan is available; paid plans start at $1,500/mo (annual).

Who it suits

DreamFactory suits seasoned developers and data architects who need governed API access to data sources and want to speed API development. It may also fit teams that need self-hosted deployment, including in air-gapped environments.

Good to know, and what to watch

  • Generates documented REST APIs with CRUD and query options
  • Supports more than 30 named database connectors
  • Role-based controls can govern rows, fields, and operations
  • Includes an MCP server and governed LLM gateway
  • Runs on Linux, Docker, Kubernetes, and air-gapped environments
  • Open-source version has limited features
  • Free plan lists only the PostgreSQL connector
  • Paid plans start at $1,500/mo (annual)
  • Self-hosted licensing and pricing are discussed with an engineer

Federal and Enterprise Docker

—

Open Source

Free

DF Linux Lite

$1,500/mo

DF Linux Professional

$4,000/mo

Free plan

Getting started

  1. Visit https://www.dreamfactory.com/
  2. Start the limited hosted trial or choose the Open Source plan
  3. Deploy on a Linux server, virtual machine, Docker container, or Kubernetes
  4. Connect a supported database or other data source
  5. Configure authentication and role-based access policies
  6. Generate and publish documented REST APIs

Limits to check

The Open Source plan is free and lists a PostgreSQL connector, while the open-source version has limited features. DF Linux Lite costs $1,500 a month billed annually and provides one connector; higher plans expand connector access and deployment capacity.

The Club's review

Overview

DreamFactory is a self-hosted platform for generating and governing API access to databases and other data sources. It is best suited to seasoned developers and data architects managing diverse systems who want control over deployment and access. Its broad capabilities come with a steep entry point for teams that need more than the PostgreSQL-only free edition.

Key features

DreamFactory generates documented REST APIs with CRUD operations and filtering, pagination, and sorting. It supports more than 30 databases, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA. That breadth can save teams from building separate data APIs, but connector access is a key purchasing constraint: the free plan supports PostgreSQL, while the $1,500/mo annual plan buys one connector.

Role-based controls can restrict access by endpoint, table, field, operation, and row, with identity passthrough. Authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. API logs associate calls with user identities, and an ELK stack supports traffic reporting. These are useful controls for governed data access; however, the open-source edition has limited features, and access to all databases, advanced customization, and robust security features sits with the commercial offering.

Server-side scripts can run before or after API endpoints in Node.js, PHP, or Python, giving developers a way to add logic around API calls. The built-in MCP server exposes databases, file stores, and stored procedures as tools, using 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. These capabilities make DreamFactory relevant to teams building AI-connected data workflows, though the platform’s strongest case remains controlled API access to underlying systems.

Deployment options include Linux servers, virtual machines, Docker, and Kubernetes, including air-gapped environments. That flexibility suits organizations with strict hosting requirements, but also means DreamFactory is not a lightweight hosted service choice: its trial is limited and hosted, while licensing, installation, and pricing for self-hosted software are discussed with an engineer.

Pricing

The free Open Source plan costs nothing and includes a PostgreSQL connector. It is a way to start with a narrow data scope, but it is not a substitute for paid access to the wider connector catalog or the platform’s more robust security features.

DF Linux Lite costs $1,500/mo (billed annually) and includes one connector of your choice, with unlimited roles, keys, API creation, and API requests. It fits teams with one primary data source; the connector limit is a real restriction for mixed estates. DF Linux Professional costs $4,000/mo (billed annually) and adds all connectors, including Oracle, Snowflake, and DB2, while keeping roles, keys, API creation, and API requests unlimited. It is the more suitable Linux plan for teams that need to span databases.

DF Docker/Kubernetes and DF Kubernetes each cost $6,000/mo (billed annually), priced per vCPU and starting at 4 vCPU, with each additional vCPU costing $1,500. Both include all connectors, including Oracle, Snowflake, and DB2. These plans target container deployments with a larger compute footprint; the per-vCPU structure makes capacity an ongoing cost consideration.

Federal and Enterprise Docker has custom pricing and includes all connectors, plus a full SBOM and CVE scan. A limited hosted trial is available. Support packages are sold separately, so teams should account for support needs as well as license and infrastructure costs.

Platforms

DreamFactory is available for API use and self-hosted deployment on Linux, virtual machines, Docker, and Kubernetes. Air-gapped deployment is supported, making it a fit for environments that cannot rely on public connectivity.

Who it's for

Choose DreamFactory if your team has developers or data architects who need to expose multiple data sources through governed APIs, enforce granular access, and retain deployment control. It is less compelling for a small team that needs a low-cost, multi-connector starting point: the free plan is limited to PostgreSQL, and broader access begins at $1,500/mo billed annually.

Pros and cons

  • Pro: Documented REST API generation across 30+ databases can reduce custom integration work for organizations with varied data sources.
  • Pro: Granular role controls, identity-aware audit logs, and multiple authentication options support tightly governed data access.
  • Pro: Air-gapped and self-hosted deployment options serve teams with strict infrastructure requirements.
  • Con: The free edition is limited to a PostgreSQL connector, while the first paid tier allows only one connector.
  • Con: All-connector Linux access costs $4,000/mo billed annually, and container plans start at $6,000/mo billed annually with per-vCPU charges.
  • Con: The hosted trial is limited, and licensing and installation for self-hosted use are discussed with an engineer.

Alternatives

Browse API Management Software for a wider comparison across the category.

  • Kong Gateway is worth considering if its 30-day trial with no Gateway limits and 30 days of analytics retention better matches your evaluation needs.
  • Gravitee API Gateway offers a free Apache 2.0 Community Edition; consider it if an open-source API gateway is the priority.
  • Google Cloud Endpoints may suit teams whose costs are better aligned with its free usage tier of 1,999,999 API calls and per-million-call pricing model.
  • Algolia is an alternative for teams focused on search and recommendations, with a free plan covering 10K search requests, 50K records, 5K recommendation requests, and 5K crawls per month.
  • Apiman is a fit to consider if you want a self-hosted Apache-2.0 community edition with no features behind paywalls.
  • Hasura may be preferable for a limited free start: its free plan allows two databases per project, up to 100MB of data passthrough per month, and up to 3M API requests per month.
  • Apigee API hub is an option for eligible Apigee organizations in supported regions that can use it at no additional cost.
  • Fusio is another free, Apache 2.0-licensed open-source API management platform.

Verdict

DreamFactory is a strong choice for experienced teams that need controlled API access to diverse databases and want to run the platform in their own infrastructure. Its combination of connector breadth, granular permissions, auditing, and AI-oriented gateways is the reason to choose it. Look elsewhere if your budget cannot support annual paid plans or if PostgreSQL-only access is too narrow for a free start.

The verdict

DreamFactory combines API generation, access controls, auditing, scripting, and AI-oriented gateways in a self-hosted platform. The free plan is limited to a PostgreSQL connector, while broader connector access starts with paid plans at $1,500/mo (annual).

Questions people ask

Is DreamFactory free?

Yes. The Open Source plan is listed as free, and a free plan is available. Paid plans start at $1,500 a month billed annually.

Which databases can it connect to?

The platform supports 30+ databases, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA.

Where can DreamFactory run?

It can run on Linux servers, virtual machines, Docker containers, and Kubernetes, including air-gapped environments.

Does it support AI models?

Its governed LLM gateway can route application traffic to Anthropic, OpenAI, Google Gemini, xAI, Ollama, and OpenAI-compatible models.

What does the free plan include?

The Open Source plan is listed as free with a PostgreSQL connector. The open-source version has limited features.

What the maker publishes

Access controls
Role-based access controls can restrict API endpoints, tables, fields, operations, and rows, with identity passthrough. source
API generation
It generates documented REST APIs from databases and other data sources, with CRUD operations and query options such as filtering, pagination, and sorting. source
Auditing
DreamFactory logs API calls with user identity and provides an ELK stack for reporting on API traffic. source
Authentication
Its authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. source
Connectors
The site says DreamFactory supports 30+ databases and names SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA among them. source
Deployment
DreamFactory can run on Linux servers, virtual machines, Docker containers, and Kubernetes, including in air-gapped environments. source
Intended users
The company describes the platform as built for seasoned developers and data architects seeking to speed API development and reduce development time and costs. source
MCP and AI
Its built-in MCP server exposes databases, file stores, and stored procedures as tools, with OAuth 2.0 authentication and DreamFactory role permissions. source
Model integrations
The governed LLM gateway can route application traffic to Anthropic, OpenAI, Google Gemini, xAI, Ollama, or OpenAI-compatible models. source
Product
DreamFactory is a self-hosted AI data gateway and enterprise data access platform that provides governed API access to data sources. source
Scripting
Server-side scripts can run before or after API endpoints and support Node.js, PHP, and Python. source
Security limits
The features page says the open-source version has limited features and directs users to book a demo for access to all databases, advanced customization, and robust security features. source
Trial and support
The features page describes a limited hosted trial and says licensing, installation, and pricing for the self-hosted software are discussed with an engineer; support packages are listed separately on the pricing page. source

Checked against the maker's pages on 8 Oct 2026.