relationship-analyst

Calculate relationship affect ratios and coaching insights from coaching data using SQL queries.

6|1|Updated Mar 5, 2026

Search Tags:#analysis #data #sql #coaching #health #relationship #affect

Ready to run

npx skills add https://github.com/pwv-vc/agentcribs-community --skill relationship-analyst

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: relationship-analyst
Source: https://github.com/pwv-vc/agentcribs-community/tree/main/resources/tearsheets/arsenal/dot-claude/skills/relationship-analyst
Command: npx skills add https://github.com/pwv-vc/agentcribs-community --skill relationship-analyst

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Calculate relationship health metrics by deriving affect ratios from coaching data and delivering coaching insights to inform interventions.

Core Features & Use Cases

Compute affect ratios for individuals and couples from structured coaching data.
Analyze positive vs negative communication patterns over time and generate health assessments.
Support ad-hoc SQL exploration for exploratory questions relevant to relationship coaching datasets.

Quick Start

Specify a person_id to immediately calculate that person's affect ratio and health status.

Frequently Asked Questions about relationship-analyst

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

FAQPage Schema

How do I calculate relationship affect ratios from coaching data?▼

Calculate relationship affect ratios by querying structured coaching data with SQL to derive positive versus negative communication patterns, generating health assessments for individuals or couples. Specify a person_id to compute their specific affect ratio and health status.

What is a relationship affect ratio and how does it indicate health?▼

A relationship affect ratio measures positive versus negative communication patterns over time. Derived from coaching data, it serves as a quantifiable relationship health metric to inform interventions and deliver coaching insights.

Can I run ad-hoc SQL queries to explore relationship coaching datasets?▼

Yes, you can run ad-hoc SQL queries to explore relationship coaching datasets. The tool supports flexible SQL exploration for answering exploratory questions relevant to relationship coaching data, individual analysis, and couple analysis.

Do I need a schema reader to analyze relationship health metrics?▼

Yes, you need to bootstrap via a sql-reader to understand the schema before analyzing relationship health metrics. This prerequisite ensures the SQL exploration accurately enforces data quirks described in the documentation.

Are there HIPAA considerations when analyzing relationship coaching data?▼

Yes, analyzing relationship coaching data enforces HIPAA considerations and emphasizes data-quirk awareness. These constraints ensure health metrics and affect ratios are computed securely without exposing sensitive protected health information.