Beanquery MCP Server
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.
Beanquery MCP
The Beancount MCP Server is an experimental implementation of the Model Context Protocol (MCP) designed to interface with Beancount ledger files. Leveraging the Beancount Query Language (BQL) and the beanquery tool, this server enables seamless querying and analysis of financial data stored in Beancount format. By integrating MCP, the server facilitates standardized communication between AI assistants and Beancount ledgers, enhancing the accessibility and utility of financial data.
Note: This server is experimental and may undergo significant changes. It is recommended to use it in a development environment and provide feedback for further improvements.
A generated sample ledger can be found in sample.bean
Available Resources and Tools
Tools:
set_ledger_file: Set the Beancount ledger file to use for queries (if not set via environment variable).run_query: Run a BQL query against the loaded Beancount file.
Resources:
beanquery://tables: Get a list of tables that BQL can access.beanquery://accounts: Get a list of accounts in the loaded Beancount file.
Example using Claude.ai

For a screenshot with expanded MCP interactions, see here.
Related MCP server: YNAB MCP Server
⚠️ Privacy Warning
This tool interfaces with language model providers (LLMs) via the Model Context Protocol (MCP), and as such may transmit parts of your Beancount ledger—including potentially confidential or private financial information—to third-party services.
Please use this tool with caution, especially when:
Your ledger contains sensitive data (e.g., client names, salary details, health-related expenses).
You are using a cloud-hosted or non-self-hosted LLM backend.
Recommendations:
Mask or redact sensitive data in test ledgers.
Use self-hosted LLMs when possible.
Review the data being sent via MCP to ensure compliance with your privacy and security requirements.
You are responsible for the protection of your financial data. Do not share ledgers you would not be comfortable exposing.
Setup
Prerequisites
Python 3.10 or later
uv for managing Python projects (recommended)
Usage
Running the Server
Development Mode: Use the MCP Inspector to test and debug your server:
mcp dev server.pyClaude Desktop Integration: Install the server into Claude Desktop:
mcp install server.pyQuick Start:
uv run mcp install server.py -v BEANCOUNT_LEDGER=$(pwd)/sample.bean --with beancount --with beanqueryCustom Name:
uv run mcp install server.py --name "Beanquery MCP Server" --with beancount --with beanqueryEnvironment Variables:
uv run mcp install server.py -v BEANCOUNT_LEDGER=/path/to/your/ledger.bean --with beancount --with beanquery uv run mcp install server.py -f .env --with beancount --with beanquery
Testing
Run the test suite using pytest:
pytest server_test.pyContributing
Fork the repository.
Create a feature branch:
git checkout -b feature-nameCommit your changes:
git commit -m "Add feature description"Push to your branch:
git push origin feature-nameOpen a pull request.
License
This project is licensed under the MIT License. See the LICENSE file for details.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Related MCP Connectors
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
A Model Context Protocol server for Wix AI tools
Read-only finance MCP server. Connects your banks, cards, payment apps, books and payroll into one ledger for your AI. Can't move money. Open source (AGPL-3.0), free during beta.
Financial data MCP server for Claude, ChatGPT, Cursor and Codex. Real-time stock quotes, financial statements, options flow, SEC filings, insider trades, 13F holdings, macro data and market news from gloom.sh, the open-source Bloomberg Terminal alternative.
Related MCP Servers
- AlicenseCqualityDmaintenanceA Model Context Protocol server that allows AI assistants to query and analyze financial data through Ledger CLI, enabling tasks like financial reporting, budget analysis, and accounting.951MIT
- AlicenseAqualityAmaintenanceA Model Context Protocol server that enables AI-powered interaction with YNAB (You Need A Budget) data, allowing users to query their budgets through conversational interfaces.22527 npm168MIT
- FlicenseNot gradedqualityCmaintenanceA read-only MCP server that gives AI agents structured access to a Beancount personal finance ledger.1-
- AlicenseAqualityCmaintenanceAn MCP server for querying Beancount ledgers using natural language, enabling financial analysis through Claude with tools for BQL queries and ledger validation.23MIT