database-administration

A minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.

Bachelor's Thesis project focusing on the quantitative analysis and implementation of a PostgreSQL HA cluster with Patroni, etcd, and Pgpool-II.

Intelligent PostgreSQL Management Platform. Python3/GTK4 desktop IDE with SQL editor, visual schema designer, AI index advisor, built-in hooks (Auto-Vacuum, Schema Anomaly, Log Analyzer), and Python/Perl plugin system. GPLv3.

Offline toolkit for MongoDB structured logs. Slow query analysis, deterministic index advice, FTDC decoding. Never connects to your database.

A high-performance analytical data warehouse processing 1.6M records using DuckDB and Python. Features an end-to-end ETL pipeline, dimensionally modeled relational schema (Star Schema), and an interactive analytics dashboard built with Streamlit.

🔧 Curated Python scripts for MySQL administration: simplify tasks like security, backups, and performance tuning. Ready-to-use solutions for DBAs/devs to automate workflows and enforce best practices. Open-source & contributions welcome!

Open source project for performing various AWS RDS (Relational Database Service) tasks.

Policy engine that watches per-tenant database resource usage and enforces quotas — warn, throttle, cancel or block — from declarative YAML. Dry-run by default, with reversible actions.

Automated SQL Server health monitoring and real-time alerting toolkit using Python.

Read-only PostgreSQL performance diagnostics with guarded, reversible remediation. Surfaces slow queries, unused indexes, index write amplification, bloat and lock contention.

PowerShell, Python and SQL*Plus automation tools for Oracle database administration tasks.

Python library and command-line interface (CLI) tool for interacting with PostgreSQL databases, providing simplified database management, query execution, and result export functionalities.

Hands-on data technologies administration labs using PostgreSQL and dbt to teach data governance, modeling, lifecycle, security, quality, monitoring, and architecture.

Five SQL Server performance pathologies, each with the execution plan before and after and the page counts to prove it. Reproducible with one command.

User-friendly client-server software with GUI for efficient database table management and data retrieval in Python

Aplicacion desarrollada con python que permite gestionar (hacer backup y restore) a nuestras bases de datos.

PostgreSQL 18 performance and reliability lab on the TopFlow Hub schema: query casebook with plan checks, indexing, partitioning, pgBackRest PITR, switchover and failover drills, RLS and monitoring, all driven by ./lab.

Production-grade Aurora PostgreSQL 17+ DBA toolkit with incident runbooks, safe diagnostics, performance tuning, observability, HA/DR, and automation.