Systems | Development | Analytics | API | Testing

Connect Bolt to an on-prem SQL Server database without opening a single firewall port or handing over a database password. In this video I put DreamFactory in front of a SQL Server database on my local network, generate a REST API from it, lock that API down with a read-only role and a scoped API key, then I have Bolt build a live delivery operations dashboard on top of it. Bolt calls the API from a Bolt server function, so the key never reaches the browser.

Connect Lovable to an on-prem SQL Server database without opening a single firewall port or handing over a database password. In this video I put DreamFactory in front of a SQL Server database on my local network, generate a REST API from it, lock that API down with a read-only role and a scoped API key, then have Lovable build a live delivery operations dashboard on top of it. Lovable calls the API from a server-side function, so the key never reaches the browser.

Connect Google AI Studio to an on-prem SQL Server database without opening a single firewall port or handing over a database password. In this video I put DreamFactory in front of a SQL Server database on my local network, generate a REST API from it, lock that API down with a read-only role and a scoped API key, then I have AI Studio build a live delivery operations dashboard on top of it. AI Studio calls the API from its own Node server, so the key never reaches the browser.

Connect Replit to an on-prem SQL Server database without opening a single firewall port or handing over a database password. In this video I put DreamFactory in front of a SQL Server database on my local network, generate a REST API from it, lock that API down with a read-only role and a scoped API key, then I have Replit build a live delivery operations dashboard on top of it. Replit calls the API from the app's backend, so the key never reaches the browser.

Build a Logistics Dashboard on On-Prem SQL Server with DreamFactory + Base44 In this video, I connect an on-prem SQL Server database to Base44 using DreamFactory. DreamFactory serves a REST API with a read-only role and a scoped API key, and Base44 uses that API as a custom integration to build a full logistics dashboard, complete with related records, filtering, maps, and per-customer and per-driver analytics. No direct database access, no hand-written API code.

Someone adds a column. Six weeks later a consumer breaks. Schema Contracts are opt-in. Lock a table and you get a versioned hashed snapshot. Two knobs after that. Mode decides what promotes. None means no contract. Auto promotes additive drift and holds breaking. Strict holds everything for review. Runtime enforcement decides if the live API obeys the lock. Off is docs and drift only. Shape response strips extra fields. Strict also rejects writes that name a field you did not publish.

An agent in your stack reads tables and spends tokens. That has to land on a person, a department, a cost center. DreamFactory maps the agent onto an identity you already have: LDAP, OpenID Connect, SSO. Access and cost follow that person.

DreamFactory 7.7 is out. Agents have owners. API Builder is new. Schema Contracts lock the shape. The admin console is new. Four things that shipped: Agent governance. Every agent has a human owner, a role, and a key that expires in four hours. Deactivate the owner and the agent stops. API Builder. Design the endpoint the app actually wants. Custom paths, shaped responses, on services you already have. Open source, in every edition.

A walk through demo video of the DreamFactory data explorer.

Walk through of the new API Builder available in DreamFactory v7.7.