Cover image
Try Now
2025-04-14

3 years

Works with Finder

0

Github Watches

0

Github Forks

0

Github Stars

MCP Server for QuickBooks Online V3 API

A Mock–Capture–Proxy (MCP) server that sits in front of Intuit's QuickBooks Online V3 Accounting API. It can:

Mode Purpose
mock Serve example payloads generated from the OpenAPI spec—design and test without calling Intuit.
proxy Forward validated traffic to Intuit's live or sandbox endpoints (adding the OAuth 2.0 bearer token).
capture Proxy traffic and persist every request/response pair to an ND‑JSON log for replay or analytics.

✨ Key Features

  • OpenAPI‑strict validation – every incoming request is checked against the spec before it leaves your machine.
  • Automatic sample responses – powered by openapi‑backend.
  • One‑line mode switch – choose mock, proxy, or capture via MCP_MODE env var.
  • Stateless design – no database required; capture logs are flat files.
  • 100 % TypeScript – easy to extend and type‑safe.

🛠️ Prerequisites

  • Node.js ≥ 18
  • A local copy of QuickBooksOnlineV3.json (Intuit's OpenAPI definition).
  • (Proxy/Capture only) An OAuth 2.0 access token for QuickBooks Online.

🚀 Getting Started

1  Clone & install

# clone repo (or copy the two source files)
npm i -S express openapi-backend http-proxy-middleware morgan dotenv
npm i -D typescript ts-node @types/node @types/express @types/morgan \
       @types/http-proxy-middleware

2  Place the spec

cp /path/to/QuickBooksOnlineV3.json ./QuickBooksOnlineV3.json

3  Configure environment

Create .env (or export vars) and adjust as needed:

# .env.example
MCP_MODE=mock                # mock | proxy | capture
SPEC_PATH=./QuickBooksOnlineV3.json
PORT=4000
QBO_BASE=https://quickbooks.api.intuit.com
QBO_TOKEN=eyJhbG...          # required in proxy/capture modes

4  Run

# Mock server (no Intuit traffic)
MCP_MODE=mock  npx ts-node mcp-server.ts

# Validating reverse‑proxy
MCP_MODE=proxy QBO_TOKEN=<token> npx ts-node mcp-server.ts

# Proxy + persistent capture
MCP_MODE=capture QBO_TOKEN=<token> npx ts-node mcp-server.ts

You'll see:

🌀 MCP server listening on http://localhost:4000  (mode=mock)

🔗 Local Endpoints

URL Description
GET /health Simple JSON health‑check.
ANY /api/* All QuickBooks API paths (mock/proxy/capture).

Example: GET http://localhost:4000/api/v3/company/YOUR_REAL_COMPANY_ID/customer


📝 Capture Log Format (captures.ndjson)

Each line is a JSON object:

{
  "ts": "2025-04-22T19:34:12.345Z",
  "req": {
    "method": "GET",
    "url": "/api/v3/company/1234/invoice/42",
    "headers": { "authorization": "Bearer …" },
    "body": {}
  },
  "res": {
    "status": 200,
    "body": { "Invoice": { … } }
  }
}

Great for regression tests, analytics, or seeding fixtures.


🧩 Extending & Customising

  1. Schema‑driven fakes – swap c.mock() for Stoplight Prism if you need dynamic values.
  2. Rate limiting – bolt on express-rate-limit or front with Nginx to stay under Intuit's 500 RPM cap.
  3. OAuth auto‑refresh – catch 401s and swap your refresh_token for a new access token automatically.
  4. Typed SDK – generate a client with openapi-generator-cli and import it to enforce compile‑time safety in custom handlers.

🐛 Common Errors & Fixes

Symptom Likely Cause Fix
400 validationFail Request doesn't match spec Double‑check path params, query, body schema
429 Throttle exceeded QuickBooks limit hit Slow down / add exponential back‑off
401 Unauthorized Expired access token Refresh OAuth token and restart or implement auto‑refresh

📄 License

MIT © 2025 Your Name

相关推荐

  • av
  • Exécutez sans effort LLM Backends, API, Frontends et Services avec une seule commande.

  • 1Panel-dev
  • 🔥 1Panel fournit une interface Web intuitive et un serveur MCP pour gérer des sites Web, des fichiers, des conteneurs, des bases de données et des LLM sur un serveur Linux.

  • WangRongsheng
  • 🧑‍🚀 全世界最好的 LLM 资料总结 (数据处理、模型训练、模型部署、 O1 模型、 MCP 、小语言模型、视觉语言模型) | Résumé des meilleures ressources LLM du monde.

  • rulego
  • ⛓️RULEGO est un cadre de moteur de règle d'orchestration des composants de nouvelle génération légère, intégrée, intégrée et de nouvelle génération pour GO.

  • Byaidu
  • PDF Traduction de papier scientifique avec formats conservés - 基于 AI 完整保留排版的 PDF 文档全文双语翻译 , 支持 Google / Deepl / Olllama / Openai 等服务 , 提供 CLI / GUI / MCP / DOCKER / ZOTERO

  • n8n-io
  • Plateforme d'automatisation de workflow à code équitable avec des capacités d'IA natives. Combinez le bâtiment visuel avec du code personnalisé, de l'auto-hôte ou du cloud, 400+ intégrations.

  • sigoden
  • Créez facilement des outils et des agents LLM à l'aide de fonctions Plain Bash / JavaScript / Python.

  • hkr04
  • SDK C ++ MCP (Protocole de contexte modèle léger)

  • RockChinQ
  • 😎简单易用、🧩丰富生态 - 大模型原生即时通信机器人平台 | 适配 QQ / 微信 (企业微信、个人微信) / 飞书 / 钉钉 / Discord / Telegram / Slack 等平台 | 支持 Chatgpt 、 Deepseek 、 Dify 、 Claude 、 GEMINI 、 XAI 、 PPIO 、 OLLAMA 、 LM Studio 、阿里云百炼、火山方舟、 Siliconflow 、 Qwen 、 Moonshot 、 ChatGlm 、 Sillytraven 、 MCP 等 LLM 的机器人 / Agent | Plateforme de bots de messagerie instantanée basés sur LLM, prend en charge Discord, Telegram, WeChat, Lark, Dingtalk, QQ, Slack

  • dmayboroda
  • Rag de conversation sur site avec des conteneurs configurables

    Reviews

    2.6 (13)
    Avatar
    user_NwGi5hNQ
    2025-04-23

    QuickBooks-MCP by OrdinaryKids is a game-changer! It streamlines my accounting with efficiency and ease. The user-friendly interface and powerful features make managing finances a breeze. Highly recommend for anyone looking to simplify their bookkeeping process.

    Avatar
    user_8dEXbxDu
    2025-04-23

    QuickBooks-MCP by OrdinaryKids is an exceptional financial tool that has significantly streamlined my accounting tasks. The interface is user-friendly, making it easy even for those with limited financial knowledge to manage their books efficiently. It offers comprehensive features that cater to all my business needs. Highly recommended for anyone seeking an efficient and reliable accounting solution.

    Avatar
    user_AqTO9an6
    2025-04-23

    As a dedicated user of QuickBooks-MCP by ordinarykids, I must say it's an incredibly efficient tool for managing my accounting needs. It simplifies my bookkeeping with an intuitive interface and robust features. Highly recommended for small business owners!

    Avatar
    user_gwQpDc3X
    2025-04-23

    QuickBooks-MCP by ordinarykids has truly revolutionized my accounting tasks. It’s incredibly user-friendly and efficient, making bookkeeping a breeze. The integration features are seamless, and the support is outstanding. If you’re looking for a reliable accounting tool, this is it! Highly recommended!

    Avatar
    user_U70jJCgv
    2025-04-23

    The quickbooks-mcp by ordinarykids is a game-changer for managing my finances. Its user-friendly interface and seamless integration streamline my bookkeeping tasks efficiently. Whether tracking expenses or generating reports, it’s a reliable tool that saves me both time and effort. Highly recommend!

    Avatar
    user_LxHyj5Ib
    2025-04-23

    As a dedicated user of QuickBooks-MCP, created by Ordinarykids, I can confidently say this tool has transformed my financial management. It's user-friendly and streamlines accounting processes effortlessly. Highly recommended for anyone looking to simplify their bookkeeping tasks!

    Avatar
    user_JjeslHOH
    2025-04-23

    Quickbooks-MCP by Ordinarykids is an incredibly handy tool for managing my accounting needs. Its user-friendly interface and seamless integration make it an essential part of my daily operations. The functionality this app offers far exceeds my expectations, and the support from the team has been top-notch. Highly recommended for anyone seeking a reliable accounting solution!

    Avatar
    user_awzHXP6T
    2025-04-23

    QuickBooks-MCP is an exceptional tool developed by OrdinaryKids. As a devoted user, I find it incredibly efficient for managing my finances and bookkeeping tasks. The interface is user-friendly, making it accessible even for non-accountants. The seamless integration with other financial data sources saves a lot of time and effort. Highly recommended for anyone looking for a reliable and efficient accounting solution!

    Avatar
    user_mKusn3un
    2025-04-23

    QuickBooks-MCP by OrdinaryKids is an incredible tool I use daily. It simplifies my bookkeeping tasks, offering a user-friendly interface that's easy to navigate. This application saves me countless hours each week and helps me keep my finances organized effortlessly. Highly recommend for anyone looking to streamline their accounting process!

    Avatar
    user_TQfzrThY
    2025-04-23

    QuickBooks-MCP by OrdinaryKids is a game-changer for anyone managing multiple clients financials. The interface is user-friendly, making it easy to track expenses, generate reports, and handle payroll with precision. Thanks to its seamless integration, my workload has significantly reduced, allowing me to focus more on client relationships. Highly recommended!

    Avatar
    user_arJh1GyW
    2025-04-23

    As a dedicated user of quickbooks-mcp by ordinarykids, I am incredibly impressed with its seamless integration and powerful features. It has significantly streamlined our accounting processes, saving us both time and money. The user-friendly interface and thorough support make it a must-have for any business looking to simplify their financial management. Highly recommend!

    Avatar
    user_nOz6n2If
    2025-04-23

    As a loyal user of quickbooks-mcp by ordinarykids, I must say it has revolutionized how I manage my finances. Its intuitive interface and robust features make bookkeeping a breeze, tailored perfectly for my needs. Highly recommend it to anyone seeking reliable financial management software!

    Avatar
    user_KdmS5Yvm
    2025-04-23

    QuickBooks-MCP by ordinarykids is simply outstanding. As a regular user, I find it incredibly intuitive and efficient for managing my finances. Its seamless integration and detailed tracking have made my accounting tasks much easier. Highly recommended for anyone looking to simplify their financial processes!