메뉴
Switch between local and production database environments by updating .env.local, killing running processes, and providing restart instructions. Use when user says "switch to local database", "switch to production database", or "change database environment".
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Unified database migration skill. Use when user says "test migration", "push migration", "deploy migration", "reset local database", or "db push". Promotion pipeline local → staging → production with approval gates at each stage.
Kill all running local development processes (worker, edge functions, dev server), wait for termination, then restart them. Dev server runs on port 8080. Use when user says "boot local", "restart local", "reboot dev", or needs to refresh local services.
Evaluate existing test coverage, identify gaps and pattern violations, then create or update comprehensive tests. Use when user says "build tests", "update tests", "test [component]", "add test coverage", or "check test coverage".
Reviews code quality, pattern adherence, and architecture with red-team validation. Use when user says "check your code", "code quality review", "is this well-written", or "review code quality". Different from check-your-work which finds bugs.
Validates AI implementation plans before execution. Use when user says "check your plan", "validate this plan", "review the plan", or "is this plan good". Launches 5 parallel validators + devil's advocate.
Orchestrates 6 quality agents in parallel (duplicate-detector, jenny, deep-bug-hunter, security, performance, correctness) with severity validation. Use when user says "check your work", "review what we wrote", "quality check", or after writing new features.
| name | db-env-switch |
| description | Switch between local and production database environments by updating .env.local, killing running processes, and providing restart instructions. Use when user says "switch to local database", "switch to production database", or "change database environment". |
| allowed-tools | Read, Write, Bash, AskUserQuestion |
| version | 2.1.0 |
Safely switch between local and production database configurations with process restart.
<when_to_use>
Invoke when user says:
| Phase | Action | Reference |
|---|---|---|
| 1 | Detect current environment | Read .env.local |
| 2 | Safety check (production requires approval) | AskUserQuestion |
| 3 | Update .env.local | Comment/uncomment sections |
| 4 | Kill running processes | Vite + Worker PIDs |
| 5 | Verify + provide restart instructions | Summary report |
For detailed steps: references/workflow-phases.md
<safety_rules>
npx supabase status before switching TO local| Environment | URL | Safe to Experiment |
|---|---|---|
| LOCAL | http://127.0.0.1:54321 | Yes |
| PRODUCTION | https://<production-project-id>.supabase.co | NO - Real user data! |
<approval_gates>
| Gate | Phase | Question |
|---|---|---|
| Production Confirm | Switching TO production | "Switch to PRODUCTION? All queries affect REAL USER DATA." |
| Local Supabase | Switching TO local (not running) | "Start local Supabase now?" |
</approval_gates>
<quick_reference>
# Check current environment
grep "^VITE_SUPABASE_URL" .env.local
# Find processes (Windows)
wmic process where "commandline like '%vite%'" get processid 2>nul
# Kill by PID
taskkill //F //PID [pid]
# Restart services after switch
npm run dev
npm run worker:dev
For detailed commands: references/commands-reference.md For error recovery: references/error-recovery.md For safety reminders: references/safety-reminders.md </quick_reference>
## References<version_history>
v2.1.0 (2025-01-18): AI optimization updates
v2.0.0 (2025-12-28): Refactored to follow skill-authoring-patterns
v1.0.0 (2025-11-03): Initial release </version_history>