What happened?
When using custom-tools in MCP we are not able to run tools related to stored-procedures that require input parameters, there is no place inside the custom-tool to input them, so running the tool fails automatically. We can still run the stored-procedure through the execute_entity tool, just not through the custom-tool that is created.
Version
2.0.0-rc
What database are you using?
Azure SQL
What hosting model are you using?
Local (including CLI)
Which API approach are you accessing DAB through?
No response
Relevant log output
fail: Azure.DataApiBuilder.Mcp.Core.DynamicCustomTool[0]
Error executing custom tool get_book for entity GetBook
Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Procedure or function 'get_book_by_id' expects parameter '@id', which was not supplied.
Code of Conduct
What happened?
When using custom-tools in MCP we are not able to run tools related to stored-procedures that require input parameters, there is no place inside the custom-tool to input them, so running the tool fails automatically. We can still run the stored-procedure through the
execute_entitytool, just not through the custom-tool that is created.Version
2.0.0-rc
What database are you using?
Azure SQL
What hosting model are you using?
Local (including CLI)
Which API approach are you accessing DAB through?
No response
Relevant log output
Code of Conduct