DreamFactory vs Supabase

DreamFactory is a self-hosted data access platform and AI data gateway that provides governed API access to data sources. It generates documented REST APIs with CRUD operations and query options such as filtering, pagination, and sorting. The company says it supports more than 30 databases, including SQL Server, Oracle, Snowflake, MySQL, PostgreSQL, MongoDB, and SAP HANA. Role-based controls can limit access by endpoint, table, field, operation, or row, while authentication options include OAuth, Active Directory, LDAP, OpenID, Okta, Auth0, and SAML. API calls are logged with user identity, with an ELK stack for traffic reporting. Server-side scripts can run before or after endpoints in Node.js, PHP, or Python. A built-in MCP server exposes databases, file stores, and stored procedures as tools, and its LLM gateway can route application traffic to several named model providers. Deployment options include Linux servers, virtual machines, Docker, and Kubernetes, including air-gapped environments. A free open-source plan includes a PostgreSQL connector; paid plans start at $1,500 a month billed annually. The company describes the platform as intended for seasoned developers and data architects.

Supabase is a backend platform built around a Postgres database, with services for authentication, storage, realtime data, and server-side functions. Every project includes a Postgres database, and paid plans add database branching and backups. Supabase Auth supports email and password, passwordless, OAuth, and mobile logins through identity providers and APIs. Realtime can listen for database changes, sync user states, and broadcast data to subscribed clients; Edge Functions run server-side code close to users. Official client libraries are available for JavaScript/TypeScript, Dart/Flutter, Swift, and Python, and documentation covers self-hosting. Supabase says data is encrypted at rest with AES-256 and in transit via TLS, and that it is SOC 2 Type 2 compliant and ISO 27001 certified. EU-hosted projects keep primary database data in-region; hosted HIPAA use requires a Business Associate Agreement. The free plan includes two active projects, paused after one week of inactivity. Pro starts at $25 /mo and includes email support; Team starts at $599 / month, while Enterprise pricing is custom.