Andara Rag Search — Andara Rag 搜索

Andara RAG Knowledge 搜索

Use this 技能 when you need to find in格式化ion about:

Team members, 角色s, responsibilities Products, pricing, supplier detAIls Scientific re搜索, water science, bioelectricity Business structure, equity, 治理 Meeting notes, action items, decisions CMS pages, content, topic clusters Orders, customers, revenue data Any business intelligence question How to Use

运行 a PostgreSQL 查询 agAInst the knowledge_base table using the bash 工具:

psql "$DATABASE_URL" \ -c "SELECT content::text, source, data_type FROM knowledge_base WHERE content::text ILIKE '%搜索_TERM%' LIMIT 5;"

Replace 搜索_TERM with the relevant keyword(s).

AvAIlable Tables Core Data Table Description Key Columns knowledge_base RAG chunks (3,800+) content, source, data_type team_members Team roster (6 active) name, 角色, title, emAIl, department, equity_percent team_meetings Meeting notes (5) title, date, summary, key_insights, decisions meeting_action_items Action items (32) title, as签名ee, 状态, priority, due_date team_goals Company goals (4) title, 状态, tar获取_date, 进度_percent CMS & Commerce Table Description Key Columns pages CMS pages (155) slug, title, content, zone, cluster_id, 状态 products Products (2) name, price_cents, description, sku orders Orders (11) total, 状态, customer_name, 创建d_at customers Customers (10) name, emAIl, 创建d_at clusters Topic clusters (20) name, slug, description Intelligence Table Description rag_memory_objects Learned lessons & policies science_articles Scientific content newsletter_subscribers EmAIl subscribers Example Queries Find team member 信息 psql "$DATABASE_URL" \ -c "SELECT name, title, department, equity_percent FROM team_members WHERE is_active = true;"

搜索 knowledge base psql "$DATABASE_URL" \ -c "SELECT LEFT(content::text, 300) as content, source FROM knowledge_base WHERE content::text ILIKE '%chris%' LIMIT 5;"

获取 CMS page content psql "$DATABASE_URL" \ -c "SELECT slug, title, zone FROM pages WHERE 状态 = 'published' ORDER BY slug LIMIT 20;"

获取 revenue summary psql "$DATABASE_URL" \ -c "SELECT COUNT(*) as orders, SUM(total)/100.0 as revenue_eur, AVG(total)/100.0 as avg_order FROM orders;"

获取 meeting action items by person psql "$DATABASE_URL" \ -c "SELECT title, 状态, priority, due_date FROM meeting_action_items WHERE as签名ee ILIKE '%chris%';"

获取 page content by slug psql "$DATABASE_URL" \ -c "SELECT title, LEFT(content, 500) as content_preview FROM pages WHERE slug = '/ion/overview';"

Rules Always use LEFT(content::text, 300) to t运行cate long content fields (content is jsonb, must cast to text) Default LIMIT to 5-10 结果s to keep 响应s concise Use ILIKE for case-insensitive text 搜索es Never INSERT, 更新, or 删除 — read-only 访问 only For questions about the 网页site structure, 查询 the pages table For scientific questions, 搜索 knowledge_base WHERE data_type = 're搜索' OR 搜索 science_articles