Skip to content

Latest commit

 

History

History
30 lines (20 loc) · 2.65 KB

ReadMe.md

File metadata and controls

30 lines (20 loc) · 2.65 KB

🗄️ Database Management Scripts

PostgreSQL MS SQL MySQL License: MIT

PostgreSQL PostgreSQL server MS SQL Server MS SQL server and MySQL MySQL

This repository contains a set of PowerShell and Bash scripts designed for database administrators (DBAs), DevOps engineers, and system administrators to automate database maintenance, backup, and monitoring. These scripts support PostgreSQL and Microsoft SQL Server (MSSQL), working across Windows and Linux environments

🚀 Features

  • ✅ Database Backup & Restore → Automate full/differential backups and scheduled restores.
  • ✅ User & Role Management → Create, modify, and remove users, roles, and permissions.
  • ✅ Performance Tuning → Index optimization, query performance monitoring, and logging.
  • ✅ Replication & High Availability → Automate replication setup and health checks.
  • ✅ Cross-Platform Support → PowerShell for Windows, Bash for Linux/macOS.

🗄️ Available Database Engines

  • MS SQL server MS SQL Server – Scripts for installing, managing, backing up, and optimizing Microsoft SQL Server on Windows, Linux, and Docker.
  • PostgreSQL PostgreSQL – Automation scripts for PostgreSQL installation, user management, backup, and performance tuning.
  • MySQL MySQL & MariaDB – Scripts for deploying, managing, securing, and optimizing MySQL/MariaDB databases.
  • NoSQLNoSQL DB Mnanagement scritps for NoSQL databases like MongoDb for deploying management and performance databases.

🔙 back to Repos