SQL Server MCP

Instructions

Implementation Reference

• src/tools/schema.ts:95-105 (handler)

  The handler function that executes the logic for the 'get-stored-procedures' tool. It queries INFORMATION_SCHEMA.ROUTINES for procedures and returns a formatted result.

  async getStoredProcedures() {
      const procedures = await database.query(`
          SELECT ROUTINE_NAME, ROUTINE_TYPE, ROUTINE_DEFINITION
          FROM INFORMATION_SCHEMA.ROUTINES
          WHERE ROUTINE_TYPE = 'PROCEDURE'
      `);
  
      if (!procedures.length) return this.toResult("No stored procedures found in the database.");
  
      return this.toResult(`Stored procedures found in the database:\n${JSON.stringify(procedures)}`);
  }

• src/tools/schema.ts:23-27 (registration)

  The exact registration of the 'get-stored-procedures' tool using server.tool(), binding the handler method.

  server.tool(
      "get-stored-procedures", 
      "Get a list of all stored procedures in the database", 
      tools.getStoredProcedures.bind(tools)
  );