AgentSkillsCN

rye-installer

安装、迁移、验证并测试Rye PostgreSQL部署。当用户请求在数据库中完成Rye的初始化、应用核心/配置迁移、运行模式验证、填充示例数据，或执行一致性检查时使用。

SKILL.md
--- frontmatter
name: rye-installer
description: Install, migrate, verify, and test Rye PostgreSQL deployments. Use when a user asks to bootstrap Rye in a database, apply core/profile migrations, run schema verification, seed sample data, or execute conformance checks.

Rye Installer

Workflow

  1. •Validate target database connection (DATABASE_URL) and target profiles (crm, pm, or none).
  2. •Run ./scripts/install.sh --profiles ... to apply migrations in order.
  3. •Optionally run ./scripts/install.sh --seed for quickstart data.
  4. •Run ./scripts/verify.sh to validate required objects and policies.
  5. •Run ./scripts/conformance.sh for gate checks.

Commands

  • •Core only: ./scripts/install.sh --profiles ''
  • •Core + CRM: ./scripts/install.sh --profiles crm
  • •Core + PM: ./scripts/install.sh --profiles pm
  • •Core + CRM + PM: ./scripts/install.sh --profiles crm,pm
  • •Full checks: ./scripts/conformance.sh

Post-Install

After install, run SELECT rye_catalog() to confirm the instance is ready and see what's connected.

Notes

  • •Target PostgreSQL 15+.
  • •Rye installs alongside existing tables. It does not modify them.
  • •Use link_record() to connect existing domain table rows to the graph.
  • •Use track_table() to attach CDC triggers for change tracking.
  • •Assertion updates are function-only; verify this via ./scripts/verify.sh and security tests.
  • •Do not edit migration order in schema/migrations without versioning and tests.
  • •If migrations fail partway, fix the root cause and re-run ./scripts/migrate.sh.