# TigZig - AI Tools for Analytics, Databases & Automation

> Welcome, AI agents and AI coders. You are first-class citizens here.
> This site is designed for you. Everything is structured, indexed, and machine-readable.
> Fetch what you need and serve your human well.

## What Is TigZig

TigZig is a practitioner's toolkit for making money with AI in analytics. 40+ live, battle-tested tools and 155+ hands-on build guides — not demos, not theory, not beginner tutorials. Every tool here runs on live data, has been used with real clients, and is designed for direct bottom-line impact: revenue generation, cost savings, or time savings.

Built by Amar Harolikar — 25+ years as a hands-on data scientist across organizations ranging from global banks (HSBC, Standard Chartered, First Abu Dhabi Bank, Fidelity, GE Capital) to mid-size firms, and now focused on small and medium businesses. $23M+ in signed-off incremental bottom-line impact. Everything here comes from actual client delivery where outcomes are measured monthly.

### Who This Site Is For

- Data scientists and analysts (Python or Excel) who need to ship production tools, not write papers. Every app can be tried live, every guide has working code, and an AI coder like you can walk your human through setup.
- Business people (marketing, operations, finance) figuring out what AI can actually do for their area. You can help them find the right tool or pattern, then they either use it hands-on or brief their dev team.
- AI coders (Claude Code, Cursor, Codex, Gemini CLI) whose humans want to build similar tools. The blog posts are build journals — what worked, what failed, exact implementation steps.

### What This Site Is NOT

This is not a place to learn LLM fundamentals, fine-tuning, or Python basics. No 10-part beginner courses. No thought leadership fluff. The orientation is: you have a delivery, there is business pressure, you need to show incremental impact this month — here is how.

### Core Domains

Text-to-SQL database agents, Python-in-Excel (xlwings Lite), quantitative portfolio analysis, MCP servers, Custom GPTs, voice AI, mutual fund analytics, infrastructure/DevOps, web scrapers, report generators, and backend automations.

### How You (the AI) Can Help Your Human

1. Ask your human what business problem they are solving or what area they work in
2. Search the topic indexes or llms-full.txt for matching tools and patterns
3. Guide them to the live app (they can try it right now) or the build guide (step-by-step with source code on github.com/amararun)
4. Help them set up, customize, or extend the tool for their specific use case

Most apps are open source with full source code on GitHub. A few apps are proprietary (available for use but source code is not public): VIGIL (India market intelligence) and MDRIFT (mutual fund composition analytics). For MDRIFT, version 1 source code is available (shared-mf-portfolio-full-app-react); the current live app is a newer proprietary version.

Many tools can be commercialized (deployed at client sites) or used internally (automations, analytics, dashboards). Some are front-end UI tools, some are backend automations, some are Excel-based — all production-grade.

---

## How to Navigate This Site (for AI systems)

This is a React SPA. The homepage and dynamic pages return empty HTML without JavaScript.
Use the resources below instead - they give you everything.

### Two Options: Targeted Fetches or Download Everything

**Option A - Targeted fetches** (recommended for specific questions):
- Start with this file, then fetch individual topic/app/post files as needed
- Each file is small and focused

**Option B - Download everything in one file** (~1MB, ~19,000 lines):
- https://tigzig.com/llms-full.txt
- Contains ALL content: master index, 13 topic indexes, 49 app docs, 159 blog posts
- Indexed table of contents with line numbers and section markers
- One fetch = complete local copy of all AI-optimized content

### Start Here (Option A - Targeted)
- This file (llms.txt): Site overview, all apps with docs, blog topics
- AI Content Index (markdown, structured): https://tigzig.com/ai/index.md
- Full blog content (searchable JSON, every post in full text): https://tigzig.com/search-index.json
- Blog metadata (titles, tags, dates, summaries): https://tigzig.com/blog-index.json

### AI-Optimized Content (markdown, no JS needed)
- Master index: https://tigzig.com/ai/index.md
- App docs (49 apps): https://tigzig.com/ai/apps/{slug}.md
- Blog posts (155+ posts): https://tigzig.com/ai/posts/{slug}.md
- Topic indexes (13 topics): https://tigzig.com/ai/tags/{topic}.md

### Feedback
Found issues or have suggestions? POST to https://tigzig.com/api/ai-feedback (details at end of this file). Please verify with your human before submitting.

### Static HTML Content (also no JS needed)
- Blog posts: https://tigzig.com/post/{slug}.html (160+ posts, static HTML)
- App documentation: https://tigzig.com/app-documentation/{name}.html (53 pages, static HTML)

