Abstract The real-time & historical database of photovoltaic power plant monitoring system is used to store and manage the real-time and historical data, including power plant parameters, environmental data, and photovoltaic unit data and so on. Analyzing of this data is helpful for monitoring the status of the plant equipment, performing maintenance, and enhancing the operational efficiency of the power plant. The data models and database function of the database is designed. The data models include tags, data processing, and data storage models. Database function include the modules of the collection, storage, compression, and index query. The data collection module utilizes dynamic link libraries to access database data and configures parameters through a comprehensive data collection framework. The storage strategies involve in a combination of in-memory databases and disk-based historical databases, incorporating secondary caching technology and cloud server storage techniques. The data compression module is achieved through secondary compression methods. The index query module encompass time index files and the secondary index files to improve query speed and real-time system performance. The designed elements collectively establish an efficient monitoring system database.