Everything You Need for Schema Management

{
  "type": "object",
  "title": "User",
  "description": "User account schema",
  "required": ["email", "username"],
  "properties": {
    "id": {
      "type": "string",
      "format": "uuid",
      "description": "Unique identifier"
    },
    "email": {
      "type": "string",
      "format": "email",
      "description": "User email address"
    },
    "username": {
      "type": "string",
      "minLength": 3,
      "maxLength": 20,
      "pattern": "^[a-zA-Z0-9_]+$"
    },
    "age": {
      "type": "integer",
      "minimum": 18,
      "maximum": 120
    },
    "roles": {
      "type": "array",
      "items": {
        "type": "string",
        "enum": ["user", "admin", "moderator"]
      },
      "minItems": 1,
      "uniqueItems": true
    }
  }
}

-- Migration: 20260118_create_users_table
CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  email VARCHAR(255) NOT NULL UNIQUE,
  username VARCHAR(20) NOT NULL,
  age INTEGER CHECK (age >= 18 AND age <= 120),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX idx_users_email ON users(email);
CREATE INDEX idx_users_username ON users(username);

-- Trigger for updated_at
CREATE TRIGGER update_users_updated_at
  BEFORE UPDATE ON users
  FOR EACH ROW
  EXECUTE FUNCTION update_updated_at_column();

Automatic Generation

Every migration script automatically generates a corresponding rollback script, ensuring you can safely revert changes if needed.

Data Preservation

Rollback plans are designed to preserve data integrity. Critical data is backed up before destructive operations.

Version Control

Track all schema changes with version control integration. See exactly what changed and when, with full audit trails.

// Generated sample data
[
  {
    "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
    "email": "sarah.johnson@example.com",
    "username": "sarah_j",
    "age": 28,
    "roles": ["user"],
    "created_at": "2026-01-15T10:30:00Z"
  },
  {
    "id": "b2c3d4e5-f6a7-8901-bcde-f12345678901",
    "email": "mike.chen@example.com",
    "username": "mike_chen",
    "age": 34,
    "roles": ["user", "moderator"],
    "created_at": "2026-01-16T14:22:00Z"
  },
  {
    "id": "c3d4e5f6-a7b8-9012-cdef-123456789012",
    "email": "admin@example.com",
    "username": "admin",
    "age": 42,
    "roles": ["user", "admin"],
    "created_at": "2026-01-10T08:00:00Z"
  }
]

GitHub Actions

name: Schema Validation
on: [pull_request]

jobs:
  validate:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v3
      - name: Validate Schemas
        uses: schemagen/validate-action@v1
        with:
          api-key: ${{ secrets.SCHEMAGEN_KEY }}
          schemas: ./schemas/**/*.json
          check-breaking-changes: true

GitLab CI

schema_validation:
  stage: test
  image: schemagen/cli:latest
  script:
    - schemagen validate ./schemas
    - schemagen diff main HEAD
  only:
    - merge_requests
  variables:
    SCHEMAGEN_API_KEY: $API_KEY

Shared Workspaces

Create team workspaces where everyone can access, edit, and collaborate on schemas in real-time.

Role-Based Access

Control who can view, edit, or approve schemas with granular permission settings.

Change History

Track every change with a complete audit trail. See who made changes, when, and why.

Comments & Reviews

Add comments to schemas, request reviews, and approve changes before deployment.

Schema Registry

Central repository for all your schemas. Search, browse, and discover existing schemas across projects.

API Integration

Full REST API for programmatic access. Integrate SchemaGen into your existing tools and workflows.