A
licenseB
qualityD
maintenanceAn MCP server that provides comprehensive Excel file operations, data analysis, and visualization capabilities for working with various spreadsheet formats like XLSX, CSV, and JSON.
8
44 PyPI
95
MIT
Abacus
by Enthusiasm23
Allows converting Excel data to and from Markdown format.
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.
🧮 Abacus（算盘）
🎯 本地 Excel 自动化框架，以中国算学文化为命名体系
📊 项目状态
指标 | 数值 |
🎯 核心能力 | 103 个 |
🧪 测试用例 | 1136 个（全部通过） |
🔧 MCP 工具 | 107 个 |
📝 CLI 命令 | 100+ 个 |
📚 知识库文件 | 38 个 |
📈 测试覆盖率 | 88% |
Related MCP server: Excel MCP Server
✨ 特性
🏛️ 九章分类体系 - 方田、粟米、衰分、少广、商功、均输、盈不足、方程、勾股
🔧 三入口 - CLI + MCP Server + Python 库
🤖 AI 友好 - 完整的 SKILL.md 文档
🌐 中英文支持 - i18n 国际化
📝 结构化日志 - 可配置日志级别
🔒 安全可靠 - 路径遍历检查、ReDoS 防护、公式注入防护
🚀 快速开始
安装
pip install abacus-excelCLI 使用
# 查看帮助
abacus --help
# 读取数据
abacus read -f data.xlsx -s Sheet1 -r A1:D10
# 查看结构
abacus structure -f data.xlsx
# 转换格式
abacus convert-format -f data.xlsx -s Sheet1 -r A1:A100 -t numberPython 库使用
from abacus import MeasureRangeCapability, CapabilityRegistry
# 读取数据
cap = MeasureRangeCapability()
result = cap.execute(None, file="data.xlsx", sheet="Sheet1", range="A1:D10")
print(result)MCP Server 使用
# 启动 MCP Server
python -m abacus.mcp_server🏛️ 九章分类
章节 | 能力数 | 说明 |
📖 方田章 | 10 | 数据读取、单元格操作、工作表管理 |
🔄 粟米章 | 10 | 格式转换、数据清洗、转置、分列 |
📊 衰分章 | 4 | 分组、分配、汇总、分类汇总 |
🔢 少广章 | 5 | 数学计算、反向推导、解方程 |
⚙️ 商功章 | 25 | 批量操作、图表管理、格式化、筛选 |
📤 均输章 | 7 | 导入导出、迁移、合并 |
✅ 盈不足章 | 8 | 数据验证、文件验证、质量检查 |
📐 方程章 | 5 | 公式创建、诊断、重算、生成 |
📈 勾股章 | 12 | 统计分析、趋势分析、数据可视化 |
📁 项目结构
abacus/
├── src/abacus/ # 核心代码
│ ├── core/ # 九章能力
│ ├── cli.py # CLI 入口
│ └── mcp_server.py # MCP Server
├── tests/ # 测试（1136 个）
├── skills/ # SKILL.md 文档
├── docs/ # API 文档
└── examples/ # 使用示例📚 文档
📄 许可证
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
ActivityInactive
ResponsivenessNo recent community issues
Related MCP Connectors
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Let AI agents read, check and edit Excel models. Open a workbook or drop in one MCP config. Either way: typed cells, a formula dependency graph, and a verification certificate. Deterministic — no OCR, no model guessing at your numbers.
Generate, edit, merge, translate and PDF-convert PowerPoint (.pptx) over MCP. 8 tools.
Microsoft Ads MCP server: 11 tools for search, PMax, Google Ads imports. Read-only by default.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP server for manipulating Excel files that features a headless engine for real-time formula calculation and data validation. It enables users to create, read, and manage workbooks, sheets, and charts without requiring Microsoft Excel installed.24 npmMIT
- FlicenseNot gradedqualityDmaintenanceAn MCP server that enables AI agents to automate Excel file operations including workbook creation, worksheet management, and data manipulation. It provides a standardized interface for reading, writing, merging, and filtering cell ranges within Excel documents.4-
- AlicenseAqualityCmaintenanceMCP server for reading and inspecting local Excel files (.xlsx, .xlsm, .xls, .xlsb, .ods) with tools for inspecting metadata, reading ranges, and profiling structure.39 npmMIT