Dbeaver

Dbeaver v2.0.0 — a utility toolkit for running tasks, checking results, converting data, analyzing output, generating content, and more from the command line.

Commands

Run via: bash scripts/script.sh <command> [args]

Each data command works in two modes:

• With arguments: saves the input with a timestamp to its dedicated log file.
• Without arguments: displays the 20 most recent entries from that log.

Data Storage

All data is stored locally in ~/.local/share/dbeaver/:

• Each command has its own log file (e.g., run.log, check.log, convert.log)
• Entries are saved in timestamp|value format
• A unified history.log records all activity across commands
• Export files are written to the same directory

Requirements

• Bash (standard system shell)
• No external dependencies — uses only coreutils (date, wc, du, grep, tail, cat)

When to Use

• When you need to log database operations and task runs from the terminal
• To track data conversions and transformations
• For analyzing and comparing datasets or schemas
• To generate and preview reports before finalizing
• When managing batch operations across multiple items
• To record configuration changes for audit trails
• For lightweight, file-based operations logging and tracking

Examples

# Run a task
dbeaver run "Execute migration script v3.2 on staging"

# Check something
dbeaver check "Verified all foreign keys are valid after migration"

# Convert data
dbeaver convert "Converted users table from Latin1 to UTF-8"

# Analyze results
dbeaver analyze "Query plan shows full table scan on orders — needs index"

# Generate a report
dbeaver generate "Monthly usage report for March 2025"

# Preview output
dbeaver preview "Sample: first 100 rows from new materialized view"

# Batch operation
dbeaver batch "Processed 15,000 records in 3 batches"

# Compare schemas
dbeaver compare "Staging vs Production: 2 column differences in users table"

# Export data
dbeaver export json

# Update config
dbeaver config "Set max_connections to 200 on primary"

# Log a status update
dbeaver status "All replicas in sync, lag < 1s"

# Create a report
dbeaver report "Weekly performance summary: 99.8% uptime"

# View all statistics
dbeaver stats

# Search for entries mentioning "migration"
dbeaver search migration

# Check recent activity
dbeaver recent

Powered by BytesAgain | bytesagain.com | hello@bytesagain.com