DB Storage Manager

Professional desktop application for visualizing and managing database storage, growth, and backups across multiple database engines. Built with Python and PyQt6 by VoxHash Technologies.

Features

• Multi-Database Support — PostgreSQL, MySQL/MariaDB, SQLite, MongoDB, Redis; optional Oracle, SQL Server, ClickHouse, InfluxDB
• Storage Analysis Dashboard — Metrics, table/index sizing, growth-oriented views
• Secure Connection Management — Fernet-encrypted credential storage
• Multi-user / RBAC — Optional local accounts (users.enc), roles, and permission checks for shared workstations
• SSH tunneling — Paramiko bastion local port-forward from the Connections UI
• Monitoring & alerts — Live health banner, threshold alerts, acknowledge/refresh
• Plugin marketplace (local) — SDK + local registry: enable/disable, install from path or zip/tar.gz URL
• Query Console — Multi-engine queries with Safe Mode for write protection
• Backup & Restore — Local, S3, Google Drive, and Proton Drive (rclone) adapters with scheduling
• Modern Desktop UI — Cross-platform PyQt6 app with themes and i18n
• Optional Rust acceleration — PyO3 helpers for backup gzip, SHA-256 verification, and parallel hashing (pure-Python fallback)

Table of Contents

• Quick Start
• Installation
• Usage
• Configuration
• Documentation
• Roadmap
• Contributing
• Security
• License

Quick Start

git clone https://github.com/VoxHash/DB_Storage_Manager.git
cd DB_Storage_Manager
python3.12 -m venv venv
source venv/bin/activate  # Windows: venv\Scripts\activate
pip install --upgrade pip setuptools wheel
pip install -r requirements.txt
pip install -e .
python -m db_storage_manager.main

Full walkthrough: docs/quick-start.md

Installation

See docs/installation.md for platform notes and optional engines.

pip install -r requirements.txt
pip install -e .
db-storage-manager

Optional engines:

pip install -e ".[mssql,clickhouse,influxdb]"
pip install -e ".[oracle]"    # oracledb Thin mode; Instant Client only for Thick mode
pip install -e ".[engines]"   # all optional Python drivers

Optional native performance module (prebuilt wheels on GitHub Releases — no Rust required):

# Download the matching db_storage_native-*.whl from the latest release, then:
pip install ./db_storage_native-*.whl
python -c "from db_storage_manager.native import backend_info; print(backend_info())"

Developers building from source still need Rust + maturin (pip install -e ".[native]" then maturin develop --release under native/db_storage_native). See docs/installation.md.

Prerequisites

• Python 3.10–3.12 recommended
• Desktop session for the GUI (or QT_QPA_PLATFORM=offscreen for smoke tests)
• Optional: db_storage_native wheel from Releases, or Rust + maturin to build locally

Usage

1. Connections — add/test/save encrypted profiles (optional SSH bastion tunnel)
2. Dashboard — analyze storage for a selected connection
3. Query Console — run queries; keep Safe Mode on for production
4. Monitoring — health metrics and acknowledgeable alerts
5. Plugins — local marketplace: enable/disable, install from path or URL
6. Backups — local/S3/Google Drive/Proton Drive with optional schedules

Details: docs/usage.md

Configuration

Setting	Description	Default
Theme	light, dark, or dracula	dark
Language	i18n code	en
Safe Mode	Block non-SELECT queries	Enabled
Auto Connect	Connect on startup	Disabled
Notifications	Desktop notifications	Enabled
Telemetry	Anonymous telemetry	Disabled

User data: ~/.config/db-storage-manager/ (Linux/macOS) or %APPDATA%\DB Storage Manager\ (Windows).
Reference: docs/configuration.md

Documentation

• docs/index.md — documentation home
• Getting Started
• Architecture
• API
• Troubleshooting
• FAQ
• Examples

Roadmap

See ROADMAP.md. Next focus: deeper cloud-managed database integrations (RDS, Cloud SQL, Azure SQL).

Contributing

Read CONTRIBUTING.md. Use Conventional Commits and the PR template.

pip install -e ".[dev]"
pytest -v

Security

Report vulnerabilities to contact@voxhash.dev — SECURITY.md.

Support

• Issues: https://github.com/VoxHash/DB_Storage_Manager/issues
• Contact: contact@voxhash.dev — SUPPORT.md

License

MIT — see LICENSE.

---

Maintained by VoxHash Technologies