Andara RAG Knowledge Search

Use this skill when you need to find information about:

• Team members, roles, responsibilities
• Products, pricing, supplier details
• Scientific research, water science, bioelectricity
• Business structure, equity, governance
• Meeting notes, action items, decisions
• CMS pages, content, topic clusters
• Orders, customers, revenue data
• Any business intelligence question

How to Use

Run a PostgreSQL query against the knowledge_base table using the bash tool:

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

Replace SEARCH_TERM with the relevant keyword(s).

Available Tables

Core Data

CMS & Commerce

Intelligence

Example Queries

Find team member info

psql "$DATABASE_URL" \
  -c "SELECT name, title, department, equity_percent FROM team_members WHERE is_active = true;"

Search knowledge base

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

Get CMS page content

psql "$DATABASE_URL" \
  -c "SELECT slug, title, zone FROM pages WHERE status = 'published' ORDER BY slug LIMIT 20;"

Get 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;"

Get meeting action items by person

psql "$DATABASE_URL" \
  -c "SELECT title, status, priority, due_date FROM meeting_action_items WHERE assignee ILIKE '%chris%';"

Get 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 truncate long content fields (content is jsonb, must cast to text)
• Default LIMIT to 5-10 results to keep responses concise
• Use ILIKE for case-insensitive text searches
• Never INSERT, UPDATE, or DELETE — read-only access only
• For questions about the website structure, query the pages table
• For scientific questions, search knowledge_base WHERE data_type = 'research' OR search science_articles