SchemaLens CircleCI Free

ALTER TABLE users
  ADD COLUMN email_verified_at TIMESTAMP;

# CircleCI project settings → Environment Variables GITHUB_TOKEN # optional — GitHub PAT with repo scope for PR comments SL_LICENSE_KEY # optional — SchemaLens Pro license key for full migration output # Job 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 job when no .sql files changed POST_PR_COMMENT "false" # true = post report as PR comment (needs token) FORMAT "markdown" # markdown | json | sql (sql needs Pro)

# .circleci/config.yml version: 2.1 executors: node-executor: docker: - image: cimg/node:20.0 jobs: schema-diff: executor: node-executor environment: SCHEMA_PATH: db/schema.sql DIALECT: postgres FAIL_ON_BREAKING: "true" SKIP_NO_SQL_CHANGE: "true" POST_PR_COMMENT: "true" steps: - checkout - run: name: Smart Skip command: | if [ "$SKIP_NO_SQL_CHANGE" = "true" ]; then CHANGED=$(git diff --name-only origin/${CIRCLE_BRANCH}..HEAD 2>/dev/null || echo "") if ! echo "$CHANGED" | grep -q '\.sql$'; then echo "No SQL changes — skipping." circleci-agent step halt fi fi - run: name: Fetch base schema command: | git fetch origin main 2>/dev/null || true git show "origin/main:$SCHEMA_PATH" > /tmp/schema_base.sql 2>/dev/null || echo "-- No base schema" > /tmp/schema_base.sql - run: name: Run SchemaLens diff command: | 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 -sL -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 > /tmp/schema_diff_report.md cat /tmp/schema_diff_report.md - run: name: Post PR comment command: | if [ "$POST_PR_COMMENT" = "true" ] && [ -n "${GITHUB_TOKEN:-}" ] && [ -n "${CIRCLE_PULL_REQUEST:-}" ]; then PR_NUM=$(echo "$CIRCLE_PULL_REQUEST" | sed 's/.*\///') REPORT=$(cat /tmp/schema_diff_report.md | sed 's/"/\\"/g' | sed ':a;N;$!ba;s/\n/\\n/g') curl -s -X POST -H "Authorization: token $GITHUB_TOKEN" -H "Accept: application/vnd.github.v3+json" \ "https://api.github.com/repos/${CIRCLE_PROJECT_USERNAME}/${CIRCLE_PROJECT_REPONAME}/issues/${PR_NUM}/comments" \ -d "{\"body\": \"## SchemaLens Report\\n\\n${REPORT}\"}" || true fi when: always - store_artifacts: path: /tmp/schema_diff_report.md destination: schema_diff_report.md workflows: schema-diff: jobs: - schema-diff: filters: branches: ignore: - main - master