知识检索
andara-rag-search
by atiati82
Search the Andara Ionic RAG knowledge base (3,800+ records) for business intel, research, products, team, meetings, and any indexed content.
安装
claude skill add --url https://github.com/openclaw/skills文档
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
| 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
- 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
ILIKEfor case-insensitive text searches - Never INSERT, UPDATE, or DELETE — read-only access only
- For questions about the website structure, query the
pagestable - For scientific questions, search
knowledge_baseWHEREdata_type = 'research'OR searchscience_articles
相关 Skills
SEO审计工具
by amdf01-debug
浏览器自动化
by chulla-ceja
Browser automation CLI for AI agents. Use when the user needs to interact with websites, including navigating pages, filling forms, clicking buttons, taking screenshots, extracting data, testing web apps, or automating any browser task. Triggers include requests to "open a website", "fill out a form", "click a button", "take a screenshot", "scrape data from a page", "test this web app", "login to a site", "automate browser actions", or any task requiring programmatic web interaction.
多视角辩论
by caius-kong
Multi-perspective structured debate for complex topics. Spawn parallel subagents with opposing stances, cross-inject arguments for rebuttal, then synthesize via neutral judge into a consensus report with recommendations and scenario matrix. Use when: (1) user asks for deep comparison, pros/cons, or X vs Y analysis, (2) user asks for multi-angle research on a controversial or complex topic, (3) user explicitly requests debate, dialectical analysis, or adversarial research. NOT for: simple factual lookups, single-perspective deep research (use academic-deep-research), or quick opinion questions.
相关 MCP 服务
Puppeteer 浏览器控制
编辑精选by Anthropic
Puppeteer 是让 Claude 自动操作浏览器进行网页抓取和测试的 MCP 服务器。
✎ 这个服务器解决了手动编写 Puppeteer 脚本的繁琐问题，适合需要自动化网页交互的开发者，比如抓取动态内容或做端到端测试。不过，作为参考实现，它可能缺少生产级的安全防护，建议在可控环境中使用。
网页抓取
编辑精选by Anthropic
Fetch 是 MCP 官方参考服务器，让 AI 能抓取网页并转为 Markdown 格式。
✎ 这个服务器解决了 AI 直接处理网页内容时格式混乱的问题，适合需要让 Claude 分析在线文档或新闻的开发者。不过作为参考实现，它缺乏生产级的安全配置，你得自己处理反爬虫和隐私风险。
Brave 搜索
编辑精选by Anthropic
Brave Search 是让 Claude 直接调用 Brave 搜索 API 获取实时网络信息的 MCP 服务器。
✎ 如果你想让 AI 助手帮你搜索最新资讯或技术文档，这个工具能绕过传统搜索的限制，直接返回结构化数据。特别适合需要实时信息的开发者，比如查 API 更新或竞品动态。不过它依赖 Brave 的 API 配额，高频使用可能受限。