Skip to main content
Glama
rubyLs

@rubyls/yearning-mcp

by rubyLs

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MCP_HOSTNoHTTP 监听主机0.0.0.0
MCP_PORTNoHTTP 监听端口8080
YEARNING_URLNoYearning 地址http://localhost:8000
MCP_TRANSPORTNostdio / sse / streamable-httpstdio
MCP_AUTH_TOKENNoHTTP Bearer 鉴权令牌
YEARNING_TIMEOUTNo请求超时(秒)30
YEARNING_INSECURENo跳过 TLS 校验false
YEARNING_PASSWORDYes登录密码
YEARNING_USERNAMEYes登录用户名
MCP_STATELESS_HTTPNo无状态 HTTPfalse
YEARNING_READ_ONLYNotrue 时不注册写工具false
YEARNING_LOGIN_TYPENogeneral / ldapgeneral

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": true
}
resources
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
yearning_user_infoA

查看当前登录用户信息、部门、邮箱,以及有权查询的数据源列表。对应 GET /api/v2/fetch/userinfo

yearning_list_sourcesB

列出当前账号有权限的数据源(可按 query/dml/ddl/idc 过滤)。对应 GET /api/v2/fetch/source

yearning_list_databasesB

列出指定数据源下的数据库列表。对应 GET /api/v2/fetch/base

yearning_list_tablesA

列出指定数据源、指定库下的表。对应 GET /api/v2/fetch/table

yearning_table_fieldsA

查看表结构:字段列表(类型/可空/键/默认值/注释)与索引。对应 GET /api/v2/fetch/fields

yearning_sql_checkA

提交前对 SQL 做审核检测。建议先调用本工具,再 yearning_submit_order。对应 PUT /api/v2/fetch/test。不接受 SELECT(请用 yearning_run_query)。

yearning_my_ordersA

分页列出当前用户提交的工单。状态:8=全部 / 2=待审核 / 3=已完成 / 0=已驳回 / 4=已终止 / 6=已撤回 / 1=执行中 / 5=待执行。对应 WS /api/v2/common/list

yearning_order_detailB

查看工单详情:SQL 明细与完整 SQL。对应 GET /api/v2/fetch/detail + /fetch/sql

yearning_order_timelineA

查看工单审核时间线与流程步骤。审核时 flag 取自此处。对应 GET /api/v2/fetch/timeline + /fetch/steps

yearning_rollback_sqlA

获取工单的回滚 SQL。对应 GET /api/v2/fetch/roll

yearning_audit_ordersA

分页列出与当前用户相关的待审核工单(审核人视角)。对应 WS /api/v2/audit/order/list

yearning_query_statusB

查看查询审核开关,以及当前用户查询工单是否有效。对应 GET /api/v2/fetch/is_query + /fetch/query_status

yearning_run_queryA

在指定数据源执行只读 SELECT 查询。需具备查询权限;若开启查询审核,需先 yearning_submit_query_order。对应 WS /api/v2/query/results(msgpack)

yearning_order_commentsA

读取指定工单的全部评论。对应 WS /api/v2/fetch/comment

yearning_submit_orderA

提交 SQL 工单(DDL/DML)。提交前建议先 yearning_sql_check。对应 POST /api/v2/common/post。必须传 confirm=true 才会真正提交。

yearning_undo_orderA

撤回自己提交、尚未执行的工单。对应 GET /api/v2/fetch/undo。必须传 confirm=true。

yearning_audit_orderA

审核工单:agree 同意(末级步骤会触发 SQL 执行)/ reject 驳回 / undo 撤回。flag 为当前审核步骤序号(用 yearning_order_timeline 确认);reject 必须提供 reason。agree 为高危操作,必须 confirm=true。对应 POST /api/v2/audit/order/state

yearning_submit_query_orderA

提交数据查询申请。开通查询审核时需审批通过后方可 yearning_run_query。对应 POST /api/v2/query/post

yearning_post_commentC

在指定工单下发表评论。对应 POST /api/v2/fetch/comment

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription
user-info当前登录用户信息(已脱敏)与可查询数据源
sources当前账号有权限的数据源

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/rubyLs/yearning_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server