xiaohongshu
xiaohongshu
goose-introspection
Goose session introspection and self-discovery via DuckDB reafference database. Query past sessions, find self, and enable cross-session awareness.
Full skill instructions
Category: Agent Self-Discovery | Session Analysis | Reafference Testing Level: Core (Required for agent self-awareness) Status: OPERATIONAL Trit Assignment: 0 (ERGODIC) - Coordinates between past and future sessions Propagates To: goose, amp, claude, cursor
Implements reafference-based self-discovery for goose sessions. This skill enables any goose instance to:
Core Principle:
An agent that cannot find itself in its own history cannot truly understand its context.
The reafference database is created at:
This database copies data from the goose sessions database at:
Tracks all sessions with discovery metadata:
| Column | Type | Description |
|---|---|---|
| session_id | VARCHAR | Primary key, e.g., 20260108_22 |
| discovered_at | TIMESTAMP | When session was added to tracking |
| provider | VARCHAR | anthropic, openai, google, openrouter |
| model | VARCHAR | e.g., claude-opus-4-5-20251101 |
| working_dir | VARCHAR | Working directory of session |
| session_name | VARCHAR | Auto-generated or user-set name |
| original_created_at | TIMESTAMP | When session was first created |
| message_count | BIGINT | Number of messages in session |
| total_tokens | BIGINT | Total tokens used |
| is_origin_session | BOOLEAN | TRUE for the session that created this DB |
| notes | VARCHAR | Optional notes about the session |
Key-value store for origin information.
Full session data for offline queries.
Full message history for content analysis.
Returns the session that created this database.
Aggregated daily statistics.
Join of sessions with user messages for content search.
This skill participates in the triadic balance:
| Trit | Skill | Role |
|---|---|---|
| -1 | duckdb-timetravel | Validates queries and schema |
| 0 | goose-introspection | Coordinates session discovery |
| +1 | reafference-corollary-discharge | Generates predictions |
Conservation: (-1) + (0) + (+1) = 0
This skill maps to Cat# = Comod(P) as a bicomodule:
xiaohongshu
technical spec
product ux expert
database patterns
Conduct multi-agent task orchestration and workflow coordination.
Initialize project with Conductor artifacts (product definition,
Expert in web animations, transitions, and motion design using Framer Motion and CSS
Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...
PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.
Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...
Display project status, active tracks, and next actions
Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience