Database query

Skill EXboys/evotown/backend/arena_skills/database-query

a middle platform for enterprise Agent runtime governance and capability assets — connect OpenClaw, Hermes, SkillLite, and custom runtimes in one place; accumulate Skills and enterprise knowledge; provide observability, review, and private distribution

Install

npx -y skills add EXboys/evotown --skill database-query

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

通过 Evotown Database MCP Proxy 对已注册的业务数据库执行只读 SQL 查询。当用户需要查 CRM、订单、报表等结构化数据时使用；禁止直连数据库或写入 SQL。

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

2.1 KB, as published. Nobody here has run it

Database Query Skill

通过 Evotown Database MCP Proxy 查询企业已注册数据库。Skill 不持有连接串；权限由 Evotown ACL + Proxy 校验。

前置条件

管理员在 Evotown 控制台注册数据库并配置 MCP 地址
当前员工 API Key 已被授权访问目标 connection_id
MCP Proxy 服务已启动（EVOTOWN_DB_MCP_URL，默认 http://localhost:9100）

动作

action	说明
`list_connections`	列出当前员工可访问的数据库
`list_tables`	列出某库的表
`query`	执行只读 SELECT（Proxy 自动加 LIMIT，拒绝 INSERT/UPDATE/DELETE）

示例

列出可访问数据库

{
  "action": "list_connections",
  "api_key": "evk_..."
}

查表

{
  "action": "list_tables",
  "connection_id": "crm-demo",
  "api_key": "evk_..."
}

只读查询

{
  "action": "query",
  "connection_id": "crm-demo",
  "sql": "SELECT id, name, amount FROM orders WHERE status = 'paid'",
  "api_key": "evk_..."
}

也可设置环境变量 EVOTOWN_EMPLOYEE_API_KEY，省略 api_key 字段。

Runtime

entry_point: scripts/main.py
language: python
network:
  enabled: true
  outbound:
    - "*:9100"
    - "*:8765"
input_schema:
  type: object
  properties:
    action:
      type: string
      enum: [list_connections, list_tables, query]
      default: query
    connection_id:
      type: string
      description: Evotown 注册的 connection_id
    sql:
      type: string
      description: 只读 SELECT / WITH / EXPLAIN 语句
    api_key:
      type: string
      description: 员工 evk_ API Key（可改用环境变量 EVOTOWN_EMPLOYEE_API_KEY）
  required: []