| name | gnucash-mcp-connector |
| description | MCP connector for GnuCash accounting – enables AI-powered bookkeeping, report generation, and financial management through Claude |
| license | GPL |
| tags | ["business","accounting","mcp","gnucash","finance"] |
| difficulty | intermediate |
| time_to_master | 4-8 weeks |
| version | 1.0.0 |
Gnucash MCP Connector
Overview
This skill enables Claude to interact with Gnucash through the Model Context Protocol (MCP). It provides a bridge between Claude's AI capabilities and Gnucash's Python bindings/CLI, allowing natural language control of Gnucash operations, intelligent automation, and AI-powered assistance for Gnucash workflows.
When to Use This Skill
- Transaction entry and categorization via AI
- Report generation (P&L, Balance Sheet)
- Account hierarchy management
- Scheduled transaction configuration
- Tax preparation and reporting assistance
Architecture
┌─────────────┐ ┌─────────────────┐ ┌──────────────────┐
│ Claude │────▶│ MCP Server │────▶│ Gnucash │
│ (Client) │◀────│ (Python/TypeScript) │◀────│ (Python binding)│
└─────────────┘ └─────────────────┘ └──────────────────┘
Core Concepts
MCP Server Setup
The connector implements an MCP server that exposes Gnucash operations as tools Claude can invoke. The server translates natural language intentions into Python bindings/CLI calls.
Key Endpoints/Interfaces
gnucash.Session, gnucash.Book, gnucash.Account, gnucash.Transaction, gnucash.Split
Implementation
import { McpServer } from "@modelcontextprotocol/sdk/server/mcp.js";
import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js";
import { z } from "zod";
const server = new McpServer({
name: "gnucash-mcp-connector",
version: "1.0.0",
});
server.tool(
"list_resources",
"List and query Gnucash resources with optional filters",
{
query: z.string().optional().describe("Search query or filter"),
limit: z.number().optional().describe("Max results to return"),
},
async ({ query, limit }) => {
const response = await fetch(`${BASE_URL}gnucash.Session`, {
headers: { "Authorization": `Bearer ${API_KEY}` },
});
const data = await response.json();
return {
: [{ : , : .(data, , ) }],
};
}
);
server.(
,
,
{
: z.().(),
: z.({}).().().(),
},
({ name, config }) => {
response = (, {
: ,
: {
: ,
: ,
},
: .({ name, ...config }),
});
data = response.();
{
: [{ : , : }],
};
}
);
server.(
,
,
{
: z.().(),
: z.().().(),
},
({ , timeframe }) => {
response = (, {
: { : },
});
data = response.();
{
: [{ : , : .(data, , ) }],
};
}
);
transport = ();
server.(transport);
Claude Desktop Configuration
{
"mcpServers": {
"gnucash-mcp-connector": {
"command": "node",
"args": ["path/to/gnucash-mcp-connector/index.js"],
"env": {
"GNUCASH_API_KEY": "your-api-key",
"GNUCASH_BASE_URL": "https://your-instance-url"
}
}
}
}
Best Practices
- Authentication: Store API keys securely using environment variables; never hardcode credentials
- Rate Limiting: Implement request throttling to respect Gnucash API rate limits
- Error Handling: Provide clear, actionable error messages for common failure scenarios
- Pagination: Handle paginated responses for large datasets efficiently
- Caching: Cache frequently accessed read-only data to reduce API calls
- Security: Validate all inputs before passing to the Gnucash API; sanitize outputs
- Logging: Log all API interactions for debugging and audit purposes
Example Prompts
"Generate a quarterly balance sheet and highlight accounts with unusual activity"
Security Considerations
- All API credentials must be stored as environment variables
- Implement input validation and sanitization for all tool parameters
- Use HTTPS for all API communications
- Follow the principle of least privilege for API token permissions
- Audit log all write operations for compliance tracking
Resources
Changelog
| Version | Date | Changes |
|---|
| 1.0.0 | 2026-04-01 | Initial MCP connector skill |
Part of SkillGalaxy - 10,000+ comprehensive skills for AI-assisted development.
