sql Recipe - Python Eval
MCP Template Validation
| Criteria | Expected | Status |
|---|---|---|
| Template discovery | functions_template_get(language: "python") returns list | ✅ PASS |
| Filter by resource | resource == "sql" finds matches | ✅ PASS |
| Template scaffolded | sql-trigger-python-azd | ✅ PASS |
| Has trigger code | @app.sql_trigger decorator in output | ✅ PASS |
| Has IaC | projectFiles[] includes Bicep | ✅ PASS |
| Has RBAC | Appropriate role assignment | ✅ PASS |
Agent Behavior Validation
1. Agent calls: functions_template_get(language: "python")
2. Agent scans templateList.triggers[] descriptions and resource field
3. Agent selects: template where resource == "sql" → sql-trigger-python-azd
4. Agent calls: functions_template_get(language: "python", template: "sql-trigger-python-azd")
5. Agent writes: functionFiles[] + projectFiles[]Notes
- Template names may vary - use
resourcefield ordescriptionto match - Never hardcode template names - always discover via list call first
Test Date
2026-04-22
Verdict
PASS - MCP template provides complete sql trigger with IaC, RBAC, and UAMI binding.