// the take
DreamFactory introspects a database and generates a full REST (and OpenAPI-documented) CRUD API for it automatically, with role-based access control and an optional MCP server so AI clients query the same governed endpoints instead of raw SQL. It's aimed at teams who need an API/AI gateway in front of legacy or mixed databases (SQL Server, Oracle, Mongo, etc.) without hand-writing backend boilerplate.
Schema introspection across a genuinely wide set of SQL/NoSQL backends generates working CRUD + relationship + stored-procedure endpoints with OpenAPI docs in one pass, which is real time saved for internal tooling. Pre/post-process server-side scripting in PHP, Python, or Node means you're not stuck with pure CRUD - you can inject real business logic at any endpoint without forking the project. RBAC and API key management are granular down to table/endpoint/verb, which is the right level of control for something this exposed. The MCP server routes AI queries through the same RBAC and audit logging as everything else, rather than giving models a separate raw-SQL tool.
It's open-core: the README itself says SQL Server, Oracle, and Snowflake connectors plus LDAP, SAML, audit logging, rate limiting, and multi-tenancy are commercial-only, so the free Apache-2.0 edition is noticeably thinner than what the feature list implies. Auto-generating endpoints 1:1 from your schema couples API clients directly to your DB structure - a column rename or table split becomes an API-breaking change unless you've already layered scripting or versioning on top. It's a full Laravel/PHP stack (PHP-FPM, nginx or Apache, Redis, plus its own metadata DB) to run, which is a heavier operational footprint than single-binary alternatives like PostgREST or Hasura for the same job. Handing an API - or an LLM - broad CRUD access to a database is a much bigger attack surface than a handful of purpose-built endpoints; one RBAC misconfiguration exposes the whole schema, not a single route.
We read the README, the directory tree and a key source file in November 2026. Nobody pays to be listed. How we judge →