mavric avatar

backend-bootstrapper

Bootstraps complete backend with Apso, including API setup, database configuration, and testing. Tri

by mavric|Open Source

Backend Bootstrapper Skill

Fully automated Apso + BetterAuth backend setup in under 5 minutes with zero manual steps.

What This Skill Does

Automates the complete setup of a production-ready NestJS backend with:

  • Apso-generated REST API
  • BetterAuth integration
  • PostgreSQL database
  • Multi-tenancy support
  • OpenAPI documentation
  • Automated testing
  • Complete error handling

Quick Start

Option 1: New Backend with Auth

"Setup backend with auth"

I will:

  1. Create Apso project structure
  2. Generate .apsorc with BetterAuth entities
  3. Run code generation
  4. Auto-fix all known issues
  5. Set up database
  6. Verify everything works

Time: 5 minutes | Manual steps: 0

Option 2: Add Auth to Existing Backend

"Add auth to my backend"

I will:

  1. Analyze existing schema
  2. Detect naming conflicts
  3. Add BetterAuth entities
  4. Regenerate code
  5. Fix integration issues
  6. Test endpoints

Time: 3 minutes | Manual steps: 0

Option 3: Fix Auth Issues

"Fix auth issues"

I will automatically fix:

  • Missing id fields in DTOs
  • Nullable field constraints
  • Entity naming conflicts
  • AppModule wiring
  • Database schema issues

Time: 1 minute | Manual steps: 0

Option 4: Verify Setup

"Verify auth setup"

I will test:

  • All CRUD endpoints
  • Database integrity
  • Auth flows
  • Multi-tenancy
  • Session management

Time: 2 minutes | Manual steps: 0

File Structure

backend-bootstrapper/
├── SKILL.md                          # Main skill documentation
├── README.md                         # This file
└── references/
    ├── apsorc-templates/             # Ready-to-use .apsorc files
    │   ├── minimal-auth.json         # Basic auth setup
    │   ├── saas-platform.json        # Full SaaS (coming soon)
    │   ├── marketplace.json          # Multi-vendor (coming soon)
    │   └── collaboration-tool.json   # Team tools (coming soon)
    │
    ├── fix-scripts/                  # Automated fix scripts
    │   ├── fix-dto-id-fields.sh      # Add id to DTOs
    │   ├── fix-nullable-fields.sh    # Fix User entity nullables
    │   ├── fix-entity-conflicts.sh   # Rename conflicting entities
    │   └── fix-app-module.sh         # Wire modules correctly
    │
    ├── verification-commands/        # Testing scripts
    │   ├── test-auth-flow.sh         # Complete auth test suite
    │   ├── test-crud.sh              # CRUD endpoint tests
    │   └── test-database.sh          # Database integrity tests
    │
    ├── troubleshooting/              # Issue resolution
    │   ├── common-issues.md          # Problems & solutions
    │   └── debugging-guide.md        # Advanced debugging
    │
    ├── setup-checklist.md            # Step-by-step checklist
    ├── better-auth-integration.md    # BetterAuth deep dive
    ├── saas-implementation-guide.md  # SaaS patterns
    └── saas-tech-stack.md            # Tech stack details

What Gets Created

Backend Structure

backend/
├── src/
│   ├── autogen/           # Apso-generated (don't edit)
│   │   ├── User/
│   │   ├── account/
│   │   ├── session/
│   │   ├── verification/
│   │   └── Organization/
│   ├── extensions/        # Your custom code
│   ├── common/            # Shared utilities
│   └── main.ts
├── .apsorc                # Schema definition
├── .env.development       # Dev environment
├── docker-compose.yml     # Local PostgreSQL
└── package.json

Database Tables

  • user - Authentication users (Better Auth)
  • account - OAuth/credential providers (Better Auth)
  • session - Active sessions (Better Auth)
  • verification - Email verification (Better Auth)
  • organization - Multi-tenant root (Your business)
  • account_user - User-Organization junction (Your business)

API Endpoints

