Local setup

About 710 wordsAbout 2 min

The skeleton (spora-ai/spora) ships a working local dev environment. The only thing you need to install is PHP 8.4+, Composer, and Node 18+ (for the SPA’s Vite dev server).

Prerequisites

  • PHP 8.4+ with pdo_mysql, mbstring, zip, json extensions
  • Composer (latest 2.x)
  • Node.js 18+ and npm (only for the SPA’s Vite dev server with HMR; not needed for the built production frontend)

Install the skeleton

composer create-project spora-ai/spora my-spora
cd my-spora
composer install

composer install also installs spora-ai/spora-frontend (the prebuilt admin UI) and spora-ai/installer (the Composer plugin that routes spora-plugin and spora-frontend packages to the right directories).

Initialise the database

cp .env.example .env
# Edit .env: set SPORA_SECRET_KEY (32-byte base64), leave SPORA_DB_DRIVER=sqlite
php bin/spora spora:install    # creates schema (idempotent)
php bin/spora db:seed         # creates a sample admin user

spora:install is idempotent — re-run it after any new migration ships. db:seed is insert-only for admin and agent rows — it never patches an existing admin row, so it cannot resurrect a deleted admin or overwrite an operator-rename/demote. If you need to promote an existing admin row (e.g. it’s stuck at verified=0 after an upgrade), use php bin/spora db:repair-admin instead.

In addition, db:seed reconciles mail templates against email-templates/: any YAML that is missing from the DB is inserted, and operator-customised templates are preserved (no force). Run php bin/spora mail:templates:sync interactively (or php bin/spora mail:templates:sync --force) if you want to overwrite drifted rows.

To generate a secret key:

php -r "echo base64_encode(random_bytes(32));"

Start the dev server

composer dev

This starts two processes concurrently:

  • PHP — php -S 127.0.0.1:8080 -t public public/index.php
  • Vite — only if spora-frontend is path-installed (a sibling clone, not the Packagist release). The skeleton’s bin/dev auto-detects path installs.

The site is at http://localhost:8080. The SPA’s Vite HMR is at http://localhost:5173 (path install only).

For a production-like local server without Vite HMR, use the Docker single-container path or the Local — PHP / Ollama / LM Studio path.

Run tests

composer test                # Backend (Pest) — all tests
composer test:coverage     # With coverage
./vendor/bin/pest --filter="pattern"   # Filter tests by name

Frontend unit tests (if you’re working on the SPA):

cd frontend
npm test                     # All Vitest unit tests
npm run test:watch           # Watch mode

End-to-end (E2E) tests are not currently wired up — no Playwright dependency, no frontend/tests/e2e/ directory. The CI pipeline runs Pest + Vitest, not E2E.

The composer frontend:test script lives in spora-core (the framework), not the deployed spora skeleton. To run the framework’s full test suite, check out spora-ai/spora-core separately and run its composer scripts.

Database

  • SQLite at storage/database.sqlite (the default, zero-config)
  • Migrations — php bin/spora spora:install (idempotent; safe to re-run)
  • Seed — php bin/spora db:seed (inserts missing admin + sample agent; also reconciles mail templates against email-templates/, preserving operator-customised rows)
  • Reset — php bin/spora db:reset --force (wipes the SQLite file or drops + recreates the MySQL DB)

To use MySQL instead, edit .env:

SPORA_DB_DRIVER=mysql
SPORA_DB_HOST=127.0.0.1
SPORA_DB_PORT=3306
SPORA_DB_NAME=spora
SPORA_DB_USER=spora
SPORA_DB_PASSWORD=your-password

Then re-run php bin/spora spora:install to apply the migrations to the new DB.

Storage

storage/ directory contents:

  • database.sqlite — application database
  • spora.log — application logs (PSR-3, Monolog)
  • php.log — PHP error/fatal logs

storage/ is intentionally not copied into the Docker image (it would risk shipping the SQLite DB and secret.key). For backup strategy, see Backups.

Environment variables

Two are operationally important in dev:

  • SPORA_SYNC_MODE — true (default) = agent runs inline in the HTTP request; false = agent queued, drained by bin/spora worker:run --daemon.
  • APP_ENV — dev (default) or prod. Affects error reporting and cache behavior.

For the full env-var reference, see Environment variables.

What’s next