Docker-Local Database Operations

Manage MySQL, PostgreSQL, and Redis databases.

0. Prerequisite Check

FIRST, verify docker-local is installed:

which docker-local > /dev/null 2>&1 && echo "docker-local: OK" || echo "docker-local: NOT INSTALLED"

If NOT installed, ask user to install:

composer global require mwguerra/docker-local
export PATH="$HOME/.composer/vendor/bin:$PATH"
docker-local init

Connect to Database CLIs

# MySQL CLI
docker-local db:mysql

# PostgreSQL CLI
docker-local db:postgres

# Redis CLI
docker-local db:redis

Create Database

# Creates main + testing database
docker-local db:create myapp

Backup Database

# Dump current project's database
docker-local db:dump

# Dump specific database
docker-local db:dump myapp

Restore Database

# Restore from SQL file
docker-local db:restore backup.sql

Run Migrations

# Fresh migration with seeds
docker-local db:fresh

Default Credentials

MySQL

Host:     mysql (container) / localhost (host)
Port:     3306
User:     laravel
Password: secret

PostgreSQL

Host:     postgres (container) / localhost (host)
Port:     5432
User:     laravel
Password: secret

GUI Connection (TablePlus, DBeaver)

From your host machine:

Host:     localhost
Port:     3306 (MySQL) / 5432 (PostgreSQL)
User:     laravel
Password: secret
Database: myapp

$ARGUMENTS