# MCP Servers & Agents

Model Context Protocol (MCP) servers for portfolio analysis, technical analysis, Yahoo Finance data extraction. Connect AI tools to live data.

## Apps (6)

### MCP Agent: Portfolio Analytics
- App: https://rbicc.net/mcp-quantstats-agent
- Docs: https://tigzig.com/app-documentation/mcp-quantstats-agent.html
- AI Docs: https://tigzig.com/ai/apps/mcp-quantstats-agent.md
- Comprehensive portfolio analytics agent orchestrating 5 MCP-FastAPI backend servers via n8n workflow. Combines QuantStats analysis, AI technical analysis, security performance reports, and Yahoo Finance data in a single chat interface.

### MCP Server: Database (Cricket SQL)
- App: https://rbicc.net/mcp-server-database
- Docs: https://db-mcp.tigzig.com/docs
- GitHub: https://github.com/amararun/shared-fastapi-database-mcp
- AI Docs: https://tigzig.com/ai/apps/mcp-server-database.md
- Read-only SQL query API for Postgres and DuckDB, exposed as MCP tools for AI clients. Contains ~1M rows of ODI cricket data (Postgres/Supabase) and ~1M rows of T20 cricket data (DuckDB).

### MCP Server: Security Performance Report (SPR)
- App: https://rbicc.net/mcp-server-ffn
- Docs: https://tigzig.com/app-documentation/mcp-server-ffn.html
- AI Docs: https://tigzig.com/ai/apps/mcp-server-ffn.md
- FastAPI + MCP server for multi-security portfolio analysis using dual methodology: custom performance calculations (validated against QuantStats) combined with FFN library analytics. Generates HTML reports with charts and 6 CSV data exports.

### MCP Server: QRep Portfolio Profiling (QuantStats)
- App: https://rbicc.net/mcp-server-quantstats
- Docs: https://tigzig.com/app-documentation/mcp-server-quantstats.html
- GitHub: https://github.com/amararun/shared-quantstats
- AI Docs: https://tigzig.com/ai/apps/mcp-server-quantstats.md
- FastAPI + MCP server for portfolio performance analysis using quantstats-lumi (Lumiwealth's fork with bug fixes). Generates comprehensive HTML reports with risk-return metrics, rolling statistics, and benchmark comparison.

### MCP Server: Technical Analysis
- App: https://rbicc.net/mcp-server-technical-analysis
- Docs: https://tigzig.com/app-documentation/mcp-server-technical-analysis.html
- GitHub: https://github.com/amararun/shared-fastapi-mcp-technical-analysis
- AI Docs: https://tigzig.com/ai/apps/mcp-server-technical-analysis.md
- FastAPI + MCP server for generating AI-powered technical analysis reports. Fetches Yahoo Finance data, calculates technical indicators, generates charts, sends to Gemini Vision API for interpretation, produces PDF and HTML reports.

### MCP Server: Yahoo Finance Data Extractor
- App: https://rbicc.net/mcp-server-yahoo-finance
- Docs: https://tigzig.com/app-documentation/mcp-server-yahoo-finance.html
- GitHub: https://github.com/amararun/shared-yfin-coolify
- AI Docs: https://tigzig.com/ai/apps/mcp-server-yahoo-finance.md
- FastAPI + MCP server for extracting financial data from Yahoo Finance. Provides stock prices, financial statements (annual + quarterly), market data, and company profiles with MCP integration for AI/LLM clients.

## Blog Posts (8)

- [Claude in Excel + MCP + xlwings Lite + Claude Code: Combining the 4 for power impact.](https://tigzig.com/post/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools.html) — Tags: claude-in-excel, mcp, xlwings-lite, ai-coders, portfolio-analytics
  Live walkthrough of S&P 500 forward returns scenario model built with four tools. Claude in Excel pulls data via YFIN MCP server and builds MAP/LAMBDA formula model. Claude Code validates offline with independent Python recomputation - catches a formula error that in-Excel checks missed. xlwings Lite generates distribution charts (fan, ridgeline, raincloud) from Python into Excel. Covers when to use each tool and MCP architecture for client work.
  AI-readable: https://tigzig.com/ai/posts/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools.md
- [Talk to Your Database from Excel via Claude & MCP - Part 2](https://tigzig.com/post/talk-to-your-database-from-excel-mcp-part-2.html) — Tags: claude-in-excel, mcp
  Part 2 of connecting Excel to databases via Claude MCP. Two new server options: open public server hardened with 23 defense layers (rate limits, concurrency caps, SQL validation) and OAuth-secured server via Auth0 with JWT validation for client sharing. Full source code open as single Python file. Includes standard MCP security advice and link to 80+ item security checklist.
  AI-readable: https://tigzig.com/ai/posts/talk-to-your-database-from-excel-mcp-part-2.md
- [My Public MCP Server Got Hammered - Security Lessons from a Bot Attack](https://tigzig.com/post/mcp-server-bot-attack-security-lessons.html) — Tags: infrastructure, security, mcp
  Real incident report of a bot attack on a public database MCP server. Had rate limiting, read-only access, and SQL validation but still got hammered. Worked with Claude Code to fix 15+ attack vectors including exposed server IPs, open system catalogs, and an unprotected Supabase REST API. Covers lessons on securing public demo apps vs client apps, and why ignoring AI coder security audit recommendations has consequences.
  AI-readable: https://tigzig.com/ai/posts/mcp-server-bot-attack-security-lessons.md
- [Talk to Your Database from Excel - Postgres, DuckDB - via Claude in Excel with MCP](https://tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp.html) — Tags: claude-in-excel, mcp, duckdb, database-ai
  Public MCP server enabling SQL queries against live Postgres (Supabase, ODI cricket) and DuckDB (T20 cricket) databases from Claude in Excel. Covers 2 million rows of ball-by-ball data from 2013-2025. Built with FastAPI, asyncpg, and fastapi-mcp. Includes detailed tool docstrings for schema context, 1000-row response cap, read-only security, rate limiting, and SQL validation. Open source, single-file Python backend.
  AI-readable: https://tigzig.com/ai/posts/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp.md
- [Claude in Excel with MCP Connector - Talk to Your Backends from Inside Excel](https://tigzig.com/post/claude-in-excel-mcp-connector-talk-to-backends.html) — Tags: claude-in-excel, mcp
  Tests Claude in Excel with MCP custom connectors across three backend servers: Yahoo Finance data pulls, AI technical analysis report generation, and multi-security performance review. Covers practical results, limitations with large data writes, URL handling, and MCP security considerations. Includes three open-source public MCP servers (YFIN, SPR, Technical Analysis). Compares Claude in Excel, Custom GPTs, xlwings Lite, and Claude Code for different use cases.
  AI-readable: https://tigzig.com/ai/posts/claude-in-excel-mcp-connector-talk-to-backends.md
- [Live Portfolio Analytics - Powered by MCP Servers - Open Source](https://tigzig.com/post/open-so.html) — Tags: portfolio-analytics, mcp
  Modular live portfolio analytics stack powered by MCP-FastAPI servers. Delivers 70+ KPIs, 15+ charts, AI technical analysis, and PDF/HTML reports across 6 interfaces: React, NextJS, ChatGPT, Flowise, xlwings Lite, and forms. Backend uses QuantStats, yfinance, Finta, Gemini Vision, and ReportLab. Three public MCP servers available for plug-and-play integration.
  AI-readable: https://tigzig.com/ai/posts/open-so.md
- [ChatGPT Connected to integrated FastAPI-MCP Servers.. Technical Analysis (TA) report. From stocks to crypto.](https://tigzig.com/post/chatgpt-connected-fastapi-mcp-servers-technical-analysis-ta-report-stocks-crypto.html) — Tags: custom-gpt, mcp, technical-analysis
  Connecting ChatGPT to integrated FastAPI-MCP servers for generating technical analysis reports on stocks, crypto, and commodities via Yahoo Finance symbols. Backend uses FastAPI with MCP server (Tadata's FastAPI-MCP), serving multiple interfaces: n8n, Flask UI, Next.js, ChatGPT, and xlwings Lite. Outputs formatted PDF and web reports with Gemini Vision chart analysis. Includes OpenAPI schema setup for Custom GPT actions and public source code.
  AI-readable: https://tigzig.com/ai/posts/chatgpt-connected-fastapi-mcp-servers-technical-analysis-ta-report-stocks-crypto.md
- [Build AI Workflows with MCP Servers + n8n](https://tigzig.com/post/build-ai-workflows-mcp-servers-n8n-technical-analysis.html) — Tags: mcp, technical-analysis
  Building AI workflows by connecting MCP servers to n8n for automated technical analysis. Uses Tadata's FastAPI-MCP to mount MCP on existing FastAPI servers and n8n's MCP Client node for SSE connections. Pipeline pulls Yahoo Finance data, computes indicators, sends charts to Gemini Vision for AI analysis, and outputs PDF/web reports. Includes Docker deployment setup, public MCP server URLs, n8n schemas, and full source code.
  AI-readable: https://tigzig.com/ai/posts/build-ai-workflows-mcp-servers-n8n-technical-analysis.md

## Related Topics

- [Database AI & Text-to-SQL](https://tigzig.com/ai/tags/database-ai.md)
- [Python in Excel (xlwings Lite)](https://tigzig.com/ai/tags/python-in-excel.md)
- [Claude in Excel](https://tigzig.com/ai/tags/claude-in-excel.md)
- [DuckDB - Analytics & Dashboards](https://tigzig.com/ai/tags/duckdb.md)
- [Portfolio & Quantitative Analysis](https://tigzig.com/ai/tags/portfolio-quants.md)