SQL Server MCP

Instructions

Implementation Reference

• src/tools/schema.ts:107-118 (handler)

  Handler function that queries the database for a specific stored procedure by name and returns its details including definition.

  async getStoredProcedure({ procedureName }: { procedureName: string }) {
      const procedure = await database.query(`
          SELECT ROUTINE_NAME, ROUTINE_TYPE, ROUTINE_DEFINITION
          FROM INFORMATION_SCHEMA.ROUTINES
          WHERE ROUTINE_NAME = ?
      `, [procedureName]);
  
      if (!procedure.length) return this.toResult(`Stored procedure with name: ${procedureName} not found.`);
  
      const proc = procedure[0];
      return this.toResult(`Stored Procedure: ${proc.ROUTINE_NAME}\nType: ${proc.ROUTINE_TYPE}\nDefinition:\n\`\`\`sql\n${proc.ROUTINE_DEFINITION}\n\`\`\``);
  }

• src/tools/schema.ts:32-32 (schema)

  Zod input schema defining the 'procedureName' parameter for the tool.

  { procedureName: z.string().describe("The name of the stored procedure to retrieve") },

• src/tools/schema.ts:29-34 (registration)

  Registration of the 'get-stored-procedure' tool with MCP server, including name, description, schema, and handler binding.

  server.tool(
      "get-stored-procedure",
      "Get a specific stored procedure by name",
      { procedureName: z.string().describe("The name of the stored procedure to retrieve") },
      tools.getStoredProcedure.bind(tools)
  );