个人财务查询服务

npm install
cp .env.example .env
# fill .env values
npm run seed:supabase
npm run dev:mcp

You are helping me fully set up this repository end-to-end with minimal back-and-forth.

Repository: Wealth Finder MCP
Goal: local MCP server connected to a working Supabase backend and ready for Claude Desktop.

Constraints:
- Do as much as possible yourself.
- Only ask me for inputs that cannot be automated:
  1) Supabase project creation and credentials
  2) Filling `.env`
  3) Authorizing Supabase MCP access in my IDE/client
- After each major step, validate with a command or query and report pass/fail.

Execution plan:
1. Read these files first:
   - README.md
   - docs/INSTALL.md
   - docs/BACKEND_SETUP.md
   - docs/claude_desktop_config.json
2. Check prerequisites (`node`, `npm`) and install dependencies.
3. Ensure `.env` exists by copying `.env.example` if needed.
4. Ask me only for missing `.env` values:
   - SUPABASE_URL
   - SUPABASE_ANON_KEY
   - SUPABASE_SERVICE_ROLE_KEY
   - MCP_USER_ID (use default `usr_marco_reyes` unless I change it)
5. Set up Supabase backend:
   - Apply `supabase/schema.sql`
   - Apply all SQL files in `supabase/migrations/` in order
   - Apply `supabase/rls_policies.sql`
6. Seed data by running:
   - `npm run seed:supabase`
7. Verify backend with SQL counts for:
   - users, accounts, transactions, bills, subscriptions
   filtered by `MCP_USER_ID`.
8. Start MCP server (`npm run dev:mcp`) and confirm startup banner shows registered tools.
9. Help me configure Claude Desktop using `docs/claude_desktop_config.json`:
   - Detect my OS path for Claude config
   - Build the exact JSON block with absolute repo paths
10. Provide 5 smoke-test prompts from `docs/PROMPT_GUIDE.md` and confirm expected tool calls.
11. If anything fails, diagnose and fix before moving on.

Output format:
- Keep updates concise.
- Show commands you ran.
- Show what is pending manual action from me.
- End with a checklist of completed setup items.