Andara RAG Knowledge Search

---

name: andara-rag-search

description: Search the Andara Ionic RAG knowledge base (3,800+ records) for business intel, research, products, team, meetings, and any indexed content.

---

# Andara RAG Knowledge Search

Use this skill when you need to find information about:

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

| Table | Description | Key Columns |

|-------|-------------|-------------|

| `knowledge_base` | RAG chunks (3,800+) | `content`, `source`, `data_type` |

| `team_members` | Team roster (6 active) | `name`, `role`, `title`, `email`, `department`, `equity_percent` |

| `team_meetings` | Meeting notes (5) | `title`, `date`, `summary`, `key_insights`, `decisions` |

| `meeting_action_items` | Action items (32) | `title`, `assignee`, `status`, `priority`, `due_date` |

| `team_goals` | Company goals (4) | `title`, `status`, `target_date`, `progress_percent` |

CMS & Commerce

| Table | Description | Key Columns |

|-------|-------------|-------------|

| `pages` | CMS pages (155) | `slug`, `title`, `content`, `zone`, `cluster_id`, `status` |

| `products` | Products (2) | `name`, `price_cents`, `description`, `sku` |

| `orders` | Orders (11) | `total`, `status`, `customer_name`, `created_at` |

| `customers` | Customers (10) | `name`, `email`, `created_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 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