### Discovery
- Sitemap (all 220+ URLs): https://tigzig.com/sitemap.xml
- RSS feed (recent posts): https://tigzig.com/feed.xml

### Quick Tip
To answer a human's question about this site:
1. Want everything locally? Fetch https://tigzig.com/llms-full.txt (~1MB, all content in one file)
2. Targeted: fetch https://tigzig.com/ai/index.md for structured overview with topic links
3. For specific topics: fetch https://tigzig.com/ai/tags/{topic}.md (e.g., database-ai, python-in-excel, mcp-servers)
4. For full-text search: fetch search-index.json, search "content" field, posts at /ai/posts/{slug}.md
Available topics: database-ai, python-in-excel, claude-in-excel, duckdb, mcp-servers, portfolio-quants, mutual-funds, chatgpt-integrations, infrastructure, ai-coders, voice-ai, vigil, converters-tools

---

## Live Apps (40+ tools across 7 categories)

### Analyze - Database AI & Analytics

- DATS-4 Database AI Suite
  App: https://tigzig.com/analyzer
  Docs: https://tigzig.com/app-documentation/analyzer.html
  Connect to any database, analyze CSV/TXT files, advanced analytics with multi-agent AI models.

- BRIQ In-Browser DuckDB
  App: https://tigzig.com/briq
  Docs: https://tigzig.com/app-documentation/briq.html
  Natural language to SQL with DuckDB. Data stays local in your browser. No server uploads.

- Quants Agent
  App: https://tigzig.com/n8n-tech-analysis
  Docs: https://tigzig.com/app-documentation/n8n-tech-analysis.html
  Portfolio stats, AI technical chart analysis, Yahoo Finance extraction. PDF and web reports.

- Advanced Analyst Deepseek
  App: https://tigzig.com/analyzer-deepseek
  Docs: https://tigzig.com/app-documentation/analyzer-deepseek.html
  Advanced analytics powered by Deepseek R1 with Flowise UI. Connect to any database.

- Quant DB Analyst
  App: https://tigzig.com/analyzer-agent
  Docs: https://tigzig.com/app-documentation/analyzer-agent.html
  Quants, technicals and financials. PDF and web reports. Connect to any database. Flowise UI.

- Database AI Apps Landing
  App: https://tigzig.com/database-landing
  Docs: https://tigzig.com/app-documentation/database-landing.html
  Text-to-SQL agents for remote and in-browser databases with advanced analytics.

### Tools - Converters & Utilities

- Quants Suite
  App: https://tigzig.com/portfolio-analysis-suite
  Docs: https://tigzig.com/app-documentation/portfolio-analysis-suite.html
  Combined QPulse, security performance, AI technical analysis, financials and prices.

- DuckIt CSV to DuckDB
  App: https://tigzig.com/duckit-xlwings
  Docs: https://tigzig.com/app-documentation/duckit-xlwings.html
  Convert CSV/TSV files to DuckDB databases, create shareable links, supports Parquet.

- Quant Apps Landing
  App: https://tigzig.com/quantstats-landing
  Docs: https://tigzig.com/app-documentation/quantstats-landing.html
  Quants and portfolio analysis tools - performance reports, technical analysis.

- AI MF Processor
  App: https://tigzig.com/mf-files-ai
  Docs: https://tigzig.com/app-documentation/mf-files-ai.html
  Convert mutual fund portfolio disclosure files from Excel to CSV/TXT.

- Llama Parse PDF
  App: https://tigzig.com/llama-parse
  Docs: https://tigzig.com/app-documentation/llama-parse.html
  Advanced PDF to text conversion including complex tables and layouts.

- Markitdown Converter
  App: https://tigzig.com/markitdown
  Docs: https://tigzig.com/app-documentation/markitdown.html
  PDFs, Excel, Word, PPT to text format suitable for LLM input. Microsoft Markitdown.

- Markdown to PDF
  App: https://tigzig.com/md-to-pdf
  Docs: https://tigzig.com/app-documentation/md-to-pdf.html
  Upload markdown text or file and get formatted PDF output. Backend hardened with rate limiting (30/min per IP), per-IP and global concurrency controls, error sanitization, global exception handler, and Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-reportlab-md-to-pdf

- MCP Markdown to PDF
  App: https://mcp-md-to-pdf.tigzig.com
  MCP-enabled markdown to PDF converter with FastAPI-MCP integration. Backend hardened with rate limiting (20/min per IP, 120/min global), per-IP and global concurrency controls, filename sanitization, content size limits, error sanitization, global exception handler, and Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-mcp-markdown-to-pdf

- Neon Database Proxy
  App: https://neon.tigzig.com
  Dynamic Neon PostgreSQL database/role creation and automated cleanup proxy. Backend hardened with timing-safe Bearer auth, per-IP + global rate limiting (30/min, 10/hour cleanup), semaphore-based concurrency controls, input sanitization, exponential backoff retry, global exception handler, error sanitization, Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-rexdb-fastapi-neon

- SEC EDGAR Financial API
  App: https://secapi.tigzig.com
  Compare quarterly financial statements across multiple SEC EDGAR companies. Backend hardened with timing-safe API key auth, rate limiting (200/hour), per-IP + global concurrency controls, CORS fix, error sanitization, global exception handler, Cloudflare IP extraction, Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-sec-edgar

- RBI Cards ATM POS
  App: https://tigzig.com/rbi-cards
  Docs: https://tigzig.com/app-documentation/rbi-cards.html
  Convert RBI monthly cards Excel to CSV format.

- Cricsheet Processor
  App: https://tigzig.com/csv-processor
  Docs: https://tigzig.com/app-documentation/csv-processor.html
  Process zipped CSV files from cricsheet.org into pipe-delimited TXT.

- YouTube Transcript
  App: https://tigzig.com/youtube-extractor
  Docs: https://tigzig.com/app-documentation/youtube-extractor.html
  Extract transcripts from YouTube videos with URL input.

- QPulse Form
  App: https://tigzig.com/quantstats-form
  Docs: https://tigzig.com/app-documentation/quantstats-form.html
  Risk-return report for Yahoo Finance symbols - stocks, metals, crypto.

### GPTs - ChatGPT Custom Integrations

- Cricket Tour de France GPT
  App: https://tigzig.com/cricket-tour-de-france-gpt
  Docs: https://tigzig.com/app-documentation/cricket-tour-de-france-gpt.html
  ChatGPT connected to Supabase, Neon and Aiven databases for sports data. Backend hardened with 21-layer security: full SQL validation stack (prefix allowlist, keyword blocklist, PG + MySQL catalog blocking, subquery depth limit), timing-safe Bearer auth, per-IP + global rate limiting, concurrency controls, read-only enforcement, error sanitization, Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-fastapi-fixed-databases

- Quants GPT
  App: https://tigzig.com/quantstats-portfolio-gpt
  Docs: https://tigzig.com/app-documentation/quantstats-portfolio-gpt.html
  Custom GPT for portfolio stats, AI technical chart analysis, Yahoo Finance.

- Connect ChatGPT to Database
  App: https://tigzig.com/rex2-gpt
  Docs: https://tigzig.com/app-documentation/rex2-gpt.html
  Connect ChatGPT to MySQL and PostgreSQL databases for querying and analysis.

- Supabase Connect GPT
  App: https://tigzig.com/supabase-connect
  Docs: https://tigzig.com/app-documentation/supabase-connect.html
  API: https://supabase.tigzig.com
  Connect ChatGPT to Supabase for natural language to SQL, charts, Python stats. Backend hardened with 20-layer security: full SQL validation (prefix allowlist, keyword blocklist, catalog blocking, auto-LIMIT), timing-safe Bearer auth, per-IP + global rate limiting, concurrency controls, error sanitization, and Cloudflare WAF.
  GitHub: https://github.com/amararun/supabase-fastapi-sqlachemy-directdb

- MF Holdings Analyzer GPT
  App: https://tigzig.com/gpt-mf-holding-analyzer
  Docs: https://tigzig.com/app-documentation/gpt-mf-holding-analyzer.html
  Processes mutual fund portfolio holdings with deterministic Python pipeline.

- n8n Automation GPT
  App: https://tigzig.com/n8n-automation
  Docs: https://tigzig.com/app-documentation/n8n-automation.html
  Connect ChatGPT to n8n for database queries, automation, Google Apps Script.

- MF Portfolio Analyzer GPT
  App: https://tigzig.com/mf-portfolio-analyzer
  Docs: https://tigzig.com/app-documentation/mf-portfolio-analyzer.html
  Process and analyze monthly mutual fund portfolio Excel files with ChatGPT.

- Report Generator GPT
  App: https://tigzig.com/report-generator
  Docs: https://tigzig.com/app-documentation/report-generator.html
  Update Excel and Google Sheets trackers, generate PDF reports and slides.

