SYSTEM_PATCHBAY v1.0

Self-Hosted Database Operations Cockpit for Postgres, MySQL & SQLite

The ultimate self-hosted database backup and management tool. Create targeted SQL dumps with pg_dump and mysqldump, restore databases on demand, and import CSV files with live column mapping — all inside your own infrastructure with Docker.

SCHEMA_EXPLORER
OmniDump dashboard showing schema explorer with table list and column details for PostgreSQL, MySQL, and SQLite databases
CAPABILITY_MATRIX

Database Operations Features

Everything you need for database backup, restore, schema exploration, and data import in one self-hosted tool.

MULTI_DB_SUPPORT

Multi-Database Management

Connect to PostgreSQL, MySQL, and SQLite databases from a unified interface. Store credentials locally, test connections securely, and switch between database servers instantly with our self-hosted database tool.

DUMP_RESTORE

SQL Dump & Restore

Generate targeted SQL dumps using native tools like pg_dump and mysqldump. Select specific tables for PostgreSQL and MySQL backups. Restore database dumps on demand with one click.

CSV_IMPORT

CSV Import with Mapping

Import CSV files to your database with intelligent column mapping. Auto-map CSV headers to database schema, import in batches with live progress streaming, and download reject files for failed rows.

SSH_TUNNEL

SSH Tunnel Integration

Connect to protected databases through secure SSH tunnels without exposing database ports. Built-in tunnel orchestration with connection pooling and automatic idle timeout management.

OPERATION_SEQUENCES

Database Workflows

From connecting to your database to backing up and importing data — streamlined workflows for every database operation.

1 FLOW_A

Connect & Inspect

  1. 1 Add database credentials (optionally with SSH tunnel config)
  2. 2 Test connection — includes tunnel-aware validation
  3. 3 Save connection and set as active
  4. 4 Explore schema: tables, columns, and metadata
2 FLOW_B

Backup & Restore

  1. 1 Open dump modal from schema explorer
  2. 2 Select dump type and specific tables (Postgres/MySQL)
  3. 3 Save dump to local storage, optionally download immediately
  4. 4 Use dumps drawer to restore, download, or delete later
3 FLOW_C

CSV ETL

  1. 1 Upload CSV file
  2. 2 Select target table from schema
  3. 3 Map CSV headers to database columns (auto-map assisted)
  4. 4 Import in batches with live progress events
  5. 5 Download reject CSV for any failed rows
TRUST_SIGNALS

Self-Hosted Security & Privacy

OmniDump is a fully self-hosted database tool that runs inside your infrastructure. No external services, no telemetry, no credential transmission to third parties.

Self-Hosted Architecture

Your data stays in your infrastructure. Credentials and dumps are stored locally in the app volume — nothing leaves your environment.

Local Persistence

Connection metadata lives in an app-local SQLite database. Dumps and reject files are written to mounted storage you control.

SSH Tunnel Support

Connect to protected databases without exposing ports. Built-in tunnel orchestration with idle timeout and connection pooling.

Explicit Error Surfacing

Server paths surface errors explicitly. Path validation on download and delete endpoints prevents traversal attacks.

Native DB Tooling

Runtime image includes pg_dump, mysqldump, sqlite3, and openssh-client. No third-party dump services — native tools only.

Docker-First Deployment

Multi-stage Docker build with runtime healthcheck. Compose examples included for production and local sandboxing.

QUERY_INDEX

Database Tool FAQ

Common questions about OmniDump's database backup, restore, and import capabilities.

[01] What databases does OmniDump support? +

OmniDump is a self-hosted database tool that supports PostgreSQL, MySQL, and SQLite. Connection credentials are stored locally in your infrastructure, and you can test connections before saving. Switch between database servers instantly via the global connection selector.

[02] Is OmniDump self-hosted only? +

Yes. OmniDump is designed as a self-hosted database management tool that runs inside your infrastructure via Docker or Docker Compose. All data — credentials, SQL dumps, reject files — stays in your environment. There is no cloud-hosted version, ensuring complete data privacy.

[03] How does SSH tunneling work for database connections? +

When adding a database connection, you can configure SSH tunnel parameters (host, port, user, private key). OmniDump orchestrates the SSH tunnel with connection pooling and idle timeout. Your database port never needs public exposure, making it secure for production databases.

[04] What happens to failed rows during CSV import? +

During CSV database import, rows that fail validation or insertion are captured in a reject file. After import completes, you can download the reject CSV to audit and fix the problematic rows. This ensures data integrity and easy error handling.

[05] Can I create selective table dumps? +

For PostgreSQL and MySQL databases, yes — select specific tables in the dump modal to create targeted SQL backups. SQLite currently performs a full database dump due to native tool limitations. Dumps are created using pg_dump and mysqldump for maximum compatibility.

[06] Can I browse or query my data in OmniDump? +

No — OmniDump is a database operations tool, not a data browser. It handles backups, restores, and CSV imports, but it's not designed to replace tools like pgAdmin, DBeaver, or TablePlus for querying and viewing your data. Use OmniDump alongside your preferred database client.