@rubyls/yearning-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_HOST | No | HTTP 监听主机 | 0.0.0.0 |
| MCP_PORT | No | HTTP 监听端口 | 8080 |
| YEARNING_URL | No | Yearning 地址 | http://localhost:8000 |
| MCP_TRANSPORT | No | stdio / sse / streamable-http | stdio |
| MCP_AUTH_TOKEN | No | HTTP Bearer 鉴权令牌 | |
| YEARNING_TIMEOUT | No | 请求超时(秒) | 30 |
| YEARNING_INSECURE | No | 跳过 TLS 校验 | false |
| YEARNING_PASSWORD | Yes | 登录密码 | |
| YEARNING_USERNAME | Yes | 登录用户名 | |
| MCP_STATELESS_HTTP | No | 无状态 HTTP | false |
| YEARNING_READ_ONLY | No | true 时不注册写工具 | false |
| YEARNING_LOGIN_TYPE | No | general / ldap | general |
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
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| resources | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| 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
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| user-info | 当前登录用户信息(已脱敏)与可查询数据源 |
| sources | 当前账号有权限的数据源 |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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