1# Eval Summary
2 
3## Coverage Status
4 
5| Language | Manifest Templates | Eval | Status |
6|----------|-------------------|------|--------|
7| Python | 1 (Bicep) | ✅ | ✅ Verified |
8| TypeScript | 1 (Bicep) | — | 📋 AZD template exists |
9| C# (.NET) | 1 (Bicep) | — | 📋 AZD template exists |
10| Java | — | — | ⚠️ No AZD template |
11| JavaScript | — | — | ⚠️ No AZD template |
12| PowerShell | — | — | ⚠️ No AZD template |
13 
14> ⚠️ **Eval cost note:** Each language eval requires ~5 min of agent runtime. Python is verified end-to-end; other languages confirmed in [manifest](https://cdn.functions.azure.com/public/templates-manifest/manifest.json). Java, JavaScript, and PowerShell have no SQL AZD template. Multi-language eval expansion tracked as follow-up.
15 
16## MCP Tool Validation
17 
18| Test | Status | Details |
19|------|--------|---------|
20| `functions_template_get` | ✅ PASS | 2 calls via `azure-functions` MCP tool |
21| Template Discovery | ✅ PASS | Templates found via resource filter |
22| IaC Included | ✅ PASS | SQL Server Bicep + RBAC in projectFiles |
23| E2E Agent Test | ✅ PASS | 2 `azure-functions` calls, template `sql-trigger-python-azd` retrieved and applied |
24 
25## IaC Validation
26 
27| IaC Type | File | Syntax | Policy Compliant | Status |
28|----------|------|--------|------------------|--------|
29| Bicep | sql.bicep | ✅ | ✅ | PASS |
30| Terraform | sql.tf | ✅ | ✅ | PASS |
31 
32## Deployment Validation
33 
34| Test | Status | Details |
35|------|--------|---------|
36| AZD Template Init | ✅ PASS | `functions-quickstart-python-azd-sql` |
37| AZD Provision | ✅ PASS | Resources created in `rg-sql-eval` |
38| AZD Deploy | ✅ PASS | Function deployed to `func-api-arkwcvhvbkqwc` |
39| HTTP Response | ✅ PASS | HTTP 200 from function endpoint |
40| SQL Server | ✅ PASS | `sql-arkwcvhvbkqwc` with Entra-only auth |
41| SQL Database | ✅ PASS | `ToDo` database created |
42 
43## Results
44 
45| Test | Python |
46|------|--------|
47| Health | ✅ |
48| SQL trigger | ✅ |
49| SQL output | ✅ |
50 
51## Notes
52 
53- Templates retrieved via `functions_template_get(language: "<language>", template: "<template-name>")` MCP tool
54- Dedicated AZD templates available for Python, TypeScript, .NET
55- Requires T-SQL post-deploy for managed identity access
56 
57## IaC Features
58 
59| Feature | Bicep | Terraform |
60|---------|-------|-----------|
61| SQL Server (Entra-only) | ✅ | ✅ |
62| SQL Database | ✅ | ✅ |
63| Firewall Rules | ✅ | ✅ |
64| Private Endpoint (VNet) | ✅ | ✅ |
65| Azure Policy Compliance | ✅ | ✅ |
66 
67## Post-Deploy Note
68 
69SQL managed identity access requires T-SQL after deployment:
70```sql
71CREATE USER [<function-app-name>] FROM EXTERNAL PROVIDER;
72ALTER ROLE db_datareader ADD MEMBER [<function-app-name>];
73ALTER ROLE db_datawriter ADD MEMBER [<function-app-name>];
74```
75 
76## Test Date
77 
782026-04-22
79