clidbs 4.0.0

A modern CLI tool for managing databases on VPS systems with SSL support

CLIDB

A command-line tool for managing local development databases using Docker.

Features

• Create and manage PostgreSQL, MySQL, MongoDB, and Redis databases
• Automatic port allocation for multiple databases
• SSL/TLS support with automatic certificate generation
• Performance metrics monitoring
• Database backup and restore functionality
• Discord notifications for database events
• Docker installation helper

Installation

pip install clidb

Usage

Creating a Database

clidb create mydb --type postgres --version 16

Managing Databases

# List all databases
clidb list

# Get database info
clidb info mydb

# Start/stop databases
clidb start mydb
clidb stop mydb

# Remove a database
clidb remove mydb

Monitoring

# View real-time metrics
clidb metrics mydb --watch

Backup and Restore

# Create a backup
clidb backup mydb --description "Pre-deployment backup"

# List available backups
clidb backups --db mydb

# Restore from backup
clidb restore mydb 20240101_120000

# Delete a backup
clidb delete-backup mydb 20240101_120000

SSL Configuration

clidb ssl mydb example.com --email [e-mail]

Discord Notifications

You can enable Discord notifications for database events by providing a webhook URL:

clidb create mydb --discord-webhook https://discord.com/api/webhooks/...

Or set it via environment variable:

export CLIDB_DISCORD_WEBHOOK=https://discord.com/api/webhooks/...

Docker Installation

If Docker is not installed, you can use:

clidb install-docker

License

MIT