Abstract: In order to solve the disadvantages of low efficiency, large workload and easy to make mistakes, this article combined with the current situation of train diagram compilation, analyzed and put forward the functional requirements and construction objectives of the train diagram compilation system, designed and developed the SQLite database based train diagram compilation system by using Visual Studio development tools, implement the functions such as basic drawing of train diagram, online optimization and adjustment, train timetable key generation. The system has been applied in the operation management of Tianjin Metro, effectively improved the efficiency and quality of the operation drawing.