Big Tech FOSS

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 →