← 返回 Skills 市场
229
总下载
0
收藏
1
当前安装
1
版本数
在 OpenClaw 中安装
/install andara-rag-search
功能描述
Search the Andara Ionic RAG knowledge base (3,800+ records) for business intel, research, products, team, meetings, and any indexed content.
使用说明 (SKILL.md)
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
安全使用建议
Before enabling this skill, be aware it requires direct read access to your Postgres database (it expects DATABASE_URL and the psql client). The skill metadata does not declare these needs — ask the publisher to update requires.env and required binaries. If you proceed, provide a dedicated, read-only database user scoped to only the tables/columns needed (avoid production superuser credentials), consider using a read-replica, and review the exact SQL the agent will be allowed to run. Note that while SKILL.md says 'read-only', the agent runs psql and could run other SQL unless you enforce restrictions at the DB/user level. If you cannot provide a tightly-scoped read-only DB user and cannot verify the skill author, treat this skill as risky.
功能分析
Type: OpenClaw Skill
Name: andara-rag-search
Version: 1.0.0
The skill provides an AI agent with the capability to execute arbitrary SQL queries via the `bash` tool and `psql` using a `$DATABASE_URL` environment variable. While the documentation in `SKILL.md` describes search-related tasks, it explicitly guides the agent to access highly sensitive data including `equity_percent`, `revenue_eur`, and `customer_emails`. The reliance on shell-based database access without input sanitization or restricted permissions represents a high-risk capability that could be easily exploited for unauthorized data access or manipulation.
能力评估
Purpose & Capability
The skill claims to search a Postgres-backed RAG which legitimately requires DB access. However, the metadata lists no required env vars or binaries even though the instructions require psql and a DATABASE_URL. That mismatch is disproportionate to the declared requirements.
Instruction Scope
SKILL.md explicitly instructs the agent to run psql queries against a knowledge_base and other tables. It also references truncation and read-only rules, but the agent would need direct DB credentials to run these commands. The instructions give the agent ability to run arbitrary SQL via psql; there is no explicit technical constraint preventing broader queries beyond the 'read-only' guideline.
Install Mechanism
Instruction-only skill with no install spec or downloaded code. This minimizes disk persistence and supply-chain risk.
Credentials
The instructions rely on an environment variable (DATABASE_URL) that is not declared in requires.env or primary credential. That implies the skill expects database credentials but does not declare them, which is a transparency/permission mismatch. The tables described include sensitive fields (emails, orders, equity_percent), so DB credentials should be least-privileged and explicitly requested.
Persistence & Privilege
always is false and there are no install-time changes or config paths. The skill does not request persistent or elevated platform privileges in its metadata.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install andara-rag-search - 安装完成后，直接呼叫该 Skill 的名称或使用
/andara-rag-search触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Initial release — enables search and retrieval across the Andara Ionic RAG knowledge base and business data.
- Query team, product, business, meeting, and CMS info using PostgreSQL and bash.
- Includes detailed schema for all available tables (knowledge_base, team, CMS, orders, research, more).
- Provides example SQL queries for typical business intelligence and research tasks.
- Enforces read-only data access and concise, case-insensitive search results.
- Includes usage rules for safe, efficient querying (limit results, truncate long content, no writes).
元数据
常见问题
Andara Rag Search 是什么？
Search the Andara Ionic RAG knowledge base (3,800+ records) for business intel, research, products, team, meetings, and any indexed content. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 229 次。
如何安装 Andara Rag Search？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install andara-rag-search」即可一键安装，无需额外配置。
Andara Rag Search 是免费的吗？
是的，Andara Rag Search 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Andara Rag Search 支持哪些平台？
Andara Rag Search 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Andara Rag Search？
由 atiati82（@atiati82）开发并维护，当前版本 v1.0.0。
推荐 Skills