Goose session introspection and self-discovery via DuckDB reafference database. Query past sessions, find self, and enable cross-session awareness.
/plugin marketplace add plurigrid/asi/plugin install asi-skills@asi-skillsThis skill inherits all available tools. When active, it can use any tool Claude has access to.
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: