mtvl is a modular, high-performance tracking backend built in Go. It allows developers to create custom tracking categories (such as Movies, TV Shows, Books, Video Games, Anime, etc.) through a pluggable module system and Goose SQL database migrations.

• Extensible Category Modules: Each category (e.g., Movies, TV Shows) is an isolated Go module implementing core.CategoryModule.
• Multi-Database Support: Driven by Goose migrations, supporting PostgreSQL, MySQL, and SQLite (out-of-the-box).
• Pluggable Auth Subsystem: Clean auth.AuthProvider interface with built-in JWT authentication + standard adapter for external providers (Auth0, Clerk, Supabase, Keycloak, or custom OIDC).
• Dynamic Category Discovery: Central registry automatically exposes active modules via GET /api/v1/categories.

make test
# or: go test -v ./...

# PostgreSQL (default)
go run main.go

# Custom PostgreSQL DSN
DB_DRIVER=postgres DB_DSN="postgres://user:pass@localhost:5432/mtvl?sslmode=disable" go run main.go

# SQLite
DB_DRIVER=sqlite3 DB_DSN=mtvl.db go run main.go

# MySQL
DB_DRIVER=mysql DB_DSN="user:pass@tcp(localhost:3306)/mtvl?parseTime=true" go run main.go

Adding a new tracking category requires only 3 steps:

Create migrations/00004_books.sql:

-- +goose Up
-- +goose StatementBegin
CREATE TABLE IF NOT EXISTS books (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id INTEGER NOT NULL,
    title VARCHAR(255) NOT NULL,
    author VARCHAR(255) DEFAULT '',
    pages_read INTEGER DEFAULT 0,
    total_pages INTEGER DEFAULT 0,
    status VARCHAR(50) DEFAULT 'plan_to_read',
    rating INTEGER DEFAULT 0,
    notes TEXT DEFAULT '',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);
-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DROP TABLE IF EXISTS books;
-- +goose StatementEnd

Create internal/modules/books/handler.go:

package books

import (
    "database/sql"
    "net/http"
    "github.com/go-chi/chi/v5"
    "mtvl/internal/core"
)

type Module struct { db *sql.DB }

func NewModule(db *sql.DB) *Module { return &Module{db: db} }

func (m *Module) Info() core.CategoryInfo {
    return core.CategoryInfo{
        Category:    "books",
        DisplayName: "Books",
        Description: "Track reading progress and books",
        Endpoint:    "/api/v1/books",
    }
}

func (m *Module) RegisterRoutes(r chi.Router, authMw func(http.Handler) http.Handler) {
    r.Route("/api/v1/books", func(sub chi.Router) {
        sub.Use(authMw)
        // Attach CRUD handlers...
    })
}

In main.go, add:

registry.Register(books.NewModule(database))

That's it! The new category will automatically show up in /api/v1/categories and its endpoints will be protected by your auth middleware.