Seedmancer CLI Documentation

seedmancer login
# or
export SEEDMANCER_API_TOKEN="sk_..."

storage_path: .seedmancer
default_env: local
database_url: postgres://user:pass@localhost:5432/mydb

# Named databases for seedmancer seed --env local,staging
environments:
  local:
    database_url: postgres://user:pass@localhost:5432/mydb

.seedmancer/
  schemas/
    a1b2c3d4e5f6/
      schema.json
      meta.yaml
      *_func.sql
      *_trigger.sql
      datasets/
        baseline/
          users.csv
          orders.csv
        20260420153022/
          users.csv
          ...

seedmancer mcp

# Optional: HTTP transport or log file — see seedmancer mcp --help
seedmancer mcp --transport http --addr :7801
seedmancer mcp --log-file /tmp/seedmancer-mcp.log

{
  "mcpServers": {
    "seedmancer": {
      "command": "seedmancer",
      "args": ["mcp", "--log-file", "/tmp/seedmancer-mcp.log"],
      "env": {
        "SEEDMANCER_API_TOKEN": "<optional; falls back to ~/.seedmancer/credentials>"
      }
    }
  }
}

export SEEDMANCER_DATABASE_URL="postgres://user:pass@localhost:5432/mydb"
export SEEDMANCER_API_TOKEN="your-api-token"

seedmancer export --id v1
seedmancer push   --dataset-id v1
seedmancer pull  --dataset-id v1
seedmancer seed   --dataset-id v1 --yes
seedmancer list

// playwright.config.ts
import { defineConfig } from "@playwright/test"
import * as path from "node:path"

export default defineConfig({
  globalSetup: path.resolve(__dirname, "tests/global-setup.ts"),
})

// tests/global-setup.ts
import { spawnSync } from "node:child_process"
import * as path from "node:path"

export default async function globalSetup() {
  const result = spawnSync(
    "seedmancer",
    ["seed", "--id", "api-test", "--yes"],
    { cwd: path.resolve(__dirname, ".."), stdio: "inherit" }
  )
  if (result.status !== 0) {
    throw new Error(`seedmancer seed exited with status ${result.status}`)
  }
}

// tests/api/users.spec.ts
import { test, expect } from "@playwright/test"

test("GET /api/users returns seeded rows", async ({ request }) => {
  const res = await request.get("/api/users")
  expect(res.ok()).toBeTruthy()
  const users = await res.json()
  expect(users.length).toBeGreaterThan(0)
})

test("POST /api/users creates a user", async ({ request }) => {
  const res = await request.post("/api/users", {
    data: { email: "new@example.com", name: "New User" },
  })
  expect(res.status()).toBe(201)
})

// tests/browser/login.spec.ts
import { test, expect } from "@playwright/test"

test("login with seeded user", async ({ page }) => {
  await page.goto("/login")
  await page.fill('[name="email"]', "test@example.com")
  await page.fill('[name="password"]', "SeedmancerTest1!")
  await page.click('[type="submit"]')
  await expect(page).toHaveURL("/dashboard")
})

{
  "scripts": {
    "test": "playwright test",
    "test:no-reset": "SEEDMANCER_RESET_DATABASE=0 playwright test"
  }
}

// cypress.config.ts
import { defineConfig } from "cypress"
import { execSync } from "node:child_process"

export default defineConfig({
  e2e: {
    setupNodeEvents(on) {
      on("task", {
        resetDb(datasetId = "api-test") {
          execSync(`seedmancer seed --id ${datasetId} --yes`, {
            stdio: "inherit",
          })
          return null
        },
      })
    },
  },
})

// cypress/support/e2e.ts
before(() => {
  cy.task("resetDb")
})

// Or before each spec file:
// beforeEach(() => { cy.task("resetDb") })

// cypress/e2e/api/users.cy.ts
describe("Users API", () => {
  it("returns seeded users", () => {
    cy.request("/api/users").then((res) => {
      expect(res.status).to.eq(200)
      expect(res.body.length).to.be.greaterThan(0)
    })
  })

  it("creates a user", () => {
    cy.request("POST", "/api/users", {
      email: "new@example.com",
      name: "New User",
    }).then((res) => {
      expect(res.status).to.eq(201)
    })
  })
})

// cypress/e2e/browser/login.cy.ts
describe("Login", () => {
  it("logs in with a seeded user", () => {
    cy.visit("/login")
    cy.get('[name="email"]').type("test@example.com")
    cy.get('[name="password"]').type("SeedmancerTest1!")
    cy.get('[type="submit"]').click()
    cy.url().should("include", "/dashboard")
  })
})

# .github/workflows/test.yml
name: Test

on: [push, pull_request]

jobs:
  test:
    runs-on: ubuntu-latest

    services:
      postgres:
        image: postgres:16
        env:
          POSTGRES_PASSWORD: postgres
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

    steps:
      - uses: actions/checkout@v4

      - name: Install Seedmancer
        run: |
          curl -L https://github.com/KazanKK/seedmancer/releases/latest/download/seedmancer_Linux_x86_64 -o seedmancer
          chmod +x seedmancer && sudo mv seedmancer /usr/local/bin/seedmancer

      - name: Pull and seed database
        env:
          SEEDMANCER_API_TOKEN: ${{ secrets.SEEDMANCER_API_TOKEN }}
          SEEDMANCER_DATABASE_URL: postgres://postgres:postgres@localhost:5432/postgres
        run: |
          seedmancer pull --id api-test
          seedmancer seed --id api-test --yes

      - name: Run tests
        run: npm test

# .gitlab-ci.yml
test:
  image: node:20
  services:
    - postgres:16
  variables:
    POSTGRES_PASSWORD: postgres
    SEEDMANCER_DATABASE_URL: postgres://postgres:postgres@postgres:5432/postgres
  before_script:
    - curl -L https://github.com/KazanKK/seedmancer/releases/latest/download/seedmancer_Linux_x86_64 -o /usr/local/bin/seedmancer
    - chmod +x /usr/local/bin/seedmancer
    - seedmancer pull --id api-test
    - seedmancer seed --id api-test --yes
  script:
    - npm test

# docker-compose.test.yml
services:
  db:
    image: postgres:16
    environment:
      POSTGRES_PASSWORD: postgres
    ports:
      - "5432:5432"
    healthcheck:
      test: ["CMD", "pg_isready", "-U", "postgres"]
      interval: 5s
      retries: 5

  seed:
    image: alpine
    depends_on:
      db:
        condition: service_healthy
    volumes:
      - /usr/local/bin/seedmancer:/usr/local/bin/seedmancer
    command: sh -c "seedmancer pull --id api-test && seedmancer seed --id api-test --yes"
    environment:
      SEEDMANCER_API_TOKEN: ${SEEDMANCER_API_TOKEN}
      SEEDMANCER_DATABASE_URL: postgres://postgres:postgres@db:5432/postgres