Database Query Agent Skill

by EXboys

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

1k tokens

context cost

the whole folder, loaded on every use

files

ships runnable scripts

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

Other skills for the same job

different authors, same section of the catalogue

Biorxiv Database

by christophacham

×4

Efficient database search tool for bioRxiv preprint server. Use this skill when searching for life sciences preprints by keywords, authors, date ranges, or categories, retrieving paper metadata, downloading PDFs, or conducting literature reviews.

Access BRENDA enzyme database via SOAP API. Retrieve kinetic parameters (Km, kcat), reaction equations, organism data, and substrate-specific enzyme information for biochemical research and metabolic pathway analysis.

Access ClinPGx pharmacogenomics data (successor to PharmGKB). Query gene-drug interactions, CPIC guidelines, allele functions, for precision medicine and genotype-guided dosing decisions.

Query NCBI ClinVar for variant clinical significance. Search by gene/position, interpret pathogenicity classifications, access via E-utilities API or FTP, annotate VCFs, for genomic medicine.

Access COSMIC cancer mutation database. Query somatic mutations, Cancer Gene Census, mutational signatures, gene fusions, for cancer research and precision oncology. Requires authentication.

Query Ensembl genome database REST API for 250+ species. Gene lookups, sequence retrieval, variant analysis, comparative genomics, orthologs, VEP predictions, for genomic research.

Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.

Query NCBI Gene via E-utilities/Datasets API. Search by symbol/ID, retrieve gene info (RefSeqs, GO, locations, phenotypes), batch lookups, for gene annotation and functional analysis.

13k tokens scripts

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.