Server data from the Official MCP Registry
Connect AI assistants to Rocket Universe/UniData MultiValue databases via MCP.
Connect AI assistants to Rocket Universe/UniData MultiValue databases via MCP.
Valid MCP server (1 strong, 4 medium validity signals). 3 known CVEs in dependencies (0 critical, 2 high severity) Package registry verified. Imported from the Official MCP Registry.
5 files analyzed · 4 issues found
Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.
This plugin requests these system permissions. Most are normal for its category.
Set these up before or after installing:
Environment variable: U2_HOST
Environment variable: U2_USER
Environment variable: U2_PASSWORD
Environment variable: U2_ACCOUNT
Environment variable: U2_SERVICE
Environment variable: U2_PORT
Environment variable: U2_SSL
Environment variable: U2_READ_ONLY
Environment variable: U2_MAX_RECORDS
Environment variable: U2_BLOCKED_COMMANDS
Add this to your MCP configuration file:
{
"mcpServers": {
"io-github-bpamiri-u2-mcp": {
"env": {
"U2_SSL": "your-u2-ssl-here",
"U2_HOST": "your-u2-host-here",
"U2_PORT": "your-u2-port-here",
"U2_USER": "your-u2-user-here",
"U2_ACCOUNT": "your-u2-account-here",
"U2_SERVICE": "your-u2-service-here",
"U2_PASSWORD": "your-u2-password-here",
"U2_READ_ONLY": "your-u2-read-only-here",
"U2_MAX_RECORDS": "your-u2-max-records-here",
"U2_BLOCKED_COMMANDS": "your-u2-blocked-commands-here"
},
"args": [
"u2-mcp"
],
"command": "uvx"
}
}
}From the project's GitHub README.
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.
Instead of writing RetrieVe queries, just ask Claude:
| You Ask | Claude Does |
|---|---|
| "How many customers are in California?" | Queries the database and tells you "1,247 customers" |
| "Show me order ORD001" | Reads the record and displays all fields |
| "What files are available?" | Lists all files in your account |
| "Describe the CUSTOMERS file" | Shows field definitions from the dictionary |
┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐
│ Claude Desktop │◄───►│ u2-mcp │◄───►│ Universe/UniData│
│ (You ask here) │ │ (Translates) │ │ (Your data) │
└─────────────────┘ └─────────────────┘ └─────────────────┘
New to MCP? See What is MCP? for a complete explanation.
| Guide | Description |
|---|---|
| What is MCP? | Understanding MCP and how u2-mcp works |
| Installation | Complete installation guide |
| Quickstart | Get running in 10 minutes |
| Configuration | All configuration options |
| Tools Reference | Detailed tool documentation |
| Usage Examples | Common usage patterns |
| OAuth Setup | Claude.ai integration with SSO |
pip install u2-mcp
Or using uvx for isolated execution:
uvx u2-mcp
uopy package (installed automatically as a dependency)Set environment variables for your database connection:
export U2_HOST=server.example.com
export U2_USER=username
export U2_PASSWORD=password
export U2_ACCOUNT=MYACCOUNT
export U2_SERVICE=uvcs # or 'udcs' for UniData
Add to your claude_desktop_config.json:
{
"mcpServers": {
"u2": {
"command": "uvx",
"args": ["u2-mcp"],
"env": {
"U2_HOST": "server.example.com",
"U2_USER": "user",
"U2_PASSWORD": "password",
"U2_ACCOUNT": "MYACCOUNT"
}
}
}
}
Once connected, you can use natural language to interact with your Universe database:
connect - Establish connection to Universe/UniData serverdisconnect - Close connectionslist_connections - Show active connectionslist_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 statisticsexecute_query - Run RetrieVe/UniQuery statementsexecute_tcl - Run TCL/ECL commandsget_select_list - Execute SELECT and return record IDslist_dictionary - List dictionary itemsget_field_definition - Get field detailsdescribe_file - High-level file descriptioncall_subroutine - Call BASIC subroutinesbegin_transaction / commit_transaction / rollback_transaction - Transaction managementsave_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| Variable | Description | Default |
|---|---|---|
U2_HOST | Server hostname or IP | Required |
U2_USER | Username | Required |
U2_PASSWORD | Password | Required |
U2_ACCOUNT | Account name | Required |
U2_SERVICE | Service type (uvcs or udcs) | uvcs |
U2_PORT | Server port | 31438 |
U2_SSL | Enable SSL | false |
U2_TIMEOUT | Connection timeout (seconds) | 30 |
U2_READ_ONLY | Disable write operations | false |
U2_MAX_RECORDS | Maximum SELECT results | 10000 |
U2_BLOCKED_COMMANDS | Comma-separated blocked TCL commands | DELETE.FILE,CLEAR.FILE |
U2_KNOWLEDGE_PATH | Custom path for knowledge file | ~/.u2-mcp/knowledge.md |
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.
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.
Knowledge is stored in ~/.u2-mcp/knowledge.md by default. You can customize this location using the U2_KNOWLEDGE_PATH environment variable:
{
"env": {
"U2_KNOWLEDGE_PATH": "/path/to/custom/knowledge.md"
}
}
After Claude discovers that AR-CUST contains customer records:
Claude: I found that AR-CUST is the customer master file. Let me save this for future reference.
[Calls save_knowledge("AR-CUST file", "Customer master file. Key is customer number. Field 1=name, Field 2=address...")]
In the next conversation, Claude will already know this and won't need to rediscover it.
For team environments, you can run u2-mcp as a centralized HTTP server instead of local stdio mode. This allows:
# Basic HTTP server on default port 8080
u2-mcp --http
# Custom host and port
u2-mcp --http --host 0.0.0.0 --port 3000
# Or using environment variables
export U2_HTTP_HOST=0.0.0.0
export U2_HTTP_PORT=3000
u2-mcp --http
FROM python:3.12-slim
RUN pip install u2-mcp
ENV U2_HOST=your-universe-server
ENV U2_USER=username
ENV U2_PASSWORD=password
ENV U2_ACCOUNT=MYACCOUNT
ENV U2_HTTP_PORT=8080
EXPOSE 8080
CMD ["u2-mcp", "--http"]
docker build -t u2-mcp-server .
docker run -p 8080:8080 u2-mcp-server
| Variable | Description | Default |
|---|---|---|
U2_HTTP_HOST | Host to bind HTTP server to | 0.0.0.0 |
U2_HTTP_PORT | Port for HTTP server | 8080 |
U2_HTTP_CORS_ORIGINS | Allowed CORS origins (comma-separated or *) | * |
The HTTP server exposes an SSE (Server-Sent Events) endpoint at /sse. MCP clients that support remote servers can connect to:
http://your-server:8080/sse
Note: As of late 2024, Claude Desktop only supports local stdio MCP servers. HTTP/SSE mode is for:
Deploy u2-mcp as a Custom Connector in Claude.ai with enterprise authentication via your identity provider (Duo, Auth0, Okta, etc.).
u2-mcp --streamable-http --host 0.0.0.0 --port 8080
.env:U2_AUTH_ENABLED=true
U2_AUTH_ISSUER_URL=https://u2-mcp.example.com
U2_IDP_PROVIDER=duo
U2_IDP_DISCOVERY_URL=https://sso-xxx.sso.duosecurity.com/oidc/CLIENT_ID/.well-known/openid-configuration
U2_IDP_CLIENT_ID=your_client_id
U2_IDP_CLIENT_SECRET=your_client_secret
Users authenticate through your IdP and can then query your database directly from Claude.ai.
See the OAuth Guide for detailed setup instructions.
See SECURITY.md for reporting security vulnerabilities.
We welcome contributions! Please see CONTRIBUTING.md for guidelines.
This project is licensed under the Apache License 2.0 - see the LICENSE file for details.
uopy packageBe the first to review this server!
by Modelcontextprotocol · Developer Tools
Read, search, and manipulate Git repositories programmatically
by Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
by mcp-marketplace · Developer Tools
Create, build, and publish Python MCP servers to PyPI — conversationally.