gofasta db

Grouping for operations that wipe or recreate schema. These live under their own command rather than beside gofasta migrate precisely because they are destructive — the separation exists so nobody reaches for one by muscle memory while meaning to run a migration.


gofasta db [command]

Currently one subcommand: reset.

gofasta db reset

Rebuilds the database from nothing.


gofasta db reset

Flags

Flag	Type	Default	Description
`--skip-seed`	bool	`false`	Stop after migrations — reset the schema without loading fixtures.

The global --json flag applies as well.

What it does

Three steps, in order, each timed:

migrate drop -f — drops every table, including schema_migrations.
migrate up — re-applies every migration from version 1.
go run ./app/main seed — runs the project’s registered seed functions. Skipped with --skip-seed.

A failing step stops the run; the steps that already completed are reported with their status so you can see how far it got.

Before any of that, .env is loaded into the environment. Scaffolded projects keep their credentials there, and Docker Compose maps the database to a host port that differs from the in-container port — loading .env first is what lets both the migrate shell-out and the spawned seed process reach the same database.

Examples


# Full rebuild: drop, migrate, seed
gofasta db reset
 
# Schema only — no fixtures
gofasta db reset --skip-seed

JSON output


$ gofasta db reset --json
{
  "steps": [
    { "name": "drop", "status": "ok", "duration_ms": 118 },
    { "name": "migrate up", "status": "ok", "duration_ms": 342 },
    { "name": "seed", "status": "ok", "duration_ms": 205 }
  ],
  "duration_ms": 665
}

Each step’s status is ok, fail, or skip, with message carrying the failure reason when one applies. Per-step timings make it obvious which phase is slow when a reset starts dragging in CI.

This is irreversible

db reset destroys all data in the configured database. There is no confirmation prompt and no undo. Never point it at a shared staging database or anything resembling production. If you are unsure which database your config.yaml and .env currently resolve to, run gofasta doctor first — it reports the resolved connection and whether the database is reachable.

Requirements and configuration

Connection details are read from config.yaml, overridable with GOFASTA_-prefixed environment variables, using the same driver resolution as gofasta migrate. Schema work is delegated to golang-migrate , which must be installed and on your PATH — gofasta doctor checks for it.

Failures surface as DATABASE_RESET_FAILED; see Error codes.

gofasta init
Initialize a cloned or existing Gofasta project by installing dependencies and running code generators.
gofasta dev
Bring the full local environment up with one command — compose services + migrations + Air hot reload, with interactive restart.
gofasta debug
CLI surface for the devtools /debug/* endpoints — requests, SQL, traces, logs, errors, cache, pprof, EXPLAIN, HAR, plus the composed...
gofasta ai
Install per-agent configuration for Claude Code, Cursor, OpenAI Codex, Aider, and Windsurf — permission allowlists, hooks, project rules, and slash commands.
gofasta verify
Run the full preflight gauntlet — gofmt, vet, golangci-lint, tests, build, Wire drift, routes — in one command.
gofasta test
Run go test against the project with gofasta defaults — race detector on, every package, live output, plus shortcuts for short/integration/coverage/run-pattern.
gofasta status
Report the health of the current project — Wire drift, swagger drift, pending migrations, uncommitted generated files, module freshness.
gofasta inspect
Show the full composition of a resource — model fields, DTOs, service methods, controller methods, routes — as structured output.
gofasta inspect-jobs
Static AST scan of app/jobs/ that lists every registered cron job with its schedule from config.yaml.
gofasta inspect-tasks
Static AST scan of app/tasks/ that lists every async task with its wire name, payload shape, and handler/enqueuer presence.
gofasta impact
Reverse-dependency analysis — given a file or import path, list every package that depends on it (directly + transitively) and every Go source file in those packages.
gofasta xrefs
Type-aware reverse symbol lookup — find every reference to a Go func, type, method, var, or const across the current module.
gofasta do
Run a named development workflow — a pre-defined chain of gofasta commands that together accomplish one higher-level task.
gofasta config
Inspect and validate your project's config.yaml — currently the schema emitter, more subcommands to come.
gofasta serve
Run the project's HTTP server in production mode — no Air, no hot reload.
gofasta refactor
Switch a Gofasta project between layered and feature-package layouts without rewriting code by hand.
gofasta migrate
Run database migrations up or down for your Gofasta project, with static analysis (--explain), safe rollbacks (--steps, --all), and dirty-state repair (migrate repair).
gofasta seed
Run database seeders to populate your database with initial or test data.
gofasta deploy
Deploy a Gofasta application to a remote VPS via SSH using Docker or a compiled binary, with a health gate and automatic rollback.
gofasta wire
Regenerate Google Wire dependency injection code for your Gofasta project.
gofasta swagger
Generate OpenAPI/Swagger documentation from the `@Summary`, `@Tags`, `@Router`, and `@Param` annotations the scaffold and `g endpoint` emit.
gofasta routes
Print every registered REST route in the project as a formatted table — method, path, and source file.
gofasta console
Start an interactive Go REPL in your project directory, powered by yaegi, for one-off data inspection and exploring an API surface without writing a throwaway main().
gofasta doctor
Check system prerequisites, project configuration, and database connectivity.
gofasta upgrade
Self-update the Gofasta CLI to the latest GitHub release.
gofasta version
Print the CLI version, the Go toolchain it was compiled with, and the OS/architecture target.
Error codes
Reference for every structured error code the Gofasta CLI emits — the stable machine-readable identifiers in `--json` output, grouped by...
Database & Migrations Guide
Models, migration pairs, drivers, and relationships end to end.
gofasta migrate
Non-destructive schema movement: up, down, explain, and dirty-state repair.
gofasta seed
Run the seeders on their own, without dropping anything.