For each entity, you get:

  • GET /{entity} - List with pagination, filtering, sorting
  • GET /{entity}/{id} - Get by ID
  • POST /{entity} - Create
  • PUT /{entity}/{id} - Full update
  • PATCH /{entity}/{id} - Partial update
  • DELETE /{entity}/{id} - Delete

Plus:

  • /health - Health check
  • /api/docs - OpenAPI/Swagger UI

Key Features

Auto-Fixes

I automatically fix these common issues:

  1. Missing id in DTOs - Add id field to Create DTOs
  2. Nullable constraints - Mark User optional fields as nullable
  3. Entity conflicts - Rename Account/Session to avoid conflicts
  4. Module wiring - Import all modules in AppModule
  5. CORS configuration - Enable cross-origin requests
  6. Database schema - Reset when needed

Verification Tests

I automatically verify:

  • Server health
  • Database connection
  • Table creation
  • CRUD operations
  • Foreign keys
  • Unique constraints
  • Nullable fields
  • Enum validation

Environment Management

I create and configure:

  • .env.development - Local development
  • .env.test - Test environment
  • .env.production.example - Production template

With secure defaults for:

  • Database connection
  • BetterAuth secrets
  • CORS origins
  • Logging levels

Common Use Cases

New SaaS Project

User: "I need a backend for my SaaS product"
Skill: Creates complete authenticated backend with Organization multi-tenancy

Add Auth to Existing

User: "Add authentication to my existing backend"
Skill: Analyzes schema, adds auth entities, fixes conflicts automatically

Fix Integration Issues

User: "My auth isn't working"
Skill: Runs diagnostics, applies fixes, verifies everything works

Verify Setup

User: "Is my backend set up correctly?"
Skill: Runs comprehensive tests, reports status, suggests fixes

Integration Points

With Schema Architect

The skill can use schemas from schema-architect or create minimal schemas for quick starts.

With Frontend

After backend setup, guides frontend integration:

  1. Install BetterAuth adapter
  2. Configure auth client
  3. Test end-to-end flow

With Feature Builder

Provides working backend for feature-builder to add business logic.

With Test Generator

Generates E2E tests for all auth flows and endpoints.

Success Metrics

  • Setup time: < 5 minutes
  • Manual steps: 0
  • Auto-fix rate: > 95%
  • Test coverage: 100% of endpoints

Troubleshooting

If issues occur:

  1. Check logs: npm run start:dev
  2. Run auto-fix: "Fix auth issues"
  3. Verify database: psql -c "\dt"
  4. Test endpoints: bash references/verification-commands/test-auth-flow.sh
  5. Check references: references/troubleshooting/common-issues.md

Reference Documentation

  • SKILL.md - Complete skill documentation
  • setup-checklist.md - Step-by-step setup guide
  • better-auth-integration.md - BetterAuth deep dive
  • common-issues.md - Troubleshooting guide
  • apsorc-templates/ - Ready-to-use schemas

Quick Reference Commands

# Start backend
npm run start:dev

# Reset database
psql -U postgres -d backend_dev -c "DROP SCHEMA public CASCADE; CREATE SCHEMA public;"

# Fix DTOs
bash references/fix-scripts/fix-dto-id-fields.sh

# Test auth flow
bash references/verification-commands/test-auth-flow.sh

# View all tables
psql -U postgres -d backend_dev -c "\dt"

Next Steps After Setup

  1. Frontend Integration

    • Install BetterAuth adapter
    • Configure auth client
    • Add signup/signin forms

  2. Custom Endpoints

    • Add business logic to extensions/
    • Create custom controllers
    • Implement service methods

  3. Testing

    • Write unit tests
    • Add E2E tests
    • Verify coverage

  4. Deployment

    • Set up CI/CD
    • Configure production database
    • Deploy to AWS/Vercel

License

Part of Mavric SaaS Development Framework

Download Skill
backend-bootstrapper - AI Agent Skill for Claude Code & Cursor | Agent Skills