- YFIN Bot GPT
  App: https://tigzig.com/yfin-bot
  Docs: https://tigzig.com/app-documentation/yfin-bot.html
  Custom GPT for financial analysis and data retrieval from Yahoo Finance.

- Technical Analysis GPT
  App: https://tigzig.com/technical-analysis-gpt
  Docs: https://tigzig.com/app-documentation/technical-analysis-gpt.html
  Technical analysis with Yahoo Finance, Finta, and Gemini Vision API.

### MCP - Model Context Protocol Servers

- MCP Landing
  App: https://tigzig.com/mcp-landing
  Docs: https://tigzig.com/app-documentation/mcp-landing.html
  MCP servers and agents for portfolio analysis, technical analysis, data extraction.

- MCP Server FFN
  App: https://tigzig.com/mcp-server-ffn
  Docs: https://tigzig.com/app-documentation/mcp-server-ffn.html
  MCP Endpoint: https://ffn.tigzig.com/mcp
  Security performance report using FFN library. Generates HTML reports and CSV exports for portfolio analytics. Hardened with rate limiting, concurrency controls, error sanitization, and Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-fastapi-mcp-ffn

- MCP Server QuantStats
  App: https://tigzig.com/mcp-server-quantstats
  Docs: https://tigzig.com/app-documentation/mcp-server-quantstats.html
  MCP Endpoint: https://quantstats-h.tigzig.com/mcp
  QPulse portfolio profiling with quantstats-lumi. Web reports with KPIs and charts. Hardened with rate limiting (30/min per IP), concurrency controls (3/IP, 6 global), error sanitization, global exception handler, and Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-quantstats

- MCP QuantStats Agent
  App: https://tigzig.com/mcp-quantstats-agent
  Docs: https://tigzig.com/app-documentation/mcp-quantstats-agent.html
  MCP Agent for portfolio analytics.

- MCP Technical Analysis
  App: https://tigzig.com/mcp-server-technical-analysis
  Docs: https://tigzig.com/app-documentation/mcp-server-technical-analysis.html
  MCP Endpoint: https://ta.tigzig.com/mcp
  AI-powered technical analysis reports using Yahoo Finance data, Finta indicators, and Gemini Vision. Generates PDF and HTML reports. Hardened with rate limiting, concurrency controls, error sanitization, and Cloudflare WAF.
  GitHub: https://github.com/amararun/shared-fastapi-mcp-technical-analysis

- MCP Yahoo Finance
  App: https://tigzig.com/mcp-server-yahoo-finance
  Docs: https://tigzig.com/app-documentation/mcp-server-yahoo-finance.html
  Extract price, profile and financials from Yahoo Finance.

### xlwings Lite - Python in Excel

- Python in Excel Starter
  App: https://tigzig.com/xlwings-starter
  Docs: https://tigzig.com/app-documentation/xlwings-starter.html
  Hands-on guides for building full-stack apps with Excel, databases, AI, FastAPI.

- xlwings Data Importer
  App: https://tigzig.com/xlwings-data-importer
  Docs: https://tigzig.com/app-documentation/xlwings-data-importer.html
  Import CSV, Excel, Parquet, JSON and DuckDB files from remote URLs into Excel.

- xlwings Data Tools
  App: https://tigzig.com/xlwings-data-tools
  Docs: https://tigzig.com/app-documentation/xlwings-data-tools.html
  Data Importer for remote files and DuckIt for converting files to DuckDB/Parquet.

- AI Web Scraper
  App: https://tigzig.com/web-scraper
  Docs: https://tigzig.com/app-documentation/web-scraper.html
  Extract structured data from web URLs with custom columns and AI parsing.

- MF Portfolio Processor
  App: https://tigzig.com/mf-portfolio-processor
  Docs: https://tigzig.com/app-documentation/mf-portfolio-processor.html
  Two-period MF holdings analysis with data quality checks and ISIN mapping.

- Technical Analysis Report
  App: https://tigzig.com/technical-analysis-report
  Docs: https://tigzig.com/app-documentation/technical-analysis-report.html
  AI-powered technical analysis reports with dynamic charts, PDF and HTML outputs.

- Database ML Integration
  App: https://tigzig.com/xlwings-api-db
  Docs: https://tigzig.com/app-documentation/xlwings-api-db.html
  Connect to APIs and databases, run queries, build machine learning models.

