The invention provides the technical scheme of a comprehensive data query and analysis system based on a power grid EMS (Enhanced Message Service) system. The comprehensive data query and analysis system comprises a server, wherein the server is used for data query and analysis and is connected with a client. The comprehensive data query and analysis system is characterized in that the client is connected with an alarm device, the alarm device comprises a shell, a circuit board is arranged in the shell, an alarm lamp and an alarm are arranged on the shell, a socket is arranged on one side of the shell, a controller is arranged on the circuit board and is connected with the client through an interface module arranged on the socket, and the controller is connected with the alarm lamp and the alarm through an alarm driving module. According to the system of the scheme, when power grid data are abnormal, an alarm can be given in time, so as to remind working personnel to process in time and avoid omitting of operating personnel.