DreamFactory | Auto-Generate Secure REST APIs from Any Database | WarmIndex

DreamFactory is a self-hosted platform that automatically generates secure, governed REST APIs from any database, data warehouse, SaaS app, or legacy system, enabling developers and enterprises to access data easily for applications and AI.

🚀 Overview

DreamFactory solves the time-consuming and error-prone process of manually building REST APIs by instantly generating production-ready, secure APIs from existing data schemas—no coding required. It acts as a governed AI data gateway, allowing apps and local LLMs to query enterprise data without direct database access or credential exposure.

It's built for developers building front-end apps, data architects, enterprises (e.g., Intel, Nike, ExxonMobil, NIH), and teams needing secure on-prem data integration. Why build it? To make accessing data easier, faster, and more secure, evolving from an open-source tool into a robust open-core platform.

With role-based controls, scripting, and multi-tenant support, it reduces dev costs by $200K+/year and API build time to minutes.

✨ Key Features

Instant API Generation: Auto-creates REST endpoints for tables, views, stored procedures with CRUD, filtering, sorting, pagination, joins—includes OpenAPI/Swagger docs.
Security & Governance: Role-based access control (RBAC), SSO (OAuth, SAML, LDAP, Azure AD), field-level security, rate limiting, audit logs, identity passthrough.
Server-Side Scripting: Customize APIs with PHP, Python, Node.js, V8JS scripts for workflows, transformations, webhooks.
Broad Connectivity: 30+ connectors for SQL (MySQL, PostgreSQL, Oracle, Snowflake), NoSQL (MongoDB), file storage (S3, SFTP), SOAP to REST conversion.
AI Integration: Built-in MCP server for secure LLM access; upcoming enhancements in scripting and scaling.

🛠 Tech Stack

Frontend: Vue.js, Blade templates
Backend: PHP (Laravel framework), Node.js, Python, V8JS scripting
Database: Connectors for PostgreSQL, MySQL, MongoDB, Oracle, Snowflake, etc.
Auth: OAuth, SAML, OpenID, LDAP, Azure AD, API keys
Hosting: Self-hosted on Docker, Kubernetes (Helm), Linux, Snowflake, air-gapped

👥 Who Is This For?

This project is useful for:

Developers who want to generate secure APIs in minutes without boilerplate code
Teams looking for governed, on-prem data access for enterprise apps
Enterprises and AI builders integrating LLMs with sensitive data sources

📸 Screenshots / Demo

Live demo: https://www.dreamfactory.com/demo/
GitHub: https://github.com/dreamfactorysoftware/dreamfactory

🔥 Project Status

🟢 Actively building

Last updated: 2026-03-24

❓ FAQ

Is this project free?

Open Source (Apache 2.0 core edition free with community support); Freemium/Commercial edition for advanced connectors, enterprise security, and professional support—contact sales for pricing.

Is the source code available?

Yes — https://github.com/dreamfactorysoftware/dreamfactory

Can I contribute?

Yes—report issues, submit PRs on GitHub, join the community forum at community.dreamfactory.com, or provide feedback via Stack Overflow (dreamfactory tag).