Data API Builder 2.0 (public preview) introduces the ability to expose SQL stored procedures as custom MCP tools, making them directly callable by AI agents without extra middleware. By setting the `custom-tool: true` flag on a stored-procedure entity, DAB registers it as a named tool in the MCP `tools/list` endpoint. The post walks through installing the 2.0 preview CLI, enabling MCP, adding a full-text search stored procedure as a custom tool, and verifying it appears in the tool list. Key notes include: tool names are auto-converted to snake_case, descriptions are critical since inputSchema currently returns empty properties, RBAC is fully respected, and multiple tools can be registered. The feature only works on stored-procedure entities.

4m read timeFrom bartwullems.blogspot.com
Post cover image
Table of contents
The idea: a dedicated search toolStep by step: adding a search commandWhy descriptions matterA few things worth knowingMore information

Sort: