SchemaLens Jenkins Free

ALTER TABLE users
  ADD COLUMN email_verified_at TIMESTAMP;

// Jenkins environment variables (Manage Jenkins → Credentials, or pipeline environment block) SL_LICENSE_KEY // optional — SchemaLens Pro license key for full migration output GITHUB_TOKEN // optional — GitHub PAT with repo scope for PR comments GITLAB_TOKEN // optional — GitLab token with api scope for MR comments // Pipeline environment variables SCHEMA_PATH 'db/schema.sql' // Path to current schema SQL file DIALECT 'postgres' // postgres | mysql | sqlite | mssql | oracle FAIL_ON_BREAKING 'false' // true = fail build on breaking changes SKIP_NO_SQL_CHANGE 'false' // true = skip stage when no .sql files changed POST_BUILD_COMMENT 'false' // true = post to PR/MR (needs SCM token) FORMAT 'markdown' // markdown | json | sql (sql needs Pro)

// Jenkinsfile pipeline { agent any environment { SCHEMA_PATH = 'db/schema.sql' DIALECT = 'postgres' FAIL_ON_BREAKING = 'true' SKIP_NO_SQL_CHANGE = 'true' POST_BUILD_COMMENT = 'true' } stages { stage('Schema Diff') { steps { script { // Smart skip if (env.SKIP_NO_SQL_CHANGE == 'true') { def target = env.CHANGE_TARGET ?: 'main' def changed = sh( script: 'git diff --name-only origin/' + target + '..HEAD || true', returnStdout: true ).trim() if (!changed.contains('.sql')) { echo '[SchemaLens] No SQL changes — skipping.' currentBuild.description = 'Skipped — no SQL changes' return } } // Ensure tools sh 'which jq >/dev/null 2>&1 || (apt-get update -qq && apt-get install -y -qq jq curl) || true' // Fetch base schema sh '''git fetch origin "${CHANGE_TARGET:-main}" && git show "origin/${CHANGE_TARGET:-main}:$SCHEMA_PATH" > /tmp/schema_base.sql 2>/dev/null || echo "-- No base schema" > /tmp/schema_base.sql''' // Call SchemaLens API sh '''set -euo pipefail ENDPOINT="https://schemalens.tech/api/free-diff" [ -n "${SL_LICENSE_KEY:-}" ] && ENDPOINT="https://schemalens.tech/api/diff" BODY=$(jq -n --arg a "$(cat /tmp/schema_base.sql)" --arg b "$(cat "$SCHEMA_PATH")" --arg d "$DIALECT" --arg f "$FORMAT" '{schemaA:$a,schemaB:$b,dialect:$d,format:$f}') curl -s -X POST "$ENDPOINT" -H "Content-Type: application/json" ${SL_LICENSE_KEY:+-H "X-License-Key: $SL_LICENSE_KEY"} -d "$BODY" > /tmp/response.json jq -r '.markdown // .migrationTeaser' /tmp/response.json > schema_diff_report.md ''' // Show report sh 'cat schema_diff_report.md' // Update build description def score = sh(script: 'jq -r ".riskScore.score // 0" /tmp/response.json', returnStdout: true).trim() def label = sh(script: 'jq -r ".riskScore.label // \"Unknown\"" /tmp/response.json', returnStdout: true).trim() def bc = sh(script: 'jq -r "(.summary.breakingChangeCount // (.breakingChanges | length) // 0)" /tmp/response.json', returnStdout: true).trim() currentBuild.description = "Risk: ${label} (${score}/100) | ${bc} breaking" // Fail on breaking if (env.FAIL_ON_BREAKING == 'true' && bc != '0') { error("[SchemaLens] ${bc} breaking change(s) detected.") } } } } } post { always { archiveArtifacts artifacts: 'schema_diff_report.md', allowEmptyArchive: true } } }