(SQL Server) Automatic JS AI Tool Calling with Supporting JS Sources

See more AI Examples

Note: This example requires Chilkat v11.4.0 or greater.

For more information, see https://www.chilkatsoft.com/ai_javascript_tool_function_calling.asp

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- ----------------------------------------------------------------------------------
    -- The Javascript file loaded here is shown at the bottom of this page.
    -- -----------------------------------------------------------------------------------

    -- In this example, we'll load the Javascript tool functions and registry from a file.
    DECLARE @sbJs int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbJs OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @sbJs, 'LoadFile', @success OUT, 'qa_data/js_tools/toolset_5.js', 'utf-8'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @sbJs, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbJs
        RETURN
      END

    DECLARE @ai int
    EXEC @hr = sp_OACreate 'Chilkat.Ai', @ai OUT

    -- Additional JavaScript code can be loaded into the AI object's internal JS engine
    -- by calling RegisterJsTools with evalOnly = 1.
    DECLARE @sbExtraJs int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbExtraJs OUT

    EXEC sp_OAMethod @sbExtraJs, 'Append', @success OUT, 'function getOrderTotal({ order_id }) { return 149.95; }'

    -- When evalOnly equals 1, it tells Chilkat that no toolRegistry will be present.
    -- The purpose for doing the eval is to add function definitions to the global namespace.
    -- The value passed for allowAllKeyword is meaningless (not used) when evalOnly = 1.
    DECLARE @evalOnly int
    SELECT @evalOnly = 1
    DECLARE @allowAllKeyword int
    SELECT @allowAllKeyword = 1
    EXEC sp_OAMethod @ai, 'RegisterJsTools', @success OUT, @sbExtraJs, @evalOnly, @allowAllKeyword

    -- Register the tools that will be made available to the AI.
    SELECT @evalOnly = 0
    EXEC sp_OAMethod @ai, 'RegisterJsTools', @success OUT, @sbJs, @evalOnly, @allowAllKeyword

    -- The provider can be "openai", "google", "claude", "grok", "mistral", "custom", etc.
    EXEC sp_OASetProperty @ai, 'Provider', 'openai'
    -- Use your provider's API key.
    EXEC sp_OASetProperty @ai, 'ApiKey', 'MY_API_KEY'
    -- Choose a model.
    EXEC sp_OASetProperty @ai, 'Model', 'gpt-5-mini'

    -- Tool function calling must always occur within a conversation.
    DECLARE @conversation_name nvarchar(4000)
    SELECT @conversation_name = 'convo_4'
    DECLARE @sysMessage nvarchar(4000)
    SELECT @sysMessage = 'You are a helpful business assistant'
    DECLARE @devMessage nvarchar(4000)
    SELECT @devMessage = 'Respond only with a information generated by a tool.'
    EXEC sp_OAMethod @ai, 'NewConvo', @success OUT, @conversation_name, @sysMessage, @devMessage

    -- Provide inputs
    EXEC sp_OAMethod @ai, 'InputAddText', @success OUT, 'What is the total for order A123?'

    -- Send inputs, tool functions, etc. and ask for a "text" response.
    -- If the AI responds with tool calls, Chilkat automatically handles them by calling your JavaScript
    -- tool functions as directed by the AI, and sending results back to the AI until the final
    -- response is received.
    EXEC sp_OAMethod @ai, 'Ask', @success OUT, 'text'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @ai, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbJs
        EXEC @hr = sp_OADestroy @ai
        EXEC @hr = sp_OADestroy @sbExtraJs
        RETURN
      END

    -- Get the AI response.
    DECLARE @sbResponse int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponse OUT

    EXEC sp_OAMethod @ai, 'GetOutputTextSb', @success OUT, @sbResponse
    EXEC sp_OAMethod @sbResponse, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @sbJs
    EXEC @hr = sp_OADestroy @ai
    EXEC @hr = sp_OADestroy @sbExtraJs
    EXEC @hr = sp_OADestroy @sbResponse


END
GO

// The namespace for the AI tool functions in this JavaScript source file.
Example = {};

// Tool functions must have only one argument, which should be an object.
// The function names used here must match the "name" in the toolRegistry below.

Example.get_order_total = function(arg) {
  // Here we are calling another function that is defined in a support (additional) JavaScript source
  // that was loaded in previous call to Ai.RegisterJsTools with evalOnly = true.
  return getOrderTotal(arg);
}

Example.multiply_numbers = function(arg) {
  return arg.a * arg.b;
}

// The inputSchema.type must ALWAYS be "object".
Example.toolRegistry = [
  {
    name: "get_order_total",
    description: "Calculate total cost of an order",
    parameters: {
      properties: {
        order_id: { type: "string", description: "The order ID" },
      }
    }
  },
  {
    name: "multiply_numbers",
    description: "Multiplies two numbers and returns the product.",
    parameters: {
      properties: {
        a: { type: "number", description: "First number" },
        b: { type: "number", description: "Second number" }
      }
    }
  }
];


Example.toolPermissions = [
	  {
	    name: "all",
	    perm: "sandbox",
	  }
	  		
	];
	
	
// Return the name of this toolset
// This tells Chilkat the namespace of this toolset.
"Example";