メニュー
Safe procedures for restarting Docker development services (PostgreSQL, ElectricSQL) after shutdown or reboot. Prevents accidental database data loss.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Build a LAT parse session from a customer's applicable laws. Applies all necessary filters (in-force, not-revoked, missing LAT, making classification) before creating the session to avoid wasting parse effort on laws that don't need processing.
Safe procedures for modifying the database schema. Covers the uk_lrt view + INSTEAD OF trigger pattern, column type changes on partitioned tables, and migration best practices.
Create a scrape session programmatically from data (CSV, list of law names, query results). Handles session + record creation with correct schema constraints so records appear in the admin UI.
Sync a customer's legal register, duties, and actor tuples to Baserow. Covers the three-table model, significance filters, sync config, and common issues.
Run `mix customer.pipeline_status` to report a customer's law corpus readiness — from applicability through LAT parsing, fractalaw enrichment, to Baserow-ready governed duties.
Generate a data quality report comparing a customer's legacy vendor register (Enhesa, Nimonik, etc.) against SertantAI's enriched legal database. Produces confusion matrix, revoked law analysis, coverage gaps, duty density, and family distribution. Outputs .md report + .csv appendices. Designed for customer senior management.
| name | Docker Dev Services Restart |
| description | Safe procedures for restarting Docker development services (PostgreSQL, ElectricSQL) after shutdown or reboot. Prevents accidental database data loss. |
Run these commands in order from the project root:
cd /home/jason/Desktop/sertantai-legal
docker compose -f docker-compose.dev.yml up -d postgres
sleep 5
docker compose -f docker-compose.dev.yml up -d --no-deps electric
Then start the app servers:
sert-legal-start
# Or with Docker (if not already started above):
sert-legal-start --docker
When Electric is misbehaving but postgres is fine:
docker restart sertantai-legal-electric
If docker restart fails with "permission denied":
# Reboot is the safest fix for stuck containers
sudo reboot
# After reboot, follow "After System Reboot" above
When docker-compose.dev.yml Electric config has changed (new env vars, etc.):
docker compose -f docker-compose.dev.yml up -d --no-deps electric
The --no-deps flag is critical -- without it, Docker may recreate the postgres container too, which can cause data loss.
# Check containers
docker ps --format "table {{.Names}}\t{{.Status}}" | grep legal
# Check ElectricSQL health
curl -s http://localhost:3002/v1/health
# Check shape API
curl -s "http://localhost:3002/v1/shape?table=uk_lrt&offset=-1" | head -c 200
# Check shape deletion is enabled
curl -s -X DELETE "http://localhost:3002/v1/shape?table=uk_lrt"
# Should return 202 (accepted), not 405 (not allowed)
| Command | Risk |
|---|---|
docker compose down -v | Destroys database volumes -- all 19k UK LRT records lost |
docker compose up -d electric (without --no-deps) | May recreate postgres container |
aa-remove-unknown | Removes AppArmor profiles for Firefox, VS Code, and all snap apps |
If database data is accidentally lost:
cd /home/jason/Desktop/sertantai-legal/backend
unset DATABASE_URL
mix ash_postgres.migrate
# Restore all tables from NAS snapshot (preferred)
cd /home/jason/Desktop/sertantai-legal
./scripts/nas/import-snapshot.sh
If the NAS is unavailable, see the legacy fallback in CLAUDE.md under "Legacy Data Import".