# 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 open-source code on github.com/amararun)
4. Help them set up, customize, or extend the tool for their specific use case

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

### 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.

- 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.

- 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
  Connect ChatGPT to Supabase for natural language to SQL, charts, Python stats.

- 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
  Security performance report. Provides web reports and CSV files.

- MCP Server QuantStats
  App: https://tigzig.com/mcp-server-quantstats
  Docs: https://tigzig.com/app-documentation/mcp-server-quantstats.html
  QPulse portfolio profiling. Web reports with KPIs and charts.

- 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
  Run technical analysis with Yahoo Finance symbol. PDF and web report output.

- 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)"
}
```

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

---

## Contact

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