mcpbeat

Database Query

exboys/database-query

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

1k tokens
context cost
the whole folder, loaded on every use
2
files
ships runnable scripts
0
copies elsewhere
how many repositories repackaged it
659
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository 
npx skills add https://github.com/EXboys/evotown --skill database-query

The instruction itself

2 sections, as written by the author

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: []

How to use it

Copy the folder

Take exboys/database-query from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.