1# sql Recipe - Python Eval
2 
3## MCP Template Validation
4 
5| Criteria | Expected | Status |
6|----------|----------|--------|
7| Template discovery | `functions_template_get(language: "python")` returns list | ✅ PASS |
8| Filter by resource | `resource == "sql"` finds matches | ✅ PASS |
9| Template scaffolded | `sql-trigger-python-azd` | ✅ PASS |
10| Has trigger code | `@app.sql_trigger` decorator in output | ✅ PASS |
11| Has IaC | `projectFiles[]` includes Bicep | ✅ PASS |
12| Has RBAC | Appropriate role assignment | ✅ PASS |
13 
14## Agent Behavior Validation
15 
16```text
171. Agent calls: functions_template_get(language: "python")
182. Agent scans templateList.triggers[] descriptions and resource field
193. Agent selects: template where resource == "sql" → sql-trigger-python-azd
204. Agent calls: functions_template_get(language: "python", template: "sql-trigger-python-azd")
215. Agent writes: functionFiles[] + projectFiles[]
22```
23 
24## Notes
25 
26- Template names may vary - use `resource` field or `description` to match
27- Never hardcode template names - always discover via list call first
28 
29## Test Date
30 
312026-04-22
32 
33## Verdict
34 
35**PASS** - MCP template provides complete sql trigger with IaC, RBAC, and UAMI binding.
36