---

name: database-migration description: Manage database migrations and Better Auth schema. Use when adding tables, modifying schema, running migrations, or resetting the database. allowed-tools: Read, Bash, Grep

Database Migration

Manage PostgreSQL database, Better Auth schema, and GORM AutoMigrate.

GORM AutoMigrate (Backend)

Nach goca feature muss die neue Entity in backend/internal/domain/registry.go registriert werden:

Copy// internal/domain/registry.go
func AllEntities() []interface{} {
    return []interface{}{
        &UserStats{},
        &NewEntity{},  // Neue Entity hier hinzufuegen
    }
}

Das ist die EINZIGE Stelle - main.go bleibt unveraendert! GORM erstellt die Tabelle automatisch beim Backend-Start.

Database Commands

Start Database

Copymake db-up

Stop Database

Copymake db-down

Reset Database (delete all data)

Copymake db-reset

Better Auth Tables

Better Auth uses these tables (auto-created via migration):

• user - User accounts
• session - Active sessions
• account - OAuth/credential accounts
• verification - Email verification tokens

Run Better Auth Migration

Copymake db-migrate

Or manually:

Copycd frontend && bunx dotenv-cli -e .env.local -- bunx @better-auth/cli@latest migrate --config src/shared/lib/auth-server/auth.ts --yes

Generate Migration SQL (without applying)

Copycd frontend && bunx dotenv-cli -e .env.local -- bunx @better-auth/cli@latest generate --config src/shared/lib/auth-server/auth.ts

Direct Database Access

Connect to PostgreSQL

Copydocker exec nextgopg-db-1 psql -U postgres -d nextgopg

List Tables

Copydocker exec nextgopg-db-1 psql -U postgres -d nextgopg -c "\dt"

Describe Table

Copydocker exec nextgopg-db-1 psql -U postgres -d nextgopg -c "\d user"

Run SQL Query

Copydocker exec nextgopg-db-1 psql -U postgres -d nextgopg -c "SELECT * FROM \"user\""

Database Connection

Connection String

Copypostgres://postgres:postgres@localhost:5432/nextgopg

Environment Variable

Set in frontend/.env.local:

CopyDATABASE_URL=postgres://postgres:postgres@localhost:5432/nextgopg

Troubleshooting

Table doesn't exist

Run Better Auth migration:

Copycd frontend && DATABASE_URL="postgres://postgres:postgres@localhost:5432/nextgopg" bunx @better-auth/cli migrate -y

Connection refused

Start the database:

Copymake db-up

Reset everything

Copymake db-reset
make db-migrate