Abstract: In order to make design of soft rock roadway support more efficiently，scientifically and objectively，database technique was integrated with AutoCAD secondary development to automatically generate the CAD drawing of roadway support.Taking the Mining Area of Shandong Energy Longkou Coal Group for example，Database Management Systems (DBMS) of crustal stress，soft rock properties and roadway support was established based on engineering geological materials.According to the information of roadway surrounding rock classification，crustal stress and roadway applications，support parameters was obtained by intelligent analysis and manual intervention.Then，soft rock roadway support design was completed through parametric drawing which relies on AutoLISP embedded in AutoCAD，and matched with man-machine dialogue frame created by DCL language programming.Thus，the automatically making system of soft rock roadway support was gained.

Key words: Roadway support, Database management system, AutoLISP, Artificial intelligence, Automatic mapping