This article presents a database project that stores information about coal company employees and a Java (JDBC) application. The application is intended to support the staff of the coal company during the work with SQL database. The program allows to browse, search the database, add and delete records from the database. The program and the database are designed to facilitate the flexible management of human resources in coal companies. This is a very important issue considering the total cost of hard coal production and productivity changes associated with the seasonal nature of hard coal demand. The solution presented in the article is a key aspect that could improve the financial condition of coal companies. The purpose of the work was to create a tool, the use of which would certainly limit or eliminate the problems of coal companies related to overgrowth or shortage of employment in particular months of the year. This is extremely important considering that these costs account for approximately 40% of the total production cost.