Back to all days

Day 22 — MCP Integration

Wealth Management Portfolio Tracker

Your client calls. “How's my portfolio doing?” You open four tabs, three spreadsheets, and a PDF.

An MCP server that tracks client portfolios across accounts, custodians, and asset classes. Holdings, allocation drift, risk analysis, transaction history, and alerts — all from one question instead of four systems.

Example Queries

“Show me all clients managed by David Park”
“Pull up Margaret Chen's full portfolio with allocation drift”
“What are the top concentration risks across all clients?”
“Show me all dividend transactions from the last 30 days”
“Run a portfolio analysis on James Okafor — is he too concentrated?”
“What alerts need attention this week?”

Tools

6 MCP Tools

ToolWhat It Does
list_clientsList and search wealth management clients. Shows portfolio summary, risk profile, advisor assignment, and total AUM.
get_portfolioGet a client's full portfolio breakdown across all accounts — holdings, allocation, performance, and drift analysis vs. model portfolio.
get_accountGet detailed view of a single investment account — holdings by weight, sector breakdown, recent transactions, and performance.
list_transactionsSearch and filter transactions across accounts. Filter by client, type, or symbol. Shows totals by transaction type.
portfolio_analysisRun risk and allocation analysis — diversification score, concentration risks, sector exposure, and rebalancing recommendations.
get_alertsGet portfolio alerts — concentration warnings, rebalance triggers, RMD deadlines, contribution reminders, and performance flags.

Client Book

6 Sample Clients

Margaret Chen

Retirement + legacy · David Park

Moderate
$2.45M
2 accounts

Robert & Linda Vasquez

Capital preservation + income · David Park

Conservative
$4.20M
3 accounts

James Okafor

Growth + accumulation · Sarah Mitchell

Aggressive
$890K
2 accounts

Diane Whitfield-Torres

Trust mgmt + philanthropy · Sarah Mitchell

Moderate-Aggressive
$6.80M
2 accounts

Kevin Park

College fund + retirement · David Park

Moderate
$520K
3 accounts

Amara Singh

Growth + early retirement · Sarah Mitchell

Aggressive
$1.35M
2 accounts

Why This Build

Why a Wealth Management Tracker?

Wealth advisors live in a world of fragmented data. Client portfolios are spread across custodians, account types, and asset classes. Answering “how am I doing?” means logging into Schwab, pulling a Fidelity report, checking the 529 balances, and doing mental math on allocation drift.

Most portfolio management software costs $10K+/year and still requires manual data entry. The advisor ends up spending more time pulling reports than actually advising clients. Meanwhile, the client just wants a straight answer.

This server manages six clients with $16M+ in combined assets across 14 accounts. It tracks 41 holdings, computes allocation drift against model portfolios, scores diversification, flags concentration risks, and surfaces alerts for RMDs, rebalancing, and contribution limits. Ask a question, get the answer.

Demo Data

What's Inside

6

Clients

14

Accounts

41

Holdings

20

Transactions

20

Model Allocations

8

Alerts

Six clients from conservative retirees to aggressive accumulators. Fourteen accounts spanning trusts, IRAs, Roth IRAs, 529 plans, SEP IRAs, and charitable remainder trusts. Four risk profiles with model allocations. Realistic edge cases — single-stock concentration risk, missing international exposure, RMD deadlines, and a client targeting early retirement at 50.

Setup

Try It Locally

cd day22-wealth-management
npm install && npm run seed && npm run build

Then add the config to Claude Desktop and restart.

Tired of logging into four custodian portals?

If your client book lives across spreadsheets, PDFs, and custodian dashboards — let's talk about bringing it all into one conversation.