Quicken MCP Server

A containerized MCP (Model Context Protocol) server that converts a local export of Quicken in Quicken Interchange Format (QIF) files into a queryable DuckDB database, exposing financial data through standardized MCP tools to LLM Clients.

Features

• QIF Import: Parse and normalize Quicken QIF files into structured database tables
• In-Memory Database: Uses DuckDB for fast, SQL-compatible data access
• MCP Tools: Exposes financial data through standardized MCP tools including:
  • list_accounts - List all accounts with balances
  • list_transactions - Query transactions with flexible filtering
  • run_sql - Execute safe SQL queries against the data
  • get_summaries - Generate financial summaries and statistics
  • get_categories - List transaction categories
  • search_transactions - Search transactions by text
• Multiple Transports: Supports both stdio and Server-Sent Events (SSE) protocols
• Security: SQL queries are restricted to SELECT operations only
• Resources: Export data as CSV files through MCP resources

TLDR: Talk to your Quicken data in ChatGPT, Claude or ollama!


Quick Start

Using Docker (Recommended)

1. Build the container:

   docker build -t quicken-mcp-server .
   

2. Register the MCP in your LLM client config

   Example of claude-desktop-config.json entry:

       "quicken-mcp": {
         "command": "docker",
         "args": [
           "run",
           "-i",
           "--rm",
           "-v",
           "<path>/data:/data:ro",
           "quicken-mcp-server",
           "--qif",
           "/data/personal-data.qif"
         ],
         "env": {}
       }
   

   In this example, I have exported my quicken data into the QIF format and named it "personal-data.qif". I then placed it into a folder called "data" and made that folder available to the docker image as a volume also named "data".

Local Development

1. Install dependencies:

   pip install -r requirements.txt
   

2. Run locally:

   python -m app.main --qif /path/to/your/file.qif
   

Usage Examples

Command Line Options

python -m app.main --help

Required:

• --qif PATH - Path to the QIF file to load

Optional:

• --server-mode {stdio,sse} - Transport mode (default: stdio)
• --listen HOST:PORT - Listen address for SSE mode (default: 127.0.0.1:8700)
• --log-level {DEBUG,INFO,WARNING,ERROR} - Log level (default: INFO)
• --memory-limit SIZE - DuckDB memory limit (default: 8GB)

Environment Variables

You can also configure using environment variables:

• QIF_PATH - Path to QIF file
• SERVER_MODE - Transport mode
• LOG_LEVEL - Logging level
• MEMORY_LIMIT - Memory limit

Docker Examples

Basic usage with bind mount:

docker run --rm \
  -v "$PWD/data:/data:ro" \
  --network host \
  quicken-mcp --qif /data/example-file.qif

SSE mode with custom port:

docker run --rm \
  -v "$PWD/data:/data:ro" \
  -p 8700:8700 \
  quicken-mcp \
  --qif /data/example-file.qif \
  --server-mode sse \
  --listen 0.0.0.0:8700

MCP Tools Reference

list_accounts

Returns all accounts with metadata:

{
  "success": true,
  "accounts": [
    {
      "account_id": 1,
      "name": "Checking Account",
      "type": "Bank",
      "balance": 1234.56
    }
  ]
}

list_transactions

Query transactions with optional filters:

{
  "account_type": "Bank",
  "date_from": "2023-01-01",
  "date_to": "2023-12-31",
  "category": "Food",
  "limit": 50
}

run_sql

Execute SELECT queries:

{
  "query": "SELECT category, SUM(amount) FROM transactions WHERE date >= '2023-01-01' GROUP BY category ORDER BY SUM(amount) DESC LIMIT 10"
}

get_summaries

Generate financial summaries:

{
  "period": "month"  // Options: "month", "category

... [View full README on GitHub](https://github.com/sgoley/quicken-mcp-server#readme)