DreamFactory
Self-hosted platform that auto-generates governed REST APIs from any database and provides a built-in MCP server for safe AI/LLM data access.
Smart Download
Visit Project Homepage
No installer available yet — head to the source repository
Automatically generate governed REST APIs from any database, with built-in MCP server for secure AI/LLM integration.
Core Features
- Auto-generate REST APIs from any SQL/NoSQL database without coding
- Role-based access control, API keys, SSO, and audit logging for governance
- Built-in MCP server lets AI models (ChatGPT, Claude) query databases via secure API calls
- Supports MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, file storage, and more
- Extensible with server-side scripting, webhooks, multi-tenant support
What It Can't Do
- •Free community edition has daily API call limits (1000/day) – consider commercial license for production. 2. Self-hosting requires server administration skills. 3. MCP server only supports read queries, not writes or transactions. 4. Always set up authentication (API keys, SSO) before exposing APIs publicly.
Use Cases
- Building a governed API gateway for legacy databases without backend code
- Connecting enterprise data securely to AI models (e.g., internal knowledge Q&A)
- Providing a secured backend for mobile and web apps
- Replacing hand-coded CRUD APIs with auto-documented endpoints
Detailed Introduction
DreamFactory is a self-hosted enterprise data access platform that instantly creates full-featured REST APIs from any database (SQL, NoSQL, file storage) without writing code. It provides role-based access control, API key management, SSO authentication, and audit logging to govern data access. A built-in MCP (Model Context Protocol) server allows AI models like ChatGPT and Claude to query databases through deterministic API calls instead of raw SQL, ensuring security and governance. DreamFactory supports MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, and many more. It can be deployed on-premises via Docker, Kubernetes, Linux, or Windows, making it ideal for API-first development, AI data access, legacy modernization, and microservices backends.
Troubleshooting & FAQ (2)
TroubleshootingWhy does DreamFactory Docker show a white screen and 'dreamfactoryApp' module error after setup?
This is a known issue in versions prior to 5.4.1. Upgrade to the DreamFactory Docker image version 5.4.1 or later. If the error persists, clear your browser cache and restart the container after pulling the latest image.
TroubleshootingWhy does the DreamFactory package export URL contain port :80 when using HTTPS?
This happens when DreamFactory is behind a reverse proxy that maps external port 443 to internal port 80. The package manager reads the internal port (80) from the server environment and includes it in the download URL. As a quick workaround, manually remove :80 from the URL after export. For a permanent fix, ensure your proxy forwards the correct port via X-Forwarded-Port header, or configure DreamFactory to use the external hostname/port directly.
Tags
Getting Started
Download installer
Click the button above to download the installer for your system
Install the software
Double-click the downloaded installer and follow the prompts
Install via Docker, Linux installer, Windows installer, or Kubernetes Helm
Add your database (e.g., MySQL) in the admin console; API is automatically generated
Create API keys and set roles to control permissions per endpoint
- Install via Docker, Linux installer, Windows installer, or Kubernetes Helm
- Add your database (e.g., MySQL) in the admin console; API is automatically generated
- Create API keys and set roles to control permissions per endpoint
Checksum not available
This project has not published a SHA-256 checksum on its GitHub Release page
SHA256 Checksum
No checksum available
Download directly from GitHub Releases and verify file integrity yourself
All SHA-256 checksums on this platform are extracted from the project's official GitHub Release page, without any modification. You can independently verify them on the GitHub Releases page.
Open Source Transparency
View GitHub SourceUninstall Info
For Docker: stop and remove container and volumes. For Linux/Windows: run uninstall script or delete installation folder and clean database. Backup config and data first.
No Extra Dependencies
Ready to use after download. No additional runtime required.
Having issues? Check the FAQ below
2 FAQs
Similar Projects
pocketbase
PocketBase is an open source Go backend that includes embedded SQLite with realtime subscriptions, built-in file & user management, admin dashboard UI, and simple REST API. Can be used as standalone app or Go framework.
code-server
Run VS Code in your browser, on any device with a consistent development environment.
Visual Studio Code (Code - OSS)
A free, open-source code editor by Microsoft with rich extensions, debugging, and Git integration. The most popular developer tool worldwide.