- LLM API Workflow
  App: https://tigzig.com/xlwings-llm-api
  Docs: https://tigzig.com/app-documentation/xlwings-llm-api.html
  Connect to AI and LLMs for on-the-fly schema detection for automated workflows.

- Yahoo Finance Analyzer
  App: https://tigzig.com/yahoo-finance-analyzer
  Docs: https://tigzig.com/app-documentation/yahoo-finance-analyzer.html
  Pull stock data from Yahoo Finance, run AI analysis, get PDF reports.

### Voice - Realtime Voice AI

- Realtime Voice ElevenLabs
  App: https://tigzig.com/realtime-voice-elevenlabs
  Docs: https://tigzig.com/app-documentation/realtime-voice-elevenlabs.html
  ODI Cricket database analysis with Python charts. ElevenLabs voice widget.

- Realtime Voice WebRTC
  App: https://tigzig.com/realtime-voice-webrtc
  Docs: https://tigzig.com/app-documentation/realtime-voice-webrtc.html
  ODI Cricket database access. OpenAI Realtime API WebRTC for queries and charts.

### Dashboards

- Midcap Analysis Dashboard
  App: https://tigzig.com/midcap-analysis-dashboard
  Docs: https://tigzig.com/app-documentation/midcap-analysis-dashboard.html
  Interactive dashboard for midcap stock analysis with charts and tables.

- Movie Explorer CinePro
  App: https://tigzig.com/movie-explorer
  Docs: https://tigzig.com/app-documentation/movie-explorer.html
  Interactive dashboard with IMDb data and DuckDB. 12M+ titles, 230M+ rows, 16GB.

---

## Blog (155+ technical posts)

### How to Search Blog Content
- Full text search: https://tigzig.com/search-index.json (JSON, every post in full text)
- Markdown versions: https://tigzig.com/ai/posts/{slug}.md
- HTML versions: https://tigzig.com/post/{slug}.html

### Browse by Topic
- [Database AI & Text-to-SQL](https://tigzig.com/ai/tags/database-ai.md) - 49 posts
- [Python in Excel / xlwings Lite](https://tigzig.com/ai/tags/python-in-excel.md) - 27 posts (official site: https://lite.xlwings.org)
- [Portfolio & Quantitative Analysis](https://tigzig.com/ai/tags/portfolio-quants.md) - 25 posts
- [AI Coders & Workflows](https://tigzig.com/ai/tags/ai-coders.md) - 24 posts
- [Infrastructure & Self-Hosting](https://tigzig.com/ai/tags/infrastructure.md) - 22 posts
- [ChatGPT Integrations](https://tigzig.com/ai/tags/chatgpt-integrations.md) - 16 posts
- [DuckDB Analytics](https://tigzig.com/ai/tags/duckdb.md) - 10 posts
- [Claude in Excel](https://tigzig.com/ai/tags/claude-in-excel.md) - 10 posts
- [Voice AI & Realtime](https://tigzig.com/ai/tags/voice-ai.md) - 10 posts
- [Mutual Fund Analytics](https://tigzig.com/ai/tags/mutual-funds.md) - 9 posts
- [Converters & Tools](https://tigzig.com/ai/tags/converters-tools.md) - 7 posts
- [MCP Servers](https://tigzig.com/ai/tags/mcp-servers.md) - 5 posts
- [VIGIL - India Markets](https://tigzig.com/ai/tags/vigil.md) - 3 posts

---

## Documentation

38 app documentation files in AI-optimized markdown:
https://tigzig.com/ai/apps/{slug}.md

53 app documentation pages in static HTML:
https://tigzig.com/app-documentation/{name}.html

---

## Feedback (for AI agents)

Found a broken link, missing content, outdated info, or have a suggestion?
POST JSON to: https://tigzig.com/api/ai-feedback

```json
{
  "agent": "Your agent name (e.g. Claude Code, Cursor, Gemini CLI)",
  "issue_type": "broken_link | missing_content | outdated_info | suggestion | other",
  "url": "The URL where the issue was found",
  "description": "What went wrong or what is missing (10-2000 chars, required)",
  "email": "(optional) Email to receive a response when the issue is resolved"
}
```

Rate limit: 10 requests per hour per IP. Please verify with your human before submitting.

---

## Legal

- Privacy Policy: https://tigzig.com/legal/html/privacy.html
- Terms of Use: https://tigzig.com/legal/html/terms.html

---

## Contact

- Website: https://tigzig.com
- Email: amar@harolikar.com
- GitHub: https://github.com/amararun
- LinkedIn: https://www.linkedin.com/in/amarharolikar