This PR implements a new platform API for Azure SQL Database using the Azure Resource Orchestrator.

Features

• Creates a complete Azure SQL Database resource with private endpoint connectivity
• Links with an existing canvas for resource organization and identity management
• Adds necessary permissions to the canvas managed identity for the SQL resources
• Configures a private endpoint for secure connectivity to the database

Implementation Details

The implementation consists of:

1. A new ResourceGraphDefinition in infrastructure/platform-apis/azuresqldatabase.yaml that defines:

   • SQL Server with configurable administrator credentials
   • SQL Database with configurable tier and size
   • Private endpoint for secure connectivity
   • Role assignments for the canvas managed identity

2. Example usage in examples/azure-sql-database.yaml showing how to:

   • Reference an existing canvas
   • Configure SQL server settings
   • Set up database parameters
   • Specify private endpoint subnet

3. Documentation in examples/README.md with:

   • Prerequisites
   • Security considerations
   • Deployment instructions

Usage

Users can create an Azure SQL database instance by referencing their canvas and specifying the database configuration:

apiVersion: kro.run/v1alpha1
kind: AzureSqlDatabase
metadata:
  name: example-sql-database
  namespace: canvas-my-app-prd
spec:
  canvasName: my-app
  canvasEnvironment: prd
  serverName: myappserver001
  location: westeurope
  administratorLogin: sqladmin
  administratorLoginPassword: "${SECRET_PASSWORD}"
  databaseName: appdb
  privateEndpointSubnetId: "/subscriptions/..."

Fixes #1.

💡 You can make Copilot smarter by setting up custom instructions, customizing its development environment and configuring Model Context Protocol (MCP) servers. Learn more Copilot coding agent tips in the docs.