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.