data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

[Enh]: Extend `auto-entities` to include `stored-procedures`

Open JerryNixon opened this issue 2 months ago • 0 comments

What?

Auto-entities automatically adds tables. Extend this to include stored procedures.

Why?

This helps us meet the needs of a larger customer base.

How?

  1. Add pattern.type property to allow table (default) and stored-procedure.
  2. Automatically include parameters through metadata query.
  3. Add template.mcp.custom-tool as a name pattern {schema}{object}{parameter}

This provides both basic REST/GraphQL support as well as new MCP tool support.

JerryNixon avatar Nov 04 '25 17:11 JerryNixon