Auto-generated REST APIs
Create endpoints for tables, stored procedures, and functions without coding.
DreamFactory
Generate secure REST APIs from databases and data sources, with governed access for apps and AI.
API GenerationData AccessDatabase ConnectorsAI Data Gateway
Overview
What is DreamFactory?
DreamFactory is a self-hosted data access platform that generates REST APIs from databases, file stores, and other sources without hand-coding. It creates documented endpoints for tables, stored procedures, and functions, with role-based access control, multiple authentication options, audit logging, and server-side scripting. Newer releases add a built-in MCP server and a governed LLM gateway for AI access. Developers, architects, and IT teams in regulated industries use it to expose legacy and modern data safely to applications.
Backend DevelopersSolution ArchitectsEnterprise IT TeamsData Platform TeamsRegulated Industries
Product snapshot
- Category
- Data Extraction & Collection
- Best for
- Governed API data access
- Deployment
- Cloud / On-premise
- Free trial
- Yes
- Integrations
- SQL Server, Oracle, PostgreSQL, MongoDB
- AI features
- Yes
Key features
Key features of DreamFactory
Reviews
DreamFactory reviews
Verified Reviewer
Chief Technology Officer
“Liked the built-in authentication and API layer, useful free features, and time saved on basic REST work. Found upgrades painful, debugging hard, stored procedure support limited, and query options weaker than SQL.”
Phil B.
PHP & MySQL Developer
“Liked the comprehensive feature set, granular access control, easy API setup, and strong vendor and community support. Found it very CPU-intensive, needing cache resets after database changes, with a steep learning curve.”
Taj A.
Technical Lead
“Liked the concept and how well it handles its core API function. Found nested object filtering difficult, alternate authentication setup failing even with support, and installation problems on Ubuntu 16.”
Verified Reviewer
Owner / Founder
“Liked the strong security, thorough documentation, and sample apps that make getting started quick. Noted no major drawbacks, though the platform can feel overwhelming at first.”
Verified Reviewer
Associate
“Liked building APIs rapidly without coding thanks to its convention-based approach, and support that helped with less common databases. Found the session timeout short at first, fixed with a setting change.”
Dan S.
Architect
“Liked the easy, simple interface, straightforward SQL integration, and pre and post processing features. Found SQL capabilities through the API limited, such as applying multiple filters at once.”
anjumol K.
Senior Systems Engineer
“Liked the simple, user-friendly design, responsive customer care, and reusable API services. Found the latest version did not support creating services in Python, so they used Node instead.”
Christopher G.
Administrative Coordinator
“Liked how easily it links databases and sets up endpoints, with clear endpoint documentation. Found the free version lacks email, phone, and chat support.”
Alternatives
Top DreamFactory alternatives
MuleSoft Anypoint Platform
Best forEnterprise API integration
Why choose itFull API lifecycle and integration management
Hasura
Best forGraphQL APIs over databases
Why choose itInstant GraphQL APIs with fine-grained permissions
Supabase
Best forPostgres app backends
Why choose itAuto-generated APIs on managed Postgres databases
Directus
Best forDatabase-backed content APIs
Why choose itOpen-source REST and GraphQL over SQL
Integrations
DreamFactory integrations
FAQ