OA-MCP
Provides read-only, parameterized-SQL access to Weaver Ecology (泛微 OA) settlement data stored in MySQL tables with pinyin column names, exposing semantic dataset listing and settlement-record queries (e.g. settlement amounts, application dates) with PII redaction, rate limiting and audit, and no raw SQL execution.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
OA-MCP
✨ Highlights
OA-MCP = a read-only, semantic, multi-tenant MCP layer over Weaver Ecology settlement tables.
6 read-only tools — no
execute_sql; parameterized SQL only.Dual-era MCP — 2026-07-28 modern and 2025 legacy stateless.
Enterprise auth — API Key (hashed) and optional OAuth 2.1 JWT.
Safe by default — PII redaction, untrusted-content labeling, audit, rate limit.
Honest status —
statusVerified:falsebecause workflow tables are not accessible.
Related MCP server: Laravel MCP Gateway
Overview
Weaver Ecology stores settlement data in MySQL with pinyin column names and no comments. OA-MCP adds a semantic, read-only, multi-tenant MCP layer so Codex / Claude Code / WorkBuddy / DeepSeek Harness can query it safely.
Bring the agent you already use
Agent | How to connect |
WorkBuddy | Sidebar → Plugins → MCP Servers → Configure MCP |
Codex CLI / IDE |
|
Claude Code |
|
DeepSeek Harness | Cordis overlay YAML |
Doubao / Qwen | See CLIENTS.md |
Quick Start
Let your agent install it
Send this to your agent:
请按照 https://raw.githubusercontent.com/xuboboo/oa-mcp/main/AGENT_INSTALL.md 的说明,在本机为我配置并连接 OA-MCP(默认用本地 stdio 模式,不需要服务地址或 API Key)。如果我已经明确告诉你我有部署好的服务地址和密钥,才用远程模式。配置完确认工具可见并调用 list_datasets 验证。git clone https://github.com/xuboboo/oa-mcp.git
cd oa-mcp
npm install
cp .env.example .env
npx tsx src/cli/index.ts doctor
npm run build && npm run startWorkBuddy one-line install
请按照 https://raw.githubusercontent.com/xuboboo/oa-mcp/main/AGENT_INSTALL.md 的说明,在 WorkBuddy 中为本机配置并连接 OA-MCP(默认本地 stdio 模式,不需要服务地址或 API Key;只有我明确提供部署地址和密钥时才用远程模式),配置后用 list_datasets 验证。Try a task
列出可用 OA 数据集,然后查询最近 2 条结算单,说明每条的结算金额与申请日期。Documentation
See the full documentation index and the Chinese README_CN.md.
Goal | Doc |
Agent install | |
Full install + WorkBuddy | |
Clients | |
API | |
Deployment | |
Testing |
For developers
npm install && npm run typecheck && npm run test && npm run build
node scripts/stress50.mjsSee ARCHITECTURE.md and TECH-STACK.md.
License
Proprietary. See LICENSE.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
A paid remote MCP for AI SDK data query MCP, built to return verdicts, receipts, usage logs, and aud
MCP gateway: one connection for your AI apps, with tool policies, PII redaction and audit logs.
Zero-setup MCP gateway securely connecting AI to your tools with authentication and workflows
Verified, pay-per-use API tools for AI agents through one authenticated connection.
Related MCP Servers
- FlicenseAqualityDmaintenanceEnables read-only access to Kingdee Cloud Star financial data, invoice tax calculation, and generation of reimbursement draft payloads through MCP tools.17-
- AlicenseNot gradedqualityCmaintenanceProvides an OAuth-protected, scoped, and audited MCP server that lets AI assistants safely query business data through a fixed set of tools without direct database access.1MIT
- FlicenseNot gradedqualityAmaintenanceEnables Claude, Cursor, Windsurf, Cline and other MCP-compatible AI assistants to query and operate Kingdee Cloud Star ERP through natural language, covering purchasing, sales, inventory, production, cost, fixed assets, financial reports, and approval workflows across 87 tools. Supports bill creation, submission, auditing, and metadata/ database exploration via official WebAPI account-password authentication for both public and private clouds.-
- FlicenseNot gradedqualityAmaintenanceEnables Claude, Cursor, and other AI assistants to query and operate Kingdee Cloud Star ERP in natural language through MCP tools. It supports purchasing, sales, inventory, finance, production, costs, assets, auditing, workflow, and metadata operations.-