← All skills
Tencent SkillHub · Data Analysis

People Strategy

Manage and query a persistent SQLite-based graph of people and their relationships for personal CRM, org charts, mentorship, and collaboration mapping.

skill openclawclawhub Free
0 Downloads
0 Stars
0 Installs
0 Score
High Signal

Manage and query a persistent SQLite-based graph of people and their relationships for personal CRM, org charts, mentorship, and collaboration mapping.

⬇ 0 downloads ★ 0 stars Unverified but indexed

Install for OpenClaw

Quick setup
  1. Download the package from Yavira.
  2. Extract the archive and review SKILL.md first.
  3. Import or place the package into your OpenClaw setup.

Requirements

Target platform
OpenClaw
Install method
Manual import
Extraction
Extract archive
Prerequisites
OpenClaw
Primary doc
SKILL.md

Package facts

Download mode
Yavira redirect
Package format
ZIP package
Source platform
Tencent SkillHub
What's included
people_skill.py, requirements.txt, database.py, README.md, SKILL.md

Validation

  • Use the Yavira download entry.
  • Review SKILL.md after the package is downloaded.
  • Confirm the extracted package contains the expected setup assets.

Install with your agent

Agent handoff

Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.

  1. Download the package from Yavira.
  2. Extract it into a folder your agent can access.
  3. Paste one of the prompts below and point your agent at the extracted folder.
New install

I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete.

Upgrade existing

I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run.

Trust & source

Release facts

Source
Tencent SkillHub
Verification
Indexed source record
Version
1.0.0

Documentation

ClawHub primary doc Primary doc: SKILL.md 28 sections Open source page

Overview

A people relationship management agent skill that provides persistent graph-based storage using SQLite database. This skill enables AI agents to create, manage, and query a network of people and their relationships, making it ideal for building personal CRMs, organizational charts, mentorship networks, and collaboration mapping.

Person Management

Create People: Add new people with comprehensive information (name, role, relation, organization, character, notes) Read People: Retrieve individual people or search/filter across the database Update People: Modify any person's information Delete People: Remove people from the database (cascades to relationships) Search: Full-text search across names, roles, and organizations Filter: Filter by organization or relation type

Relationship Management

Create Edges: Establish directed relationships between people Query Relationships: Get incoming, outgoing, or all relationships for a person Update Edges: Modify relationship types and descriptions Delete Edges: Remove specific relationships Bidirectional Support: Track both directions of relationships

Graph Operations

Full Graph Export: Export entire network as JSON (nodes + edges) Person Network: Get complete network view for an individual Relationship Types: Support for custom relationship types (reports_to, mentors, works_with, etc.)

Tables

people id: INTEGER PRIMARY KEY name: TEXT NOT NULL role: TEXT relation_to_me: TEXT organization: TEXT character: TEXT notes: TEXT created_at: TIMESTAMP updated_at: TIMESTAMP edges id: INTEGER PRIMARY KEY from_person_id: INTEGER (FK to people.id) to_person_id: INTEGER (FK to people.id) relationship_type: TEXT NOT NULL description: TEXT created_at: TIMESTAMP updated_at: TIMESTAMP UNIQUE constraint on (from_person_id, to_person_id, relationship_type)

Indexes

idx_people_name: Index on people.name idx_edges_from: Index on edges.from_person_id idx_edges_to: Index on edges.to_person_id

Command Line Interface

# Person operations python people_skill.py add-person "Jane Doe" --role "CTO" --org "StartupXYZ" --relation "Mentor" python people_skill.py get-person 1 python people_skill.py search "engineer" python people_skill.py list-people --org "StartupXYZ" python people_skill.py update-person 1 --notes "Coffee meeting scheduled" python people_skill.py delete-person 1 # Relationship operations python people_skill.py add-relationship 1 2 "mentors" --description "Tech career guidance" python people_skill.py get-relationships 1 python people_skill.py list-relationships python people_skill.py update-relationship 1 --type "coaches" python people_skill.py delete-relationship 1 # Graph operations python people_skill.py get-graph python people_skill.py get-network 1

Python API

from database import PeopleDatabase from people_skill import PeopleAgent # Initialize agent = PeopleAgent("people.db") # Add people result = agent.add_person( name="Alice Johnson", role="VP Engineering", relation_to_me="Former colleague", organization="TechCorp", character="Strategic thinker, empathetic leader", notes="Worked together 2020-2022" ) person_id = result["person_id"] # Add relationship agent.add_relationship( from_person_id=1, to_person_id=2, relationship_type="manages", description="Direct manager relationship" ) # Query network network = agent.get_person_network(person_id) print(f"Found {network['connections_count']} connections") # Export graph graph = agent.get_graph() print(f"Graph: {graph['nodes_count']} nodes, {graph['edges_count']} edges")

Common Relationship Types

reports_to: Hierarchical reporting (subordinate → manager) manages: Hierarchical management (manager → subordinate) works_with: Peer collaboration mentors: Mentorship (mentor → mentee) mentored_by: Inverse mentorship (mentee → mentor) friends_with: Personal friendship knows: Acquaintance collaborates_with: Project collaboration introduced_by: Connection source

1. Personal CRM

Track professional contacts, their roles, organizations, and how you know them. Add notes about conversations, meetings, or follow-ups. python people_skill.py add-person "Sarah Chen" \ --role "Product Director" \ --org "InnovateCo" \ --relation "Met at conference" \ --notes "Interested in API collaboration, follow up Q2"

2. Organizational Mapping

Build and maintain organizational charts with reporting relationships. # Add team members python people_skill.py add-person "Mike Lead" --role "Team Lead" --org "Engineering" python people_skill.py add-person "Dev One" --role "Engineer" --org "Engineering" python people_skill.py add-person "Dev Two" --role "Engineer" --org "Engineering" # Create reporting structure python people_skill.py add-relationship 2 1 "reports_to" python people_skill.py add-relationship 3 1 "reports_to"

3. Mentorship Network

Track mentorship relationships and career guidance connections. python people_skill.py add-relationship 5 3 "mentors" \ --description "Career guidance in ML/AI"

4. Collaboration Tracking

Map who works with whom on projects. python people_skill.py add-relationship 1 2 "works_with" \ --description "Project Phoenix collaboration"

5. Network Analysis

Analyze your professional network to identify key connections. # View someone's complete network python people_skill.py get-network 1 # Export for visualization python people_skill.py get-graph > network.json

Bidirectional Relationship Queries

The system automatically handles both directions: # Get all relationships for a person edges = db.get_all_edges_for_person(person_id) # Returns: {"outgoing": [...], "incoming": [...]}

Cascade Deletion

Deleting a person automatically removes all associated relationships.

Duplicate Prevention

The UNIQUE constraint prevents duplicate relationships between the same two people with the same type.

Search Flexibility

Search works across multiple fields: python people_skill.py search "engineer" # Matches: names, roles, organizations

Export to Visualization Tools

# Export graph for tools like D3.js, Cytoscape, Gephi python people_skill.py get-graph > graph.json

Import from CSV

import csv from people_skill import PeopleAgent agent = PeopleAgent() with open('contacts.csv', 'r') as f: reader = csv.DictReader(f) for row in reader: agent.add_person( name=row['name'], role=row['role'], organization=row['org'], relation_to_me=row['relation'] )

Best Practices

Consistent Naming: Use consistent naming conventions for relationship types Rich Notes: Add contextual notes to remember important details Regular Updates: Keep information current with update commands Character Tracking: Use the character field to remember personality traits Relationship Descriptions: Add context to relationships for clarity Search First: Before adding, search to avoid duplicates

API Reference

See people_skill.py for complete API documentation.

Key Classes

PeopleDatabase: Low-level database operations PeopleAgent: High-level agent interface with result dictionaries

Return Format

All agent methods return dictionaries with: success: Boolean indicating success/failure message: Human-readable status message (on errors) Data fields specific to the operation

Error Handling

The skill includes comprehensive error handling: Foreign key constraints prevent invalid relationships Unique constraints prevent duplicate relationships Cascade deletion maintains referential integrity Try-catch blocks in CLI provide user-friendly errors

Performance

Indexed queries for fast lookups Efficient graph traversal Suitable for networks of thousands of people SQLite handles concurrent reads

Future Enhancements

Potential extensions: Graph visualization generation Shortest path finding between people Influence/centrality scoring Duplicate person detection Export to various formats (GraphML, DOT) Import from LinkedIn, contact lists Time-based relationship tracking Strength/confidence scoring for relationships

License

MIT

Category context

Data access, storage, extraction, analysis, reporting, and insight generation.

Source: Tencent SkillHub

Largest current source with strong distribution and engagement signals.

Package contents

Included in package
2 Docs2 Scripts1 Files
  • SKILL.md Primary doc
  • README.md Docs
  • database.py Scripts
  • people_skill.py Scripts
  • requirements.txt Files