Microsoft releases SQL Apps foundation under MIT license
Key Takeaway
SQL Apps provides an open-source foundation for building applications using TypeScript, Azure SQL Database, and AI assistants.
Summary
Microsoft has introduced SQL Apps, an open-source project designed to help developers build application foundations using AI assistants. The project allows users to generate independent Git repositories for specific use cases like inventory or registration apps. It is released under the MIT license and focuses on a 'local-first' development workflow using Node.js and Docker.
Technical stack of SQL Apps
- Uses TypeScript and Azure SQL Database.
- Requires Node.js (version 22 or 24), .NET SDK, and Docker with Linux containers.
- Local development utilizes Data API builder and a sign-in gateway.
- Employs a managed Functions API with a stored-procedure allowlist for cloud profiles.
- Supports integration with GitHub Copilot via optional plugins.
Why it matters
By providing an MIT-licensed foundation, Microsoft offers a structured way for developers to bridge the gap between AI-generated code and functional SQL-backed applications.
Original reference: github.com →