
U2 MCP Server
io.github.bpamiri由 GitHub 账号 bpamiri 发布v0.1.1更新于 Oct 27, 2026
Connect AI assistants to Rocket Universe/UniData MultiValue databases via MCP.
概览
让 AI 助手连接 Rocket Universe/UniData MultiValue 数据库,用自然语言查询、读取和修改记录。
- 可以做什么
- 连接、断开并查看与 Universe/UniData 服务器的连接
- 列出文件,读取单条或多条记录,写入和删除记录,获取文件统计
- 执行 RetrieVe/UniQuery 语句、TCL/ECL 命令和 SELECT 列表
- 浏览字典:列出字典项、查看字段定义、描述文件结构
- 调用已编目的 BASIC 子程序,并用开始、提交、回滚管理事务
- 保存、列出、搜索和删除关于数据库的知识笔记,跨会话保留
- 适用场景
- 适合需要让助手操作 Pick/MultiValue 数据库的场景,例如探索文件结构、回答记录相关问题或执行查询,而无需手写 RetrieVe 语法。也适合希望集中部署连接并共享数据库结构知识的团队。
- 运行要求
- 本地 Python 3.10+ 进程,通过 pip 或 uvx 运行,uopy 包会作为依赖自动安装。需要能访问 Universe 或 UniData 服务器的网络,并设置环境变量 U2_HOST、U2_USER、U2_PASSWORD 和 U2_ACCOUNT,另有 U2_SERVICE、U2_PORT、U2_SSL 等可选配置。文档还介绍了 HTTP/SSE 模式和基于 OAuth 的部署方式。
安装
在 SourceWeft 中
- 打开 控制台中的 U2 MCP Server,将其添加到工作区。
- 为需要使用其工具的对话启用该服务。
Desktop only,通过 STDIO。 STDIO 服务会启动本地进程,因此需要 SourceWeft 桌面宿主。
其他 MCP 客户端
参照 仓库 中的启动说明。
README
u2-mcp
[PyPI version] [License] [Python] [MCP]
Connect Claude to your Universe/UniData database using natural language.
u2-mcp is an MCP server that lets AI assistants like Claude query and interact with Rocket Universe and UniData MultiValue databases. Ask questions in plain English and get real answers from your data.
The first MCP server for the Pick/MultiValue database family.
What Can You Do With This?
Instead of writing RetrieVe queries, just ask Claude:
How It Works
- You ask Claude a question about your database
- Claude calls u2-mcp with the appropriate tool
- u2-mcp queries your Universe/UniData server
- Results come back through Claude in a readable format
New to MCP? See What is MCP? for a complete explanation.
Documentation
Features
- Connection Management - Connect to Universe/UniData servers with connection pooling and SSL support
- File Operations - Read, write, and delete records while preserving MultiValue semantics
- Query Execution - Run RetrieVe/UniQuery statements with safety controls
- Dictionary Access - Explore file structures and field definitions
- BASIC Subroutine Calls - Execute cataloged BASIC programs
- Transaction Support - Full transaction management with commit/rollback
- AI-Optimized - Built-in query examples and syntax help for better LLM interactions
Installation
Or using uvx for isolated execution:
Quick Start
Prerequisites
- Python 3.10+
- Access to a Rocket Universe or UniData server
- The
uopypackage (installed automatically as a dependency)
Configuration
Set environment variables for your database connection:
Claude Desktop Configuration
Add to your claude_desktop_config.json:
Usage Examples
Once connected, you can use natural language to interact with your Universe database:
- "List all customers in California"
- "Read record CUST001 from the CUSTOMERS file"
- "Show me the dictionary for the ORDERS file"
- "Count all open invoices over $1000"
Available Tools
Connection Management
connect- Establish connection to Universe/UniData serverdisconnect- Close connectionslist_connections- Show active connections
File Operations
list_files- List available files in the accountread_record- Read a single record by IDread_records- Read multiple recordswrite_record- Write/update a recorddelete_record- Delete a recordget_file_info- Get file statistics
Query Execution
execute_query- Run RetrieVe/UniQuery statementsexecute_tcl- Run TCL/ECL commandsget_select_list- Execute SELECT and return record IDs
Dictionary Access
list_dictionary- List dictionary itemsget_field_definition- Get field detailsdescribe_file- High-level file description
Advanced Features
call_subroutine- Call BASIC subroutinesbegin_transaction/commit_transaction/rollback_transaction- Transaction management
Knowledge Persistence
save_knowledge- Save learned information about the databaselist_knowledge- List all saved knowledge topicsget_knowledge_topic- Retrieve specific topicsearch_knowledge- Search across saved knowledgedelete_knowledge- Remove a knowledge topic
Configuration Options
Knowledge Persistence
The MCP server includes a knowledge persistence feature that allows Claude to save and recall learned information about your database across sessions. This eliminates repetitive discovery work and speeds up future interactions.
How It Works
When Claude discovers useful information about your database (file purposes, field meanings, working queries), it can save this knowledge using the save_knowledge tool. This information is stored in a markdown file and automatically available in future conversations via the u2://knowledge resource.
What Gets Saved
- File descriptions - What each file contains (e.g., "AR-CUST is the customer master file")
- Field mappings - Which fields contain what data (e.g., "Field 1 is customer name")
- Query patterns - Queries that produced good results
- Data formats - Date formats, code meanings, conversion notes
- Relationships - How files relate to each other
Storage Location
Knowledge is stored in ~/.u2-mcp/knowledge.md by default. You can customize this location using the U2_KNOWLEDGE_PATH environment variable:
Example Usage
After Claude discovers that AR-CUST contains customer records:
In the next conversation, Claude will already know this and won't need to rediscover it.
Centralized Deployment (HTTP/SSE Mode)
For team environments, you can run u2-mcp as a centralized HTTP server instead of local stdio mode. This allows:
- Single database connection for the whole team
- Shared knowledge base
- Centralized credential management
- Access from any MCP-compatible client
Running the HTTP Server
Docker Deployment
HTTP Configuration Options
Connecting Clients
The HTTP server exposes an SSE (Server-Sent Events) endpoint at /sse. MCP clients that support remote servers can connect to:
Note: As of late 2024, Claude Desktop only supports local stdio MCP servers. HTTP/SSE mode is for:
- Custom MCP clients
- Future Claude Desktop versions with remote server support
- Integration with other AI tools that support MCP over HTTP
Claude.ai Integration (Streamable HTTP + OAuth)
Deploy u2-mcp as a Custom Connector in Claude.ai with enterprise authentication via your identity provider (Duo, Auth0, Okta, etc.).
Quick Setup
- Deploy u2-mcp with OAuth enabled:
- Configure OAuth in your
.env:
- Add to Claude.ai: Go to Settings → Connectors → Add Custom Connector → Enter your URL
Users authenticate through your IdP and can then query your database directly from Claude.ai.
Supported Identity Providers
- Cisco Duo - Enterprise MFA and SSO
- Auth0 - Flexible identity platform
- Any OIDC Provider - Okta, Azure AD, Google Workspace, Keycloak, etc.
See the OAuth Guide for detailed setup instructions.
Security
- Credentials are never logged
- Configurable command blocklist prevents dangerous operations
- Optional read-only mode for safe exploration
- Honors Universe's built-in security model
See SECURITY.md for reporting security vulnerabilities.
Contributing
We welcome contributions! Please see CONTRIBUTING.md for guidelines.
Documentation
Getting Started
- Quickstart Guide - Get running in 10 minutes
- What is MCP? - Understanding MCP and how u2-mcp works
- Installation Guide - Detailed installation instructions
Reference
- Configuration Reference - All environment variables
- Tools Reference - Complete tool documentation
- Usage Examples - Common usage patterns
- OAuth & Claude.ai Integration - Deploy as a Claude.ai Custom Connector
License
This project is licensed under the Apache License 2.0 - see the LICENSE file for details.
Acknowledgments
- Rocket Software for the
uopypackage - Anthropic for the Model Context Protocol specification
- The MultiValue database community
来源:README.md,提交 f427768
工具
0版本历史
1- v0.1.1最新Sep 16, 2026
评分
已满足适用检查项的 50%
该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。
- 近 30 天内可连通25 分
请保持端点能够响应 MCP 握手;SourceWeft 每 30 天探测一次。
- 已声明认证方式10 分
请在注册中心条目中声明凭据请求头,或保持端点能够响应探测,以便判定其认证方式。
- 已列出工具15 分
请让服务器在无凭据时响应 tools/list,或发布可在沙箱中无凭据启动的软件包。
- 描述必需15 分
- 图标10 分
- 文档15 分
- 许可证10 分