{"resources": [{"resource_type": "agent", "label": "Agent", "description": "A Agent row (agent.definition).", "table": "agent.definition", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "agent_type", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "name", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "messages", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "variable_definitions", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "model_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "model_tiers", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "settings", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "output_schema", "type": "json", "nullable": true, "writable": true, "primary_key": false}, {"name": "tools", "type": "uuidarray", "nullable": false, "writable": true, "primary_key": false}, {"name": "custom_tools", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "context_slots", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "category", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "tags", "type": "textarray", "nullable": false, "writable": true, "primary_key": false}, {"name": "is_active", "type": "boolean", "nullable": false, "writable": true, "primary_key": false}, {"name": "is_archived", "type": "boolean", "nullable": false, "writable": true, "primary_key": false}, {"name": "is_favorite", "type": "boolean", "nullable": false, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "task_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_agent_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_snapshot_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "mcp_servers", "type": "uuidarray", "nullable": false, "writable": true, "primary_key": false}, {"name": "rag_awareness_mode", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "rag_awareness_fragment", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "rag_awareness_refreshed_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "tool_config", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "default_rag_boost", "type": "smallinteger", "nullable": false, "writable": true, "primary_key": false}, {"name": "skill_config", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "matrx_actions", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "ui_gates", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "card_visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["agent_type", "category", "context_slots", "custom_tools", "default_rag_boost", "description", "is_active", "is_archived", "is_favorite", "matrx_actions", "mcp_servers", "messages", "metadata", "model_id", "model_tiers", "name", "output_schema", "rag_awareness_fragment", "rag_awareness_mode", "settings", "skill_config", "source_agent_id", "tags", "task_id", "tool_config", "tools", "ui_gates", "variable_definitions"]}, {"resource_type": "dataset", "label": "Data Table", "description": "A user-defined data table's metadata (name, description, project/task). The rows and column schema are managed via the spreadsheet/workbook surface; use this to find or relabel a table.", "table": "workbench.udt_datasets", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "table_name", "type": "char", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "user_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "is_public", "type": "boolean", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "row_ordering_config", "type": "jsonb", "nullable": true, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "project_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "task_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "workbook_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "sheet_index", "type": "integer", "nullable": true, "writable": false, "primary_key": false}, {"name": "validation_mode", "type": "text", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "template_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "template_version", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["description", "metadata", "project_id", "table_name", "task_id", "template_id", "template_version"]}, {"resource_type": "fc_card", "label": "Flashcard", "description": "A flashcard (front/back text), optionally tagged by topic or lesson.", "table": "education.fc_card", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "front", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "back", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "card_kind", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "difficulty", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "topic", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "lesson", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "personal_notes", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "dynamic_content", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["back", "card_kind", "difficulty", "dynamic_content", "front", "lesson", "metadata", "personal_notes", "topic"]}, {"resource_type": "fc_set", "label": "Flashcard Set", "description": "A named set of flashcards (name, description, topic/lesson metadata).", "table": "education.fc_set", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "name", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "topic", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "lesson", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "difficulty", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "audio_overview_file_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}], "writable_fields": ["audio_overview_file_id", "description", "difficulty", "lesson", "metadata", "name", "topic"]}, {"resource_type": "note", "label": "Note", "description": "A user's note (label + rich text/markdown content), optionally filed under a project or task.", "table": "workbench.notes", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "label", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "content", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "folder_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "tags", "type": "textarray", "nullable": true, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "position", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "folder_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "file_path", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "content_hash", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "sync_version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "last_device_id", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "project_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "task_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}], "writable_fields": ["content", "file_path", "folder_id", "folder_name", "label", "metadata", "position", "project_id", "tags", "task_id"]}, {"resource_type": "party", "label": "Contact (person or company)", "description": "A CRM contact \u2014 one canonical record for an external person or company (an expert, lead, customer, vendor, author). To CREATE one, prefer data_action(operation='resolve_contact') which dedupes on email/phone/domain/external ids; a bare create dedupes on nothing. Emails/phones are NOT columns here \u2014 they live on contact media linked to the party.", "table": "crm.party", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "party_kind", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "display_name", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "sort_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "name_key", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "aka", "type": "textarray", "nullable": false, "writable": true, "primary_key": false}, {"name": "first_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "middle_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "preferred_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "name_prefix", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "name_suffix", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "pronouns", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "date_of_birth", "type": "date", "nullable": true, "writable": true, "primary_key": false}, {"name": "headline", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "legal_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "primary_domain", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "industry_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "employee_band", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "founded_year", "type": "smallinteger", "nullable": true, "writable": true, "primary_key": false}, {"name": "tax_id", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "registration_number", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "bio", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "avatar_file_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "timezone", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "locale", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "canonical_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "source_party_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "source_synced_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "locked_fields", "type": "textarray", "nullable": false, "writable": false, "primary_key": false}, {"name": "expert_status", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "claimed_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "claimed_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "assigned_to", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "lifecycle_stage_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "lifecycle_stage_changed_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "became_customer_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "rating_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "source", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_detail", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "do_not_contact", "type": "boolean", "nullable": false, "writable": false, "primary_key": false}, {"name": "do_not_contact_reason", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "linked_organization_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "primary_employer_party_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "job_title", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "attributes", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["aka", "assigned_to", "attributes", "avatar_file_id", "bio", "date_of_birth", "display_name", "employee_band", "first_name", "founded_year", "headline", "industry_id", "last_name", "legal_name", "lifecycle_stage_id", "locale", "metadata", "middle_name", "name_prefix", "name_suffix", "party_kind", "preferred_name", "primary_domain", "pronouns", "rating_id", "registration_number", "sort_name", "source", "source_detail", "tax_id", "timezone"]}, {"resource_type": "project", "label": "Project", "description": "A project that groups tasks and notes.", "table": "workspace.projects", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "name", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "slug", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "settings", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "status", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "priority", "type": "enum", "nullable": true, "writable": true, "primary_key": false}, {"name": "start_date", "type": "date", "nullable": true, "writable": true, "primary_key": false}, {"name": "target_date", "type": "date", "nullable": true, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["description", "metadata", "name", "priority", "settings", "slug", "start_date", "status", "target_date"]}, {"resource_type": "quiz_session", "label": "Quiz Session", "description": "An interactive quiz session (title + JSON state).", "table": "education.quiz_sessions", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "title", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "state", "type": "jsonb", "nullable": false, "writable": false, "primary_key": false}, {"name": "is_completed", "type": "boolean", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "completed_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "quiz_content_hash", "type": "text", "nullable": true, "writable": false, "primary_key": false}, {"name": "quiz_metadata", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "category", "type": "char", "nullable": true, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["category", "completed_at", "is_completed", "metadata", "quiz_metadata", "title"]}, {"resource_type": "research_document", "label": "Research Document", "description": "A document gathered under a research topic.", "table": "research.rs_document", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "topic_id", "type": "foreignkey", "nullable": false, "writable": true, "primary_key": false}, {"name": "title", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "content", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "content_structured", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_consolidation_ids", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "agent_type", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "agent_id", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "model_id", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "token_usage", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "version", "type": "integer", "nullable": true, "writable": false, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "status", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "error", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "is_current", "type": "boolean", "nullable": false, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["agent_id", "agent_type", "content", "content_structured", "error", "is_current", "metadata", "model_id", "source_consolidation_ids", "status", "title", "token_usage", "topic_id"]}, {"resource_type": "research_source", "label": "Research Source", "description": "A source (URL/citation) gathered under a research topic.", "table": "research.rs_source", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "topic_id", "type": "foreignkey", "nullable": false, "writable": true, "primary_key": false}, {"name": "url", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "title", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "hostname", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_type", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "origin", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "rank", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "page_age", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "thumbnail_url", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "extra_snippets", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "raw_search_result", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "is_included", "type": "boolean", "nullable": true, "writable": true, "primary_key": false}, {"name": "is_stale", "type": "boolean", "nullable": true, "writable": true, "primary_key": false}, {"name": "scrape_status", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "discovered_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_seen_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "user_verdict", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "user_verdict_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "user_verdict_notes", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "server_attempts", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "last_server_attempt_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_server_failure_reason", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "server_gave_up", "type": "boolean", "nullable": false, "writable": true, "primary_key": false}, {"name": "policy_category", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "policy_reason", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "authority_score", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "authority_tier", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "authority_reasoning", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "authority_ranked_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "pre_read_score", "type": "float", "nullable": true, "writable": true, "primary_key": false}, {"name": "pre_read_breakdown", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "post_read_score", "type": "float", "nullable": true, "writable": true, "primary_key": false}, {"name": "final_source_score", "type": "float", "nullable": true, "writable": true, "primary_key": false}, {"name": "recommended_use", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "analysis_status", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "page_analysis", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "scrape_worthiness", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "redundancy_group", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "entity_match_confidence", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "snippet_relevance", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["analysis_status", "authority_ranked_at", "authority_reasoning", "authority_score", "authority_tier", "description", "discovered_at", "entity_match_confidence", "extra_snippets", "final_source_score", "hostname", "is_included", "is_stale", "last_seen_at", "last_server_attempt_at", "last_server_failure_reason", "metadata", "origin", "page_age", "page_analysis", "policy_category", "policy_reason", "post_read_score", "pre_read_breakdown", "pre_read_score", "rank", "raw_search_result", "recommended_use", "redundancy_group", "scrape_status", "scrape_worthiness", "server_attempts", "server_gave_up", "snippet_relevance", "source_type", "thumbnail_url", "title", "topic_id", "url", "user_verdict", "user_verdict_at", "user_verdict_notes"]}, {"resource_type": "research_topic", "label": "Research Topic", "description": "A research topic the user is investigating.", "table": "research.rs_topic", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "name", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "autonomy_level", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "default_search_provider", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "default_search_params", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "good_scrape_threshold", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "scrapes_per_keyword", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "status", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "template_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "agent_config", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "max_keywords", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "analyses_per_keyword", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "max_keyword_syntheses", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "max_topic_syntheses", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "max_documents", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "max_tag_consolidations", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "max_auto_tag_calls", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "tone_profile", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "outputs", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "tag_suggestions", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "videos_per_keyword", "type": "integer", "nullable": false, "writable": true, "primary_key": false}, {"name": "intent_key", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "intent_brief", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "refresh_interval_hours", "type": "integer", "nullable": true, "writable": true, "primary_key": false}, {"name": "next_refresh_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "refresh_claim_token", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "refresh_claim_expires_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_refresh_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_refresh_outcome", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_refresh_error", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "last_refresh_trigger", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "consecutive_refresh_failures", "type": "integer", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["agent_config", "analyses_per_keyword", "autonomy_level", "consecutive_refresh_failures", "default_search_params", "default_search_provider", "description", "good_scrape_threshold", "intent_brief", "intent_key", "last_refresh_at", "last_refresh_error", "last_refresh_outcome", "last_refresh_trigger", "max_auto_tag_calls", "max_documents", "max_keyword_syntheses", "max_keywords", "max_tag_consolidations", "max_topic_syntheses", "metadata", "name", "next_refresh_at", "outputs", "refresh_claim_expires_at", "refresh_claim_token", "refresh_interval_hours", "scrapes_per_keyword", "status", "tag_suggestions", "template_id", "tone_profile", "videos_per_keyword"]}, {"resource_type": "structured_list", "label": "Pick List", "description": "A reusable pick list \u2014 a named set of dropdown/option values (its display name + description). The option entries themselves are managed separately; this resource is the list.", "table": "workbench.udt_structured_lists", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "list_name", "type": "char", "nullable": true, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "user_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "is_public", "type": "boolean", "nullable": true, "writable": false, "primary_key": false}, {"name": "public_read", "type": "boolean", "nullable": true, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["description", "list_name", "metadata"]}, {"resource_type": "task", "label": "Task", "description": "A task with title, description, status, priority and due date \u2014 optionally under a project.", "table": "workspace.tasks", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "title", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "project_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "status", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "due_date", "type": "date", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "parent_task_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "priority", "type": "enum", "nullable": true, "writable": true, "primary_key": false}, {"name": "assignee_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "settings", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "completed_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "origin", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "source_type", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_id", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_url", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_label", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "dedupe_key", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "start_date", "type": "date", "nullable": true, "writable": true, "primary_key": false}, {"name": "due_time", "type": "time", "nullable": true, "writable": true, "primary_key": false}, {"name": "timezone", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "recurrence_rule", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "reminders", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}], "writable_fields": ["assignee_id", "completed_at", "dedupe_key", "description", "due_date", "due_time", "metadata", "origin", "parent_task_id", "priority", "project_id", "recurrence_rule", "reminders", "settings", "source_id", "source_label", "source_type", "source_url", "start_date", "status", "timezone", "title"]}, {"resource_type": "transcript", "label": "Transcript", "description": "A transcription/recording transcript (title + content), optionally under a project.", "table": "transcripts.transcripts", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "title", "type": "text", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "segments", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": false, "writable": true, "primary_key": false}, {"name": "audio_file_path", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "video_file_path", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source_type", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "tags", "type": "textarray", "nullable": true, "writable": true, "primary_key": false}, {"name": "folder_name", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "is_draft", "type": "boolean", "nullable": true, "writable": true, "primary_key": false}, {"name": "draft_saved_at", "type": "datetime", "nullable": true, "writable": true, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "project_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "task_id", "type": "foreignkey", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}, {"name": "deleted_at", "type": "datetime", "nullable": true, "writable": false, "primary_key": false}, {"name": "visibility", "type": "enum", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["audio_file_path", "description", "draft_saved_at", "folder_name", "is_draft", "metadata", "project_id", "segments", "source_type", "tags", "task_id", "title", "video_file_path"]}, {"resource_type": "udt_document", "label": "Document", "description": "A cloud document's metadata (name, description, project/task). Use the `document` tool (action create/read/edit) to make one or read/change the actual document content.", "table": "workbench.udt_documents", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "document_name", "type": "char", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "original_file_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "user_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "project_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "task_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "is_public", "type": "boolean", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["description", "document_name", "metadata", "project_id", "task_id"]}, {"resource_type": "workbook", "label": "Workbook", "description": "A spreadsheet's metadata (name, description, project/task). Use the `workbook` tool (action create/read/edit) to make one or read/change the actual sheet cells.", "table": "workbench.udt_workbooks", "fields": [{"name": "id", "type": "uuid", "nullable": true, "writable": false, "primary_key": true}, {"name": "workbook_name", "type": "char", "nullable": false, "writable": true, "primary_key": false}, {"name": "description", "type": "text", "nullable": true, "writable": true, "primary_key": false}, {"name": "source", "type": "enum", "nullable": false, "writable": false, "primary_key": false}, {"name": "original_file_id", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "user_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "organization_id", "type": "foreignkey", "nullable": false, "writable": false, "primary_key": false}, {"name": "project_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "task_id", "type": "uuid", "nullable": true, "writable": true, "primary_key": false}, {"name": "is_public", "type": "boolean", "nullable": false, "writable": false, "primary_key": false}, {"name": "metadata", "type": "jsonb", "nullable": true, "writable": true, "primary_key": false}, {"name": "created_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "updated_at", "type": "datetime", "nullable": false, "writable": false, "primary_key": false}, {"name": "created_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "updated_by", "type": "foreignkey", "nullable": true, "writable": false, "primary_key": false}, {"name": "version", "type": "integer", "nullable": false, "writable": false, "primary_key": false}], "writable_fields": ["description", "metadata", "project_id", "task_id", "workbook_name"]}], "usage": "Use the `data` tool with action query/get/create/update/delete on any resource_type above. Everything runs as YOU (the user) with Postgres row-level security enforced \u2014 you can only see and change what you are allowed to. Only `writable_fields` may be set on create/update; ownership (user_id) and organization are set automatically. For multi-step jobs (e.g. turning a transcript into a note + task), prefer the `data_action` tool."}