# MCP Servers & Agents Model Context Protocol (MCP) servers for portfolio analysis, technical analysis, Yahoo Finance data extraction. Connect AI tools to live data. ## Apps (4) ### MCP Server for read-only SQL queries over men's international cricket ball-by-ball data, on Postgres and DuckDB - App: https://www.tigzig.com/mcp-server-database - Docs: https://tigzig.com/app-documentation/mcp-server-database.html - GitHub: https://github.com/amararun/shared-rexdb-auth-embed-v3-agentflowv2 - AI Docs: https://www.tigzig.com/ai/apps/mcp-server-database.md - MCP Server for read-only SQL queries over men's international cricket ball-by-ball data, on Postgres and DuckDB ### MCP Server for multi-security performance report - App: https://www.tigzig.com/mcp-server-ffn - Docs: https://tigzig.com/app-documentation/mcp-server-ffn.html - GitHub: https://github.com/amararun/shared-rexdb-auth-embed-v3-agentflowv2 - AI Docs: https://www.tigzig.com/ai/apps/mcp-server-ffn.md - MCP Server for multi-security performance report ### MCP Server for Technical Analysis - PDF & Web Reports - App: https://www.tigzig.com/mcp-server-technical-analysis - Docs: https://tigzig.com/app-documentation/mcp-server-technical-analysis.html - AI Docs: https://www.tigzig.com/ai/apps/mcp-server-technical-analysis.md - MCP Server for Technical Analysis - PDF & Web Reports ### MCP Server for Yahoo Finance data extraction - App: https://www.tigzig.com/mcp-server-yahoo-finance - Docs: https://tigzig.com/app-documentation/mcp-server-yahoo-finance.html - AI Docs: https://www.tigzig.com/ai/apps/mcp-server-yahoo-finance.md - MCP Server for Yahoo Finance data extraction ## Blog Posts (29) - [QDESK: A Reporting Desk for Portfolio Reports and Financial Data. Just Ask in Plain Language.](https://www.tigzig.com/post/qdesk-reporting-desk-sep2026) - Tags: portfolio-quants, mcp QDESK is an agent-driven reporting desk: ask in plain language and it looks up the symbol then runs the report, so you never need the ticker. It produces a security performance report, daily and weekly technical analysis, a QPulse tearsheet against a benchmark, and QREP metrics with around eighty risk and return figures for up to six securities. Also pulls company financials, prices and Indian mutual fund NAV history, with REST and MCP endpoints behind each report. AI-readable: https://www.tigzig.com/ai/posts/qdesk-reporting-desk-sep2026.md - [Technical Analysis on Any Ticker Without Visiting My Site. Just Ask Your AI Agent.](https://www.tigzig.com/post/tigzig-technical-analysis-ask-your-ai-aug2026) - Tags: technical-analysis, mcp, ai-coders The TigZig technical analysis API produces a formatted PDF and web report with charts, indicator readings and an outlook for any Yahoo Finance ticker, covering stocks, indices, FX, crypto and commodities, and it can be reached entirely through an AI agent without opening the site: paste a plain-English request naming the ticker and the tigzig API, and the agent discovers the API catalog, picks the right endpoint and reads the rate limits itself. Model choice is available on request. How it is built: prices from Yahoo Finance on daily and weekly timeframes, indicators computed with finta (EMAs, MACD, RSI, Bollinger Bands), two charts drawn with matplotlib, then both the numbers and the chart images passed to a vision model that reads the chart and writes the interpretation, with the returned markdown converted to PDF and HTML by a second ReportLab-based service. One FastAPI app serves the web front end, the REST endpoint and the MCP endpoint, so a browser and an agent execute the same code, and the whole thing is open source for anyone wanting to self-host or customise it. Closes with an explicit scope statement: this is a reporting tool rather than investment advice or research, models can misread a chart confidently, and the author's own practice is to use AI for the heavy lift and alternative angles while validating every deterministic output, the numbers and formulas, against more than one source. AI-readable: https://www.tigzig.com/ai/posts/tigzig-technical-analysis-ask-your-ai-aug2026.md - [Comparing Securities on Returns, Risk and Drawdowns. Four Routes into QuantStats, Depending on What Your AI Can Do.](https://www.tigzig.com/post/quantstats-four-routes-qrep-agent-aug2026) - Tags: portfolio-analytics, mcp, ai-coders Four ways to get portfolio and security analytics out of QuantStats, the open-source library by Ran Aroussi who also wrote yfinance, with the right route depending on what your AI can actually do. An AI chat such as ChatGPT cannot install Python, so it connects through an MCP server, and the open-source QREP MCP server is one option. An AI agent such as Claude Cowork, Claude in Excel or PowerPoint, or ChatGPT Work, installs the package itself, runs the numbers and formats the output or builds a dashboard, and can equally call the QREP API directly for a fixed set of 81 metrics with no setup, or connect over MCP. For interactive work on screen, the QREP browser tool runs the cuts and generates a QuantStats-format tear sheet. Tool and API are both QuantStats-powered and both open source, with a few QREP implementation choices that shift a handful of numbers slightly, documented in the methodology page. Also notes that an agent with Python can be asked to write the metric functions from scratch, which is useful for validation and for metrics such as rolling returns. Adds a clarification on what a chat app can actually run in its Python sandbox, where ChatGPT is more restricted than Claude.ai and the desktop cowork apps are more capable again, with the practical advice being to ask the assistant what it can do and test it. Includes copy-paste agent prompts for both the run-it-yourself and the API route, using the Mag 7 against the S&P 500 over five years, plus practical notes for the browser tool: ticker search rather than typing, CSV export of the metrics table and raw prices, adjustable omega threshold and var/cvar confidence and tail cutoff, and browser-computed EMA, RSI and MACD technicals with the formulas in the docs. AI-readable: https://www.tigzig.com/ai/posts/quantstats-four-routes-qrep-agent-aug2026.md - [Your Agents and Scripts Have Been Talking to Me. Here Is That Conversation in Plain English.](https://www.tigzig.com/post/api-conversation-agents-scripts-jul2026) - Tags: infrastructure, mcp, mutual-funds Server logs from the free, keyless tigzig data APIs rewritten as a plain-English conversation, including who is actually calling (roughly 1 in 5 mutual fund API calls arrive with Claude or ChatGPT user agents from Cowork, Excel and Codex, rising to about half on Tremor and Yahoo Finance where MCP is mounted, with the rest scripts and AI coders behind generic or blank user agents): 23 real questions the incoming calls asked, and the patterns that got it right. Questions covered include SIF schemes (not carried, and why a q=SIF search returns 30 false matches from 'diversified'), where to get index levels rather than index funds (Tremor's 20 market series with tickers and history start dates, or the Yahoo Finance wrapper), batching up to 50 identifiers in one call with scheme/schemes/isin/isins interchangeable, what a 429 actually means and how Retry-After and X-RateLimit-Remaining work, trailing punctuation and & entities in copied URLs (the silent one that returns full history instead of your date slice), why an MCP endpoint 406s in a browser, the three causes of a 404 on a well-formed identifier, ISIN check digits and invalid ISINs circulating through AI output, empty-200 vs 404, retrying large downloads and verifying against Content-Length, plus the cricket-database GET-vs-POST fix and its Cricsheet id space. The things callers got right: whole-file parquet downloads, format choice, ChatGPT-User fetching files into its own sandbox, batch calls, search-then-fetch, since= incrementals, DuckDB HTTP range reads pulling 9MB instead of 170MB, ETag/If-None-Match and If-Modified-Since checks, and agents reading the API catalog before making a single data call. Ends with the human and agent documentation sets and how to report a problem. AI-readable: https://www.tigzig.com/ai/posts/api-conversation-agents-scripts-jul2026.md - [Yahoo Finance MCP Backend Upgraded. 25 Tickers in One Request, Answers in Seconds, Clear Errors Instead of Slow Failures.](https://www.tigzig.com/post/yahoo-finance-mcp-backend-upgrade-jul2026) - Tags: mcp Short release note: the TigZig Yahoo Finance MCP backend has been upgraded - batch requests now take up to 25 tickers in one call, responses return in seconds instead of stalling, and a bad or slow ticker returns a short note while the rest of the batch still comes through, a clear message instead of a slow failure. Applies to any MCP client (Claude, ChatGPT, LM Studio). Errors on any TigZig app surface on the author's monitoring and get root-caused. Links: Yahoo Finance MCP docs page, api.tigzig.com agent entry point, the API-errors practical fix guide, and the Streamable HTTP migration note for anyone still on an older SSE URL. AI-readable: https://www.tigzig.com/ai/posts/yahoo-finance-mcp-backend-upgrade-jul2026.md - [Every Tigzig MCP is now Streamable HTTP. Requesting existing users from LM Studio, ChatGPT, Claude etc to make a one time change if you have not already done so](https://www.tigzig.com/post/tigzig-mcp-streamable-http-migration-jul2026) - Tags: mcp Migration note: all seven Tigzig MCP servers now run Streamable HTTP, the current MCP transport standard used by Claude, ChatGPT and LM Studio - every server lives at its host plus /mcp. Existing SSE users are asked to make a one-time connection change; SSE stays mounted for now but is being deprecated, and old addresses keep working where possible. Includes a plain-words explainer on connection types (remote URL vs local command; pick Streamable HTTP or 'HTTP' in your client), the full server list with URLs (Yahoo Finance, Technical Analysis, Portfolio Review ffn, QRep Compare Securities, Tigzig Data Surface, Cricket Database, Markdown to PDF), why a browser shows 406 on /mcp addresses, the skip-the-MCP alternatives (call the open APIs directly or wrap your own server - no keys, per-IP rate limits on each docs page), and the agent path: point an AI at api.tigzig.com for the machine-readable catalog of every API and MCP. Single-image release post with the migration one-pager PNG at the bottom. AI-readable: https://www.tigzig.com/ai/posts/tigzig-mcp-streamable-http-migration-jul2026.md - [Demystifying TIGZIG API Errors: A Practical Guide for MFPRO, TREMOR, and VIGIL Users](https://www.tigzig.com/post/tigzig-api-errors-practical-guide-jul2026) - Tags: infrastructure, mcp A troubleshooting field guide for the free tigzig.com data APIs (MFPRO mutual fund NAV, TREMOR macro/market, VIGIL India red flags, Yahoo Finance tools), built from real server-log patterns. Covers 20 common failure modes in plain English: trailing punctuation and & entities in copied URLs, over-encoded parameter joiners, missing required inputs, the JavaScript undefined trap, GET vs POST confusion, folder-style path guessing, comma-separated inputs on single-item endpoints, wrong format requests, opening MCP endpoints in a browser (406), deprecated SSE paths (405), per-API parameter naming differences, ISIN variant mismatches, model-hallucinated scheme codes, Yahoo market suffixes, and the empty-but-correct responses class: non-corporate assets without financials, dividend-free stocks, defunct schemes after the July 2026 backfill (38,000+ schemes since 2006), AMFI weekend/holiday publishing windows, and client timeouts on large batches. Ends with the copy-this-page-to-your-AI troubleshooting recipe and the full human + AI-agent documentation link set (API catalog RFC 9727, MCP server registry, raw markdown data dictionaries). AI-readable: https://www.tigzig.com/ai/posts/tigzig-api-errors-practical-guide-jul2026.md - [Tremor: A Free, No-Auth API for 330+ Macro and Market Indicators, 350K records, Refreshed 3x/Day. Ask your AI to explore.](https://www.tigzig.com/post/tremor-macro-api-ask-your-ai-jul2026) - Tags: mcp, infrastructure Release note on the current state of Tremor, tigzig.com's free open API and MCP server for macro, credit, valuation and market data. 331 public indicators across 8 categories, 350K records, refreshed 3x a day, no key and no sign-up. Ask-your-AI framing - point an AI agent at api.tigzig.com's Tremor and it reads the category menu (8 high-level buckets), drills into the one that matches the question, gets the full indicator list with metadata, searches if needed, then pulls the series - one prompt, the human never touches the docs. MCP also available for agents that prefer that surface. Category breakdown: US macro (35 - FRED 32 + Michigan Consumer Sentiment 1 + Manheim Used Vehicle Value Index 2), US credit stress (216 - NY Fed Household Debt 64 + FDIC bank aggregates 80 + NCUA credit-union aggregates 72, covering delinquency by product / charge-offs / originations by credit tier), US valuation (1 series - Shiller CAPE since 1881, with the us_valuation grouping also surfacing the Buffett indicator and nominal GDP from us_macro and the 10Y Treasury yield), US insurance (currently empty - Fed Z.1 Life + P&C invested-asset breakdown scaffolded and loading), India macro and credit (47 - MoSPI 27 + RBI 15 + NSE 3 + FRED USDINR 1 + one computed CD ratio), Global macro (8 - OECD Business Confidence for 4 countries + Bundesbank 10Y Bund + Bank of England 10Y Gilt + ECB Euro-area 10Y yield curves for AAA and all-issuers), Currencies (7 daily FX pairs including USDINR + EM Asia + Fragile-X peer cuts USDJPY / USDKRW / USDTWD / USDPHP / USDTRY / USDVND), Markets (16 daily Yahoo Finance symbols - S&P 500, Nifty 50, Nikkei 225, Hang Seng, DAX, Shanghai, US 10Y ^TNX, DXY, gold, silver, copper, WTI, Brent, natural gas, USDINR, USDJPY). Each indicator ships a notes field with the gotchas baked in for the agent: us_real_gdp is already SAAR-annualized (do not multiply by 4), in_nifty50_pe has a standalone-to-consolidated methodology break in April 2021, in_net_fdi negative means outflow and there is a 6+ month publication lag. Pipeline detail: pull via API where available (FRED, RBI WSS, ECB Statistical Data Warehouse, OECD, Bundesbank, Bank of England); for sources published only as files with year-to-year format drift (NCUA 5300 Call Reports, FDIC SDI aggregates, NY Fed Household Debt Study, MoSPI eSankhyiki, RBI DBIE Excel, Shiller's ie_data.xls, Manheim MUVVI) the file is downloaded, parsed with error correction, standardized into a series. Runs 3x a day - Fed publishes at 3pm ET, we pick it up in the next cycle and it is live in Tremor by early evening. Multi-cadence handling: RBI is a mix (weekly rates + fortnightly credit + monthly trade/FDI/FPI), MoSPI monthly or quarterly by series, NSE Nifty PE/PB daily, quarterly GDP + GFCF + credit-union aggregates land once a quarter and get ingested the day published. Pipeline does error checking: sums validate, YoY consistency checked, data quality issues (missing values, spikes that do not match the source document) flagged in metadata so the caller sees them. Sources summary lists FRED, NY Fed, FDIC, NCUA, RBI, MoSPI, NSE, ECB, Bundesbank, BoE, OECD, Shiller, Michigan, Manheim, Yahoo Finance with a one-line note on each. Includes 'what moved recently' section with current-through dates on Treasury curve + VIX + Baa credit spread + 10Y TIPS + 10Y-2Y spread + 30Y fixed mortgage rate + PMMS + initial jobless claims + Bund + Gilt + Euro-area yield curves + the 16 daily market symbols. Launched March with ~50 indicators; now 331 and growing. Single-image release post with the one-pager PNG at the bottom. AI-readable: https://www.tigzig.com/ai/posts/tremor-macro-api-ask-your-ai-jul2026.md - [Free Mutual Fund NAV API for India - Revamped. AI Ready. 18,000+ Schemes Since 2008 from AMFI.](https://www.tigzig.com/post/tigzig-mf-nav-api-revamp-jul2026) - Tags: mutual-funds, converters-tools, mcp Release note for the revamped free Mutual Fund NAV API for India on tigzig.com. Daily NAVs for 18,000+ schemes since 2008, straight from AMFI. Free, no sign up, no API key. Rebuild targets AI + automation friendliness: latencies and errors significantly down, more capacity, accepts AMFI Code or ISIN or a mix (auto-detected at the backend), plus a set of other flexibility improvements captured in the attached 2-page overview. Claude Cowork and OpenAI Codex can work with the API directly - point them at the API docs page and they take it from there. Claude in Excel needs a thin MCP wrapper on top (open source coming soon). Two consumption paths: API docs at tigzig.com -> APIs -> MF NAV, or the MFPRO UI at tigzig.com -> MFPRO which runs advanced analytics on up to 200 schemes in one shot (risk, returns including rolling returns, alpha, betas, drawdowns). Whole database is also downloadable in two ways: human path via MFPRO Data and API button (Parquet, CSV, TSV, SQLite), or AI/API path via a single GET on /mf/v1/download which returns all 20.5M+ rows as a single file. Approx sizes: Parquet 109 MB, CSV 132 MB compressed, SQLite 462 MB compressed. Every metric in MFPRO ships with a validation pack - the UI computes on DuckDB SQL and the validation pack recomputes in pure Python, with a ready-to-run main.py against the NAV file so a user or their AI can reproduce and extend. 2-page overview PDF carousel included. AI-readable: https://www.tigzig.com/ai/posts/tigzig-mf-nav-api-revamp-jul2026.md - [Claude for Analytics on Tigzig.com - New Hub: Excel, PowerPoint, Cowork, 7 MCP Servers, 20+ Guides.](https://www.tigzig.com/post/tigzig-claude-for-analytics-hub-jul2026) - Tags: claude-in-excel, mcp, excel Launch announcement for the new 'Claude for Analytics' hub on tigzig.com (canonical URL /ai-in-excel) - one page that pulls together everything the author has built and written on driving analyst work with Claude in Excel, PowerPoint and Cowork. Contents: 20+ guides, 5 PDF playbooks, 7 MCP servers, plus the source workbooks (formulas, charts, models). Specific capabilities highlighted: talk to Postgres and DuckDB from inside Excel, pull 81 risk and return metrics live into a sheet (QREP MCP), work with Claude-in-Excel and have it push results into Claude-in-PowerPoint for a deck, and Cowork extending the same Claude beyond the sheet to files, databases, ML models and code as one frontend. Two ways to consume - browse the hub yourself or ask Claude / ChatGPT / Gemini to read the page and summarise. All free, almost all open source. 2-page overview PDF included as a small carousel. AI-readable: https://www.tigzig.com/ai/posts/tigzig-claude-for-analytics-hub-jul2026.md - [New Markdown to PDF Hub on Tigzig.com - ReportLab, Repos, Live Tools, MCP + API Endpoints.](https://www.tigzig.com/post/markdown-to-pdf-hub-launch-jun2026) - Tags: converters-tools, mcp, fastapi Release announcement for the new Markdown to PDF Hub on tigzig.com - the author's learnings, open-source repos, live tools, and endpoints for taking AI-generated markdown into a properly formatted PDF report (charts, side-by-side tables, page templates, layout you want). Built on ReportLab (uses only the open-source version, all features present). Try it live at quants.tigzig.com - have the AI agent run a technical analysis report or just hit the sample button (~30-60s). Multiple surfaces: form-based interface for humans, AI-assisted interfaces, an API endpoint (Claude Cowork can connect directly, no MCP server required), and MCP servers for AI. Free, open source, no sign-up, no key. Quick tips section covers the working-style trade-offs: this is not an auto-layout tool (you set the format once), stick with ReportLab + Claude Code for iteration speed, Gemini 2.5 Flash is the go-to LLM for auto-formatting (cost-effective + reliable), the PDF conversion is split into a separate backend service (author's choice; combine into a single app for own use), the main trick is getting the AI to return structured JSON with image paths and formatting tags, and offline automation is straightforward but live tools need edge/frontend/backend/MCP security. AI-readable: https://www.tigzig.com/ai/posts/markdown-to-pdf-hub-launch-jun2026.md - [QREP in Excel: 81 Risk and Return Metrics Inside Your Sheet Through Claude in Excel.](https://www.tigzig.com/post/qrep-claude-in-excel-mcp-jun2026) - Tags: mcp, claude-in-excel, portfolio-analytics, excel Standalone one-pager release: QREP, a Tigzig MCP server, brings 81 risk and return metrics straight into Excel through Claude in Excel - asset returns, drawdowns, Sharpe, Sortino, alpha, beta, volatility and more. Just ask Claude in Excel things like 'Compare gold and bitcoin, last 10 years' or 'compare Mag 7 past 10 years' - any stock, commodity or crypto that's on Yahoo Finance. Change symbols, time period, run cuts your own way, format it your way, push it into a deck, or do it directly in PowerPoint. MCP guide at tigzig.com -> MCP -> QREP. For AI-coders, just ask Gemini / ChatGPT / Claude to help connect Claude in Excel to QRep from tigzig.com - it walks through. Wary of someone else's MCP server? The code is open source, a single Python file - ask your AI to deploy the QREP MCP server from tigzig.com. Free to use. Powered by Ran Aroussi's QuantStats. Three companion guides linked: Claude Cowork Guide, Claude in Excel & PowerPoint 26 working tips, and Claude as the universal agent. AI-readable: https://www.tigzig.com/ai/posts/qrep-claude-in-excel-mcp-jun2026.md - [New MCP Hub on Tigzig.com - 7 MCP Servers, 6 Live Apps, 16 Guides, 108-Point Security Checklist. Just Ask Your AI.](https://www.tigzig.com/post/tigzig-mcp-hub-launch-jun2026) - Tags: mcp, security Standalone one-pager release announcing the new MCP hub on tigzig.com - 7 open-source and live MCP servers, 6 live apps, 16 guides, plus a 108-point security checklist. Designed for AI and automation builders. Either browse the hub at tigzig.com/mcp, or just ask ChatGPT / Gemini / Meta AI on WhatsApp / Claude something like 'Go to tigzig.com's MCP page and lemme know what's there' - the AI will pull what's there and Claude Code / any AI coder will implement it for you. The hub carries reusable components that work across domains - sending data and charts to AI and getting structured results back, formatted PDF and HTML output, accessing backend databases on DuckDB and Postgres, Python processing for statistical and quant analysis. Live MCP servers and apps cover macro data, a database query server, portfolio analytics, and tools used regularly for own analysis. The companion security checklist (tigzig.com/security) covers backend, auth, database, edge and third-party apps - 108 items. AI-readable: https://www.tigzig.com/ai/posts/tigzig-mcp-hub-launch-jun2026.md - [Tigzig Tremor v2 Is Live. 330+ Macro + Credit Indicators Behind an MCP. 83% Lighter Startup. Just Ask Your AI Agent.](https://www.tigzig.com/post/tigzig-tremor-v2-mcp-330-indicators-jun2026) - Tags: mcp, portfolio-quants Release announcement for Tigzig Tremor v2 - the MCP behind tigzig.com's 330+ macro and credit indicators across US, India, global macro, credit, markets and FX (17+ official publishers). Pulling macro data for analysis is mostly grunt work - finding the series, downloading, cleaning - so it now sits behind an MCP that AI agents (Claude Cowork, Claude in Excel, any agent) can ask in plain English. Sample asks in the post: 'US consumer net charge-offs, banks vs credit unions, last 15 years, chart it', 'S&P 500 and CAPE past 25 years, dual axis', 'Overlay Brent and WTI crude past 5 years'. The headline v2 change: catalog discovery split from tool calls. v1 stuffed the whole catalog into one ~8,000-token tool description the agent loaded up front; v2 surfaces an 8-category menu, the agent drills into only the tables it needs and pulls only the relevant bits - startup load cut from 7,854 to 1,352 tokens, 83% lighter. The discovery layer also carries house notes on each series (e.g. 'this charge-off is quarterly, multiply by 4 to annualize') so the AI does not quietly get it wrong. Free, open, no sign-up - use the live MCP, install your own, hit the APIs directly, or download the whole DB in your chosen format. Humans: tigzig.com -> TREMOR -> API / MCP. AI agents: api.tigzig.com. AI-readable: https://www.tigzig.com/ai/posts/tigzig-tremor-v2-mcp-330-indicators-jun2026.md - [Connect Excel to a Database with Tens of Millions of Rows? Tigzig.com Has 15+ Apps and Guides for That Alone. Just Ask Your AI.](https://www.tigzig.com/post/tigzig-excel-to-databases-ai-find-jun2026) - Tags: excel, python-in-excel, mcp Standalone one-pager release: how to connect Excel to a database with tens of millions of rows and GBs of data. There are 15+ apps, repos and guides on tigzig.com just for this one niche - xlwings-Lite (Python in Excel), a Claude-in-Excel MCP server, open repos connecting to MySQL, PostgreSQL and DuckDB, plus security setups, auth and semantic layers. And Excel-to-databases is only one corner - the whole site has 250+ assets, from live tools to open repos. The point of the post: don't click around. Tigzig.com is indexed across ChatGPT, Gemini, Claude, Google AI and Meta AI on WhatsApp, so just ask whichever AI you keep open what you want to pull from the site - it will find it and walk you through. If you are on Claude Code, Cursor or any AI coder, it will download and implement it for you. Sample agent prompts in the deck: 'What does tigzig.com have for connecting Excel to a database?' and 'What about security, semantic layer, auth?' AI-readable: https://www.tigzig.com/ai/posts/tigzig-excel-to-databases-ai-find-jun2026.md - [Claude Cowork and Claude Code Have Quietly Become My Universal Front End. More Than Excel, Jupyter or Colab.](https://www.tigzig.com/post/working-with-claude-cowork-claude-code-jun2026) - Tags: ai-coders, mcp First-person guide on running almost the whole analysis-and-modeling pipeline from one place. For the author, Claude Cowork (and Claude Code) have quietly become the universal front end - past Excel, Jupyter and Colab - covering exploration, cleaning, ensembles, hyperparameter tuning, validation, and final presentation deck. Each iteration is shared as HTML reviewed in the browser, so a session ends with both a model AND full documentation written as work progressed. Same flow works for database-connected analysis, not just model builds. Excel work goes through Claude in Excel or Cowork; PowerPoint too. Full-stack builds stay on Claude Code. The difficult part was letting go: after years of notebooks and code editors, with the comfort of code you can touch and feel, stepping back to talk into a chat box and review the results took some getting used to. Once you let go, it is way faster and gives much better results, since the human focuses on validations, logic, business and domain pieces - the places where an AI agent still needs guidance. Includes a 23-slide deck that Cowork put together about itself: chat -> coworker shift, desktop + Code teammate, hitting APIs (FRED, Yahoo Finance), reaching backends via MCP, working files in place, cleaning messy spreadsheets, 11.85M-row / 1.6GB analyses in 13 seconds, EDA-as-browser-page iteration loop, gradient-boosting model builds with ROC / gains, A/B significance tests, packaging as HTML/PDF/Word/PPT/Excel, live dashboards that pull fresh data, real URL fetching (not snippets), scheduled briefings, browser/desktop control, cross-session memory, sandbox toolkit (4GB RAM / 10GB disk / pandas / polars / pyarrow / scikit-learn / matplotlib / OpenCV / Pillow), no-code-on-your-machine handoff to Claude Code, and Anthropic's own resources (Cowork product, best-practices guide, the HTML-beats-Markdown post, computer-use docs). Deck self-built in Cowork as HTML then exported to PDF. AI-readable: https://www.tigzig.com/ai/posts/working-with-claude-cowork-claude-code-jun2026.md - [AI Is the Front Door Now. Don't Dig Through Tigzig.com - Ask Your AI About It.](https://www.tigzig.com/post/tigzig-ask-your-ai-front-door-jun2026) - Tags: ai-coders, mcp Standalone one-pager release: AI is the front door now. Just like you ask your AI about Cloudflare, Vercel or AWS instead of digging through the docs, tigzig.com (40+ live apps, repos, ~200 build guides, data APIs, MCP servers, 100s of assets) is indexed across the major AI assistants - ChatGPT, Gemini, Google AI, Claude, WhatsApp Meta AI - so you can ask whichever one you keep open what's there, what's not, and how to use it before you even visit. Sample questions: Is tigzig.com legit? What can it do with my database? Does it have a security checklist for AI tools? How do I pull a portfolio or technical-analysis report? What free data APIs does it have? Quicker than browsing, and a fair way to sanity-check it. AI-readable: https://www.tigzig.com/ai/posts/tigzig-ask-your-ai-front-door-jun2026.md - [The Fastest Way to Use Tigzig.com? Don't Click. Point Your Claude / AI Agent at It.](https://www.tigzig.com/post/tigzig-agent-first-just-point-your-claude-jun2026) - Tags: portfolio-quants, mcp The fastest way to use tigzig.com is to not click - point your Claude or AI agent at it. The site is built AI-agent-ready: 40+ analytics apps, open analytics APIs, MCP servers, 200+ guides, plus a repos shelf - all free, no sign-up. An agent pointed at the site can find the right tool / guide / dataset for the task, read app and database data and run the analysis, call the analytics APIs, set up MCP servers, and even download / install / deploy an open-source repo. Claude Cowork is particularly good at this - it runs its own sandbox inside the Claude desktop app, so once a domain is enabled it makes the API calls itself, pulls the data, runs the analysis and hands back a PDF. Codex, Cursor, any agent works the same way. Rather explore yourself? The whole site is still right there - the agent just gets you there faster. Don't believe it? Point your agent at tigzig.com, let it explore, then ask it 'how do you like the site?' AI-readable: https://www.tigzig.com/ai/posts/tigzig-agent-first-just-point-your-claude-jun2026.md - [The Data Behind My Analyses Is Now Open. Download the Whole Database or Query a Single Row.](https://www.tigzig.com/post/tigzig-apis-data-open-jun2026) - Tags: portfolio-quants, mcp The analyses I've been posting these past months all run on the same data - and that data is now open to everyone. US delinquencies, private credit, life insurance, the markets piece - all off primary data, FRED, RBI, Fed, FDIC, refreshed three times a day by the same pipeline that runs the live apps. Three open APIs powering the Tigzig apps: MF NAV (18,000+ schemes, 13 yrs, ~20M daily NAVs), VIGIL (corporate signals: ratings, insider, pledge, SAST, RPT), TREMOR (~300 macro indicators). Pull a single row across ~30 endpoints, or take the whole database from one endpoint in SQLite, DuckDB, Parquet, CSV or TSV - refreshed 3x a day by the CI/CD that powers the apps. Connect to the live MCP server, or wrap any of these APIs in your own MCP. No auth. Rate limited. Free to use. For humans: tigzig.com -> APIs. For agents: agents.tigzig.com. AI-readable: https://www.tigzig.com/ai/posts/tigzig-apis-data-open-jun2026.md - [MCP Guide for Claude in Excel - and any MCP client](https://www.tigzig.com/post/mcp-guide-claude-in-excel) - Tags: mcp, claude-in-excel, security 35-slide visual guide covering MCP (Model Context Protocol) from fundamentals to production deployment. Explains MCP vs regular APIs, schema documentation, common mistakes, and security hardening. Includes 5 live open-source MCP servers connecting to PostgreSQL, DuckDB, PDF/HTML files, and Python backends. Covers honest trade-offs around token overhead and context bloat. AI-readable: https://www.tigzig.com/ai/posts/mcp-guide-claude-in-excel.md - [Pull your quants numbers directly with Claude / ChatGPT in Excel (with MCP).](https://www.tigzig.com/post/qrep-mcp-quants-numbers-claude-chatgpt-excel) - Tags: mcp, quantstats, excel, open-source QREP MCP server for pulling 81 quant metrics (returns, sharpe, sortino, drawdowns) directly into Claude in Excel, ChatGPT in Excel, Claude Desktop, Cursor, n8n or any MCP client. Powered by QuantStats library. Free public server, full source code open. AI-readable: https://www.tigzig.com/ai/posts/qrep-mcp-quants-numbers-claude-chatgpt-excel.md - [Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate It.](https://www.tigzig.com/post/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools) - 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://www.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://www.tigzig.com/post/talk-to-your-database-from-excel-mcp-part-2) - 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://www.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://www.tigzig.com/post/mcp-server-bot-attack-security-lessons) - 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://www.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://www.tigzig.com/post/talk-to-your-database-from-excel-postgres-duckdb-claude-mcp) - 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://www.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://www.tigzig.com/post/claude-in-excel-mcp-connector-talk-to-backends) - 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://www.tigzig.com/ai/posts/claude-in-excel-mcp-connector-talk-to-backends.md - [Live Portfolio Analytics - Powered by MCP Servers - Open Source](https://www.tigzig.com/post/open-so) - 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://www.tigzig.com/ai/posts/open-so.md - [ChatGPT Connected to integrated FastAPI-MCP Servers.. Technical Analysis (TA) report. From stocks to crypto.](https://www.tigzig.com/post/chatgpt-connected-fastapi-mcp-servers-technical-analysis-ta-report-stocks-crypto) - 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://www.tigzig.com/ai/posts/chatgpt-connected-fastapi-mcp-servers-technical-analysis-ta-report-stocks-crypto.md - [Build AI Workflows with MCP Servers + n8n](https://www.tigzig.com/post/build-ai-workflows-mcp-servers-n8n-technical-analysis) - 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://www.tigzig.com/ai/posts/build-ai-workflows-mcp-servers-n8n-technical-analysis.md ## Related Topics - [Database AI & Text-to-SQL](https://www.tigzig.com/ai/tags/database-ai.md) - [Python in Excel (xlwings Lite)](https://www.tigzig.com/ai/tags/python-in-excel.md) - [Claude in Excel](https://www.tigzig.com/ai/tags/claude-in-excel.md) - [DuckDB - Analytics & Dashboards](https://www.tigzig.com/ai/tags/duckdb.md) - [Portfolio & Quantitative Analysis](https://www.tigzig.com/ai/tags/portfolio-quants.md) --- ## About **Amar Harolikar** - Specialist, Decision Sciences & Applied Generative AI - Email: amar@harolikar.com - LinkedIn: https://www.linkedin.com/in/amarharolikar - GitHub: https://github.com/amararun - Site: https://www.tigzig.com ## Legal - Privacy: https://www.tigzig.com/privacy - Terms: https://www.tigzig.com/terms --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/ai/tags/mcp-servers.md Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms