hmmhmmhm · hmmhmmhm · Jul 15, 2026 · Jul 13, 2026 · Jul 13, 2026 · Jul 13, 2026
diff --git a/.github/dependabot.yml b/.github/dependabot.yml
@@ -0,0 +1,36 @@
+version: 2
+updates:
+  - package-ecosystem: "npm"
+    directory: "/"
+    schedule:
+      interval: "weekly"
+      day: "monday"
+      timezone: "Asia/Seoul"
+    open-pull-requests-limit: 10
+    groups:
+      runtime-security:
+        patterns:
+          - "*"
+        dependency-type: "production"
+        update-types:
+          - "minor"
+          - "patch"
+      development-tooling:
+        patterns:
+          - "*"
+        dependency-type: "development"
+        update-types:
+          - "minor"
+          - "patch"
+
+  - package-ecosystem: "github-actions"
+    directory: "/"
+    schedule:
+      interval: "weekly"
+      day: "monday"
+      timezone: "Asia/Seoul"
+    open-pull-requests-limit: 10
+    groups:
+      github-actions:
+        patterns:
+          - "*"
diff --git a/.github/workflows/ci.yml b/.github/workflows/ci.yml
@@ -12,27 +12,35 @@ jobs:
 
     steps:
       - name: Checkout repository
-        uses: actions/checkout@v6
+        uses: actions/checkout@df4cb1c069e1874edd31b4311f1884172cec0e10 # v6
 
       - name: Setup Node.js
-        uses: actions/setup-node@v6
+        uses: actions/setup-node@48b55a011bda9f5d6aeb4c2d9c7362e8dae4041e # v6
         with:
           node-version: "22"
           package-manager-cache: false
 
       - name: Setup pnpm
-        uses: pnpm/action-setup@v6
+        uses: pnpm/action-setup@0ebf47130e4866e96fce0953f49152a61190b271 # v6
         with:
-          version: 9.0.0
+          version: 11.4.0
 
       - name: Setup Bun
-        uses: oven-sh/setup-bun@v2
+        uses: oven-sh/setup-bun@0c5077e51419868618aeaa5fe8019c62421857d6 # v2
         with:
-          bun-version: latest
+          bun-version: "1.3.1"
 
       - name: Install dependencies
         run: pnpm install --frozen-lockfile
 
+      - name: Audit production dependencies
+        run: pnpm security:audit
+
+      - name: Materialize verified region data
+        env:
+          REGION_DATA_BASE_URL: ${{ vars.REGION_DATA_BASE_URL }}
+        run: node scripts/sync-region-data.mjs --groups region-dist,region-db --prune
+
       - name: Check formatting
         run: pnpm format:check
 
@@ -69,6 +77,9 @@ jobs:
       - name: Test web client
         run: pnpm --filter web test
 
+      - name: Enforce coverage policy
+        run: pnpm coverage
+
       - name: Build
         run: pnpm build
 

diff --git a/.github/workflows/deploy-api.yml b/.github/workflows/deploy-api.yml
@@ -8,6 +8,7 @@ on:
       - "apps/api-ground-codes/**"
       - "packages/ground-codes/**"
       - "packages/geoint/region-dist/**"
+      - "packages/geoint/region-data-release.json"
       - "packages/codebook/codebook-dist/**"
       - ".github/workflows/deploy-api.yml"
       - "package.json"
@@ -28,32 +29,38 @@ concurrency:
 jobs:
   deploy:
     runs-on: ubuntu-latest
+    environment: production
 
     steps:
       - name: Checkout repository
-        uses: actions/checkout@v6
+        uses: actions/checkout@df4cb1c069e1874edd31b4311f1884172cec0e10 # v6
         with:
           fetch-depth: 0
 
       - name: Setup Node.js
-        uses: actions/setup-node@v6
+        uses: actions/setup-node@48b55a011bda9f5d6aeb4c2d9c7362e8dae4041e # v6
         with:
           node-version: "22"
           package-manager-cache: false
 
       - name: Setup pnpm
-        uses: pnpm/action-setup@v6
+        uses: pnpm/action-setup@0ebf47130e4866e96fce0953f49152a61190b271 # v6
         with:
-          version: 9.0.0
+          version: 11.4.0
 
       - name: Setup Bun
-        uses: oven-sh/setup-bun@v2
+        uses: oven-sh/setup-bun@0c5077e51419868618aeaa5fe8019c62421857d6 # v2
         with:
-          bun-version: latest
+          bun-version: "1.3.1"
 
       - name: Install dependencies
         run: pnpm install --frozen-lockfile
 
+      - name: Materialize verified region data
+        env:
+          REGION_DATA_BASE_URL: ${{ vars.REGION_DATA_BASE_URL }}
+        run: node scripts/sync-region-data.mjs --groups region-dist --prune
+
       - name: Type check API
         run: pnpm --filter api-ground-codes check-types
 
@@ -63,9 +70,6 @@ jobs:
       - name: Build ground-codes package
         run: pnpm --filter ground-codes build
 
-      - name: Install Wrangler
-        run: pnpm install -g wrangler
-
       - name: Apply PostGIS schema
         env:
           SUPABASE_DB_URL: ${{ secrets.SUPABASE_DB_URL }}
@@ -75,6 +79,8 @@ jobs:
 
       - name: Detect changed region datasets
         id: regions
+        env:
+          REGION_DATA_BASE_URL: ${{ vars.REGION_DATA_BASE_URL }}
         run: |
           if [ "${{ github.event_name }}" = "workflow_dispatch" ] && [ "${{ inputs.import_all_regions }}" = "true" ]; then
             echo "datasets=__all_missing__" >> "$GITHUB_OUTPUT"
@@ -104,7 +110,7 @@ jobs:
           CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}
           CLOUDFLARE_ACCOUNT_ID: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
         run: |
-          wrangler deploy \
+          pnpm exec wrangler deploy \
             --config apps/api-ground-codes/wrangler.toml \
             --keep-vars \
             --var API_RUNTIME_TAG:workspace \
@@ -113,4 +119,6 @@ jobs:
             --message "Deploy API Worker from ${GITHUB_SHA}"
 
       - name: Run production smoke
+        env:
+          GROUND_CODES_EXPECTED_RUNTIME_COMMIT: ${{ github.sha }}
         run: pnpm production:smoke
diff --git a/.github/workflows/deploy-grok-spiral.yml b/.github/workflows/deploy-grok-spiral.yml
@@ -13,24 +13,29 @@ on:
       - "pnpm-workspace.yaml"
   workflow_dispatch:
 
+concurrency:
+  group: deploy-grok-spiral-production
+  cancel-in-progress: true
+
 jobs:
   deploy:
     runs-on: ubuntu-latest
+    environment: production
 
     steps:
       - name: Checkout repository
-        uses: actions/checkout@v6
+        uses: actions/checkout@df4cb1c069e1874edd31b4311f1884172cec0e10 # v6
 
       - name: Setup Node.js
-        uses: actions/setup-node@v6
+        uses: actions/setup-node@48b55a011bda9f5d6aeb4c2d9c7362e8dae4041e # v6
         with:
           node-version: "22"
           package-manager-cache: false
 
       - name: Setup pnpm
-        uses: pnpm/action-setup@v6
+        uses: pnpm/action-setup@0ebf47130e4866e96fce0953f49152a61190b271 # v6
         with:
-          version: 9.0.0
+          version: 11.4.0
 
       - name: Get pnpm store directory
         id: pnpm-cache
@@ -39,26 +44,21 @@ jobs:
           echo "STORE_PATH=$(pnpm store path)" >> $GITHUB_OUTPUT
 
       - name: Setup pnpm cache
-        uses: actions/cache@v5
+        uses: actions/cache@caa296126883cff596d87d8935842f9db880ef25 # v5
         with:
           path: ${{ steps.pnpm-cache.outputs.STORE_PATH }}
           key: ${{ runner.os }}-pnpm-store-${{ hashFiles('**/pnpm-lock.yaml') }}
           restore-keys: |
             ${{ runner.os }}-pnpm-store-
 
       - name: Install dependencies
-        run: pnpm install
+        run: pnpm install --frozen-lockfile
 
       - name: Build Next.js app
         run: pnpm --filter grok-spiral build
 
-      - name: Install Wrangler
-        run: pnpm install -g wrangler
-
       - name: Deploy to Cloudflare Pages
         env:
           CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}
           CLOUDFLARE_ACCOUNT_ID: ${{ secrets.CLOUDFLARE_ACCOUNT_ID }}
-        run: |
-          cd apps/grok-spiral
-          pnpm run pages:build && wrangler pages deploy
+        run: pnpm --filter grok-spiral deploy
diff --git a/.github/workflows/deploy-web.yml b/.github/workflows/deploy-web.yml
@@ -13,24 +13,29 @@ on:
       - "pnpm-workspace.yaml"
   workflow_dispatch:
 
+concurrency:
+  group: deploy-web-production
+  cancel-in-progress: true
+
 jobs:
   deploy:
     runs-on: ubuntu-latest
+    environment: production
 
     steps:
       - name: Checkout repository
-        uses: actions/checkout@v6
+        uses: actions/checkout@df4cb1c069e1874edd31b4311f1884172cec0e10 # v6
 
       - name: Setup Node.js
-        uses: actions/setup-node@v6
+        uses: actions/setup-node@48b55a011bda9f5d6aeb4c2d9c7362e8dae4041e # v6
         with:
           node-version: "22"
           package-manager-cache: false
 
       - name: Setup pnpm
-        uses: pnpm/action-setup@v6
+        uses: pnpm/action-setup@0ebf47130e4866e96fce0953f49152a61190b271 # v6
         with:
-          version: 9.0.0
+          version: 11.4.0
 
       - name: Get pnpm store directory
         id: pnpm-cache
@@ -39,22 +44,19 @@ jobs:
           echo "STORE_PATH=$(pnpm store path)" >> $GITHUB_OUTPUT
 
       - name: Setup pnpm cache
-        uses: actions/cache@v5
+        uses: actions/cache@caa296126883cff596d87d8935842f9db880ef25 # v5
         with:
           path: ${{ steps.pnpm-cache.outputs.STORE_PATH }}
           key: ${{ runner.os }}-pnpm-store-${{ hashFiles('**/pnpm-lock.yaml') }}
           restore-keys: |
             ${{ runner.os }}-pnpm-store-
 
       - name: Install dependencies
-        run: pnpm install
+        run: pnpm install --frozen-lockfile
 
       - name: Build Next.js app
         run: pnpm --filter web build
 
-      - name: Install Wrangler
-        run: pnpm install -g wrangler
-
       - name: Deploy to Cloudflare Pages
         env:
           CLOUDFLARE_API_TOKEN: ${{ secrets.CLOUDFLARE_API_TOKEN }}
@@ -67,6 +69,4 @@ jobs:
           NEXT_PUBLIC_CESIUM_MARS_ASSET_ID: ${{ secrets.NEXT_PUBLIC_CESIUM_MARS_ASSET_ID }}
           GOOGLE_MAPS_NODEJS_API_KEY: ${{ secrets.GOOGLE_MAPS_NODEJS_API_KEY }}
           OPENWEATHER_API_KEY: ${{ secrets.OPENWEATHER_API_KEY }}
-        run: |
-          cd apps/web
-          pnpm run pages:build && wrangler pages deploy
+        run: pnpm --filter web deploy