Open Source Tool for Monitoring MariaDB, PostgreSQL, and MongoDB Databases with Prometheus and Grafana

This project aims to develop an open-source tool for the dynamic monitoring of three databases: MongoDB, PostgreSQL, and MariaDB/MySQL. The tool allows users to specify connection credentials through a React web interface and view personalized dashboards in Grafana for one or multiple combined databases.

The backend is developed using Spring Boot and leverages Prometheus and Grafana to collect and visualize metrics from the selected databases.

Select Language:

• Español (Spanish)
• English

Features

1. Database Connection Configuration:

   • Users can specify credentials to connect MongoDB, PostgreSQL, and MariaDB via a dynamic form in the React application.
   • Supports combinations of different databases: for example, monitoring only MongoDB, PostgreSQL, or MariaDB, or combinations such as MongoDB + PostgreSQL.

2. Dynamic Monitoring:

   • The Spring Boot backend receives the credentials provided by the user and configures the database connections.
   • Metrics are collected with Prometheus and visualized in Grafana.

3. Grafana Visualization:

   • Preconfigured Grafana dashboards that activate according to the databases selected by the user.

4. Notification Sending:

   • Notifications are sent using Alertmanager.

Results

Welcome

Installation of admin user, Grafana, Prometheus, and other components

Login

Login (Dark mode)

Password recovery (Dark mode)

Credential management for Database Management Systems

Alert activation for Database Management Systems

Alert modification

Alert notifications triggered by rule conditions

User management

User management (full system supports dark mode)

User creation

User creation email received

Grafana Dashboards - PostgreSQL

Grafana Dashboards - MariaDB/MySQL

Grafana Dashboards - MongoDB

Grafana Dashboards - MongoDB + MariaDB/MySQL + PostgreSQL

Developer, Administrator, and User Manuals

Inside the docs/manual folder, you will find the corresponding manuals.

You can access the administrator manual here:
📄 Administrator Manual (PDF)

You can access the developer manual here:
📄 Developer Manual (PDF)

You can access the user manual here:
📄 User Manual (PDF)

Technologies Used

• Frontend: React (built with Vite), React Bootstrap for dynamic form design.
• Backend: Spring Boot.
• Monitoring and Visualization: Grafana and Prometheus.
• Database Management Systems: MongoDB, PostgreSQL, MariaDB, and H2 Database.
• Containers: Docker and Docker Compose for service orchestration.

---

Installation and Usage

1. Clone the Repository

git clone https://github.com/Anyel-ec/SecurityMonitoring
cd SecurityMonitoring

2. Run Docker

Make sure Docker is running before proceeding with the setup.

3. Run the Frontend

• Navigate to the Frontend folder
• Install dependencies:

  npm install

• Then start the project with:

  npm run dev

4. Run the Backend

• Navigate to the Backend folder
• Make sure all dependencies from pom.xml are downloaded
• Run the project using your development environment or via Maven/Gradle

5. Refer to the Administrator Manual

For more detailed setup and system administration instructions, please check the following document:
📘 Administrator Manual (PDF)

Contributions

If you wish to contribute to this project, please open an issue or submit a pull request.

License

This project is licensed under the BSD 3-Clause "New" or "Revised" License.

Team and Project Information

Open source tool service for dynamic monitoring of three DBMS: MongoDB, PostgreSQL, and MariaDB/MySQL.

Project Manager: Ing. Luis Chica, Mgtr - GitHub Profile

Developer: Ing. Angel Patiño - GitHub Profile