@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 |
Capabilities
Features and capabilities supported by this server
| 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