rye-agent-ops

Enables LLM agents to safely read/write PostgreSQL data via official Rye SQL helpers with RLS and provenance tracking.

2|Updated Feb 20, 2026
One-click install
npx skills add https://github.com/BLTGV/project-rye --skill rye-agent-ops
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rye-agent-ops
Source: https://github.com/BLTGV/project-rye/tree/main/skills/rye-agent-ops
Command: npx skills add https://github.com/BLTGV/project-rye --skill rye-agent-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

LLM agents interacting with Rye-managed PostgreSQL data often violate row-level security policies, assertion lifecycle rules, and audit requirements, leading to data leaks, corrupted knowledge states, and non-compliant operations.

Core Features & Use Cases

  • Safe Read/Write Guidance: Directs agents to use official Rye SQL helper functions instead of raw queries, enforcing RLS, team boundaries, and immutable assertion rules.
  • Auditable Workflows: Covers event logging, provenance tracking, and knowledge candidate promotion flows to ensure all agent actions are traceable and compliant.
  • Domain Integration: Helps agents connect external domain tables to the Rye graph and track table changes via CDC triggers. For example, a sales agent can safely ingest CRM data into Rye, create validated knowledge candidates, and schedule future deal stage changes without bypassing access controls.

Quick Start

Use the rye-agent-ops skill to set up your Rye session context, retrieve scoped node information, and safely record a new event with participant details for your workflow.

Frequently Asked Questions about rye-agent-ops

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I prevent LLM agents from violating row-level security when writing to PostgreSQL?

Prevent LLM agents from violating PostgreSQL row-level security by directing them to use official Rye SQL helper functions instead of raw queries. This enforces RLS-compliant session setup, team boundaries, and immutable assertion rules.

What is assertion lifecycle management for AI agent database workflows?

Assertion lifecycle management for AI agent database workflows ensures agents safely read and write data without corrupting knowledge states. It enforces provenance tracking, separates planned work from future-effective truth, and validates knowledge candidates.

How to set up a Rye session context for safe agent data retrieval?

Set up a Rye session context for safe agent data retrieval by configuring RLS-compliant sessions and using official Rye SQL helper functions. This allows agents to retrieve scoped node information while maintaining audit requirements and team boundaries.

Can I use LLM agents to ingest external CRM data into Rye-managed PostgreSQL?

Yes, you can use LLM agents to ingest external CRM data into Rye-managed PostgreSQL. The workflow helps agents connect external domain tables to the Rye graph, create validated knowledge candidates, and track table changes via CDC triggers without bypassing access controls.

Does writing agent workflows with Rye SQL helpers support future state scheduling?

Yes, writing agent workflows with Rye SQL helpers supports future state scheduling. It enforces the separation of planned work from future-effective truth, allowing agents to safely schedule future deal stage changes while maintaining provenance tracking.

Why do raw SQL queries cause data leaks in LLM agent PostgreSQL operations?

Raw SQL queries cause data leaks in LLM agent PostgreSQL operations because they bypass row-level security policies, assertion lifecycle rules, and audit requirements. Using official Rye SQL helper functions ensures all agent actions are traceable and compliant.