SQL Server Requires Chilkat v11.6.0+

Connect to an MCP Server

Demonstrates Mcp.Connect, which connects to an MCP server at its Streamable HTTP endpoint URL. After connecting, the server's identifying properties are available.

Background. The Model Context Protocol (MCP) lets a client interact with a server's tools, resources, and prompts over a standard JSON-RPC interface. This example connects to the public, no-authentication Microsoft Learn MCP server at https://learn.microsoft.com/api/mcp over Streamable HTTP.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @sTmp1 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @mcp int
    EXEC @hr = sp_OACreate 'Chilkat.Mcp', @mcp OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  Connect to a public MCP (Model Context Protocol) server over its Streamable HTTP endpoint.  The
    --  Microsoft Learn MCP server is public and requires no authentication.
    EXEC sp_OAMethod @mcp, 'Connect', @success OUT, 'https://learn.microsoft.com/api/mcp'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mcp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mcp
        RETURN
      END

    --  After connecting, the server's identifying information is available.

    EXEC sp_OAGetProperty @mcp, 'ServerName', @sTmp0 OUT

    EXEC sp_OAGetProperty @mcp, 'ServerVersion', @sTmp1 OUT
    PRINT 'Connected to ' + @sTmp0 + ' ' + @sTmp1

    EXEC sp_OAGetProperty @mcp, 'ProtocolVersion', @sTmp0 OUT
    PRINT 'Protocol version: ' + @sTmp0

    EXEC sp_OAMethod @mcp, 'Close', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mcp, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mcp
        RETURN
      END

    EXEC @hr = sp_OADestroy @mcp


END
GO