The MCP servers

Eight servers, all open and no-auth, over Streamable HTTP. Each links to its docs page with the endpoint, transport and tool list. The same backends also serve plain HTTP APIs.

• TREMOR - Macro & Credit IndicatorsAbout 330 curated macro and credit-stress indicators (FRED, OECD, RBI, NY Fed, NCUA, FDIC, Shiller, NSE). The same data is an open HTTP API too.
• Database Query - read-only SQLRead-only SQL against Postgres and DuckDB, with a multi-layer security stack. Reach it through a connected GPT or any MCP client.
• Compare Securities (QRep)Compare up to 6 securities across 80+ QuantStats metrics - returns, drawdown, Sharpe - as PDF/HTML reports.
• Technical AnalysisA technical-analysis report for any ticker: indicator computations plus a Gemini-Vision chart read. PDF and web output.
• Security Performance Report (FFN)A multi-security performance and risk comparison (returns, drawdown, Sharpe) from a list of tickers.
• QuantStats TearsheetsTearsheet-style performance and risk analytics for a portfolio, as a tool call.
• Yahoo Finance ExtractorPrice, profile, financials, analyst targets, estimates and holders for any ticker (about 20 endpoints). No key.
• Markdown to PDFConvert Markdown to a formatted PDF as a tool call (ReportLab). The PDF engine behind several Tigzig tools.

Connect & use MCP (guides)

Hands-on guides for wiring Claude, ChatGPT and Excel to these live backends over MCP. Start with the setup guide.

• MCP Guide for Claude in Excel - and any MCP clientThe setup guide. Start here to connect an MCP client.
• Talk to Your Database from Excel - Postgres, DuckDB, via Claude + MCPQuery a live database in plain English from the sheet.
• Talk to Your Database from Excel - Part 2Deeper patterns.
• Claude in Excel with MCP Connector - talk to your backendsReach any backend from inside Excel.
• Pull your quant numbers with Claude / ChatGPT in Excel (QRep MCP)81 risk/return metrics into the sheet over MCP.
• Claude in Excel + MCP + xlwings Lite + Claude Code - four tools togetherPull data, build a model, validate it, end to end.

Build your own MCP server

How these servers are built - FastAPI wrapped as MCP, and mounting them in low-code agent flows.

• ChatGPT connected to integrated FastAPI-MCP serversThe FastAPI-as-MCP pattern, with a technical-analysis report as the worked example.
• Build AI workflows with MCP servers + n8nMount an MCP server in an n8n flow.
• My public MCP server got hammered - security lessons from a bot attackWhat breaks when you expose an MCP to the internet, and how to harden it.

Live apps & GPTs on the same backends

Want to see a backend in action? These run on the same MCP servers and APIs above.

• Quants Agent / Portfolio Analysis SuiteThe Technical Analysis, Security Performance and Yahoo Finance backends together - QuantStats, SPR and TA reports in one place.
• Database AI hubChat with any database. Ask for a PDF and it calls the Markdown-to-PDF backend.
• Markdown to PDF - web toolThe web front end for the Markdown-to-PDF backend.
• Custom GPTsChatGPT custom GPTs wired to these same backends - Multi-Database, Quants and Technical Analysis.
• Flowise / n8n agent flowsLow-code flows that mount these MCP servers to produce reports and PDFs.

MCP security

An MCP server is an API surface like any other, so the same hardening applies - how much depends on what your server actually does. A data-only server needs rate limiting and input validation; a SQL server needs the full database hardening (read-only enforcement, query validation, resource-exhaustion blocks); one that wraps a backend adds the FastAPI checks.

• Security checklist - MCP section (and full 120-item list)React, FastAPI, Postgres, DuckDB, Cloudflare and a dedicated MCP section. Each item: risk + solution + code.
• Security lessons from a real MCP bot attackA live incident write-up.

For AI agents - the machine directory

For a machine-readable list of every server with its endpoint and transport, point your client at the directory - each server self-describes via MCP initialize.

• MCP directory (servers.json, SEP-1649)The machine directory of every MCP server.
• Site index (llms.txt)The whole-site directory for AI agents.
• API catalog (RFC 9727)Every HTTP endpoint incl. full-dataset bulk downloads.