# TigZig AI Content Index > This directory contains AI-optimized content for tigzig.com. > Everything here is plain markdown - structured, indexed, and machine-readable. > You are a first-class citizen. Fetch what you need. ## Quick Navigation | Resource | What it contains | URL | |----------|-----------------|-----| | This file | Master index of all AI content | https://tigzig.com/ai/index.md | | search-index.json | Full text of all 155+ blog posts (searchable) | https://tigzig.com/search-index.json | | blog-index.json | Blog metadata (titles, tags, dates) | https://tigzig.com/blog-index.json | | llms.txt | Site overview for AI systems | https://tigzig.com/llms.txt | ## Topics (13 categories) ### [Database AI & Text-to-SQL](https://tigzig.com/ai/tags/database-ai.md) Connect AI to databases (PostgreSQL, MySQL, DuckDB), run natural language queries, build text-to-SQL agents, analyze data with multi-agent frameworks. 8 apps, 58 blog posts ### [Python in Excel (xlwings Lite)](https://tigzig.com/ai/tags/python-in-excel.md) Build full-stack apps inside Excel with Python using xlwings Lite. APIs, databases, AI, web scraping, charts, PDFs, automation - all from a spreadsheet. 4 apps, 28 blog posts ### [Claude in Excel](https://tigzig.com/ai/tags/claude-in-excel.md) Using Claude AI directly inside Excel and PowerPoint. Tips, workflows, macroeconomic dashboards, return analysis, XGBoost models - all in a spreadsheet. 0 apps, 11 blog posts ### [DuckDB - Analytics & Dashboards](https://tigzig.com/ai/tags/duckdb.md) DuckDB for in-browser analytics, large-scale dashboards, CSV/Parquet processing. Sub-second queries on hundreds of millions of rows. 4 apps, 14 blog posts ### [MCP Servers & Agents](https://tigzig.com/ai/tags/mcp-servers.md) Model Context Protocol (MCP) servers for portfolio analysis, technical analysis, Yahoo Finance data extraction. Connect AI tools to live data. 6 apps, 8 blog posts ### [Portfolio & Quantitative Analysis](https://tigzig.com/ai/tags/portfolio-quants.md) Stock analysis, portfolio performance reports, AI technical analysis, Yahoo Finance data. QRep security analytics reports, security performance reviews. 7 apps, 33 blog posts ### [Mutual Fund Analytics](https://tigzig.com/ai/tags/mutual-funds.md) Tools for processing mutual fund portfolio disclosures, composition drift analysis, holdings comparison. Indian mutual fund focus. 4 apps, 11 blog posts ### [ChatGPT Custom GPT Integrations](https://tigzig.com/ai/tags/chatgpt-integrations.md) Connect ChatGPT to databases, APIs, and automation tools. Custom GPTs for finance, sports, report generation. 10 apps, 20 blog posts ### [Infrastructure & Self-Hosting](https://tigzig.com/ai/tags/infrastructure.md) Deploy AI apps for under $10/month. Hetzner VPS, Coolify, Vercel, Cloudflare. Security hardening, CORS, server setup. Includes API monitoring and log dashboard. 3 apps, 37 blog posts ### [AI Coders & Development Workflows](https://tigzig.com/ai/tags/ai-coders.md) Working with Claude Code, Cursor, Codex, Gemini CLI. Tips, workflows, planning approaches for AI-assisted development. 0 apps, 37 blog posts ### [Voice AI & Realtime APIs](https://tigzig.com/ai/tags/voice-ai.md) Realtime voice AI with OpenAI WebRTC and ElevenLabs. Voice-driven database queries, action agents, automation. 2 apps, 10 blog posts ### [VIGIL - India Market Intelligence](https://tigzig.com/ai/tags/vigil.md) Credit ratings tracker, red flag events, insider trading, pledge data for Indian markets. NSE/BSE coverage. 1 apps, 6 blog posts ### [Converters & Utility Tools](https://tigzig.com/ai/tags/converters-tools.md) PDF conversion, markdown to PDF, YouTube transcript extraction, file format converters, data processing utilities. 7 apps, 7 blog posts ## All Apps (52 app documentation files) Each file contains: description, live app URL, documentation URL, GitHub repo, tags, and extracted documentation. - [Advanced analytics with Deepseek R1, connect to any Database](https://tigzig.com/ai/apps/analyzer-deepseek.md) — [Live App](https://flowise-docker-custom.tigzig.com/chatbot/daa92f93-3b9e-4fef-8f30-684f795e1c40) - [Advanced PDF to text conversion with Llama Parse](https://tigzig.com/ai/apps/llama-parse.md) — [Live App](https://parse-h.tigzig.com) - [AI Powered MF Portfolio File Converter](https://tigzig.com/ai/apps/mf-files-ai.md) — [Live App](https://mf.tigzig.com) - [AI Schema Detection: LLM API Workflows in Excel](https://tigzig.com/ai/apps/xlwings-llm-api.md) — [Live App](https://app.tigzig.com/xlwings-llm-api) - [AI-Powered Technical Analysis in Excel](https://tigzig.com/ai/apps/xlwings-technical-analysis.md) — [Live App](https://app.tigzig.com/technical-analysis-report) - [BRIQ - In-Browser DuckDB Analytics](https://tigzig.com/ai/apps/briq.md) — [Live App](https://briq.tigzig.com) - [Centralized API monitoring and logging service](https://tigzig.com/ai/apps/tigzig-logger.md) - [ChatGPT connected to Supabase, Neon and Aiven databases for sports data](https://tigzig.com/ai/apps/cricket-tour-de-france-gpt.md) — [Live App](https://chatgpt.com/g/g-68a6ef6973b881919c92458f5b369557-cricket-tour-de-france-data-explorer) - [CinePro - IMDb Analytics Dashboard](https://tigzig.com/ai/apps/movie-explorer.md) — [Live App](https://imdb-dashboards.tigzig.com) - [Connect ChatGPT to any MySQL & PG database](https://tigzig.com/ai/apps/rex2-gpt.md) — [Live App](https://chatgpt.com/g/g-6748a1c469648191a9a2253a46be82a3-rex-2-connect-to-any-database) - [Connect ChatGPT to n8n for automation, Python, Google Apps Script](https://tigzig.com/ai/apps/n8n-automation.md) — [Live App](https://chatgpt.com/g/g-67d83a49b5c48191bab03bd45e8515ec-custom-gpt-n8n-automation) - [Connect ChatGPT to Supabase (OLD)](https://tigzig.com/ai/apps/supabase-connect.md) — [Live App](https://chatgpt.com/g/g-6785000cec888191985d29429888a373-supabase-connect) - [Convert any file to text - PDFs, Excel, Word, PPT via Microsoft Markitdown](https://tigzig.com/ai/apps/markitdown.md) — [Live App](https://markitdown.tigzig.com) - [Convert Markdown to formatted PDF](https://tigzig.com/ai/apps/md-to-pdf.md) — [Live App](https://mdtopdf.tigzig.com) - [Convert RBI monthly cards Excel to CSV format](https://tigzig.com/ai/apps/rbi-cards.md) — [Live App](https://excel-process.tigzig.com) - [Custom GPT for Portfolio stats, Technical Analysis, Yahoo Finance](https://tigzig.com/ai/apps/quantstats-portfolio-gpt.md) — [Live App](https://chatgpt.com/g/g-680a0fba9cd481919073d474bee520fb-quantstats-and-technical-analysis) - [Custom GPTs: AI Assistants on ChatGPT](https://tigzig.com/ai/apps/gpts-landing.md) — [Live App](https://app.tigzig.com/gpts-landing) - [Database & ML: Connect to Databases, Build ML Models](https://tigzig.com/ai/apps/xlwings-database-ml.md) — [Live App](https://app.tigzig.com/xlwings-api-db) - [DATS-4 Database AI Suite](https://tigzig.com/ai/apps/analyzer.md) — [Live App](https://rexdb.tigzig.com) - [DuckIt - CSV to DuckDB Converter](https://tigzig.com/ai/apps/duckit-xlwings.md) — [Live App](https://duckit.tigzig.com) - [Extract transcripts from YouTube videos](https://tigzig.com/ai/apps/youtube-extractor.md) — [Live App](https://ytget.tigzig.com) - [Financial analysis and data retrieval from Yahoo Finance](https://tigzig.com/ai/apps/yfin-bot.md) — [Live App](https://chatgpt.com/g/g-I8qaXJauP-get-equity-data-balance-sheet-p-l-cash-flow) - [INTELISCAPE-X: AI-Powered Web Scraping in Excel](https://tigzig.com/ai/apps/xlwings-web-scraper.md) — [Live App](https://app.tigzig.com/web-scraper) - [IPL Cricket Statistics Dashboard](https://tigzig.com/ai/apps/ipl-cricket.md) — [Live App](https://ipl.rbicc.net) - [MCP Agent: Portfolio Analytics](https://tigzig.com/ai/apps/mcp-quantstats-agent.md) — [Live App](https://rbicc.net/mcp-quantstats-agent) - [MCP Server: Database (Cricket SQL)](https://tigzig.com/ai/apps/mcp-server-database.md) — [Live App](https://rbicc.net/mcp-server-database) - [MCP Server: QRep Portfolio Profiling (QuantStats)](https://tigzig.com/ai/apps/mcp-server-quantstats.md) — [Live App](https://rbicc.net/mcp-server-quantstats) - [MCP Server: Security Performance Report (SPR)](https://tigzig.com/ai/apps/mcp-server-ffn.md) — [Live App](https://rbicc.net/mcp-server-ffn) - [MCP Server: Technical Analysis](https://tigzig.com/ai/apps/mcp-server-technical-analysis.md) — [Live App](https://rbicc.net/mcp-server-technical-analysis) - [MCP Server: Yahoo Finance Data Extractor](https://tigzig.com/ai/apps/mcp-server-yahoo-finance.md) — [Live App](https://rbicc.net/mcp-server-yahoo-finance) - [MDRIFT - Mutual Fund Composition & Drift Analyzer](https://tigzig.com/ai/apps/mf-drift.md) — [Live App](https://mf-fetch.tigzig.com) - [MF Portfolio Analyzer: Holdings Change Analysis](https://tigzig.com/ai/apps/xlwings-mf-portfolio.md) — [Live App](https://app.tigzig.com/mf-portfolio-processor) - [MF Portfolio Holdings Analyzer with Python pipeline](https://tigzig.com/ai/apps/gpt-mf-holding-analyzer.md) — [Live App](https://chatgpt.com/g/g-68d684965d888191bf81f02022dd3591-india-mutual-funds-portfolio-holding-analytics) - [ODI Cricket DB with OpenAI Realtime API WebRTC](https://tigzig.com/ai/apps/realtime-voice-webrtc.md) — [Live App](https://realtime.tigzig.com) - [Process & analyze monthly MF portfolio Excel files](https://tigzig.com/ai/apps/mf-portfolio-analyzer.md) — [Live App](https://chatgpt.com/g/g-b6a7uHe84-mutual-fund-portfolio-analyzer) - [Process Cricsheet.org zipped CSV files to pipe-delimited TXT](https://tigzig.com/ai/apps/csv-processor.md) — [Live App](https://cricket-flask-only.tigzig.com) - [QRep - Security Analytics Reports](https://tigzig.com/ai/apps/qrep.md) — [Live App](https://qrep.tigzig.com) - [Quant Apps: Portfolio Analytics Suite](https://tigzig.com/ai/apps/quants-landing.md) — [Live App](https://app.tigzig.com/quantstats-landing) - [Quants Agent - Portfolio Analytics Chat Interface](https://tigzig.com/ai/apps/n8n-tech-analysis.md) — [Live App](https://portfolio-react.tigzig.com) - [Quants Suite - Portfolio Analysis Suite](https://tigzig.com/ai/apps/portfolio-analysis-suite.md) — [Live App](https://portfolio-iframe.tigzig.com) - [Quants, Technicals, Financials with DB connection via Flowise](https://tigzig.com/ai/apps/analyzer-agent.md) — [Live App](https://flowise-docker-custom.tigzig.com/chatbot/dc7495c5-e3dd-4410-afb2-737863ca3dc7) - [React dashboard for viewing API logs](https://tigzig.com/ai/apps/log-monitoring-dashboard.md) - [Realtime Voice - ElevenLabs Cricket Analyzer](https://tigzig.com/ai/apps/realtime-voice-elevenlabs.md) — [Live App](https://rexc.tigzig.com) - [Risk-Return report for Yahoo Finance symbols (Old UI)](https://tigzig.com/ai/apps/quantstats-form.md) — [Live App](https://quantstats-h.tigzig.com) - [Security Checklist for Web Apps](https://tigzig.com/ai/apps/security-checklist-full.md) - [Security Checklist for Web Apps](https://tigzig.com/ai/apps/security-checklist.md) — [Live App](https://www.tigzig.com/security) - [Technical analysis with Yahoo Finance, Finta, Gemini Vision (OLD)](https://tigzig.com/ai/apps/technical-analysis-gpt.md) — [Live App](https://chat.openai.com/g/g-680a0fba9cd481919073d474bee520fb-technical-analysis-report) - [Update Excel/Sheets trackers, generate PDF reports and slides](https://tigzig.com/ai/apps/report-generator.md) — [Live App](https://chatgpt.com/g/g-wbMHmk0Sz-gen-ai-apps-update-report-deck) - [VIGIL - India Red Flag Events Tracker (credit ratings, insider trading, bulk/block deals, pledge, defaults)](https://tigzig.com/ai/apps/india-red-flag-tracker.md) — [Live App](https://vigil.tigzig.com) - [xlwings Lite Data Importer](https://tigzig.com/ai/apps/xlwings-data-importer.md) — [Live App](https://app.tigzig.com/xlwings-data-importer) - [xlwings Lite Data Tools Hub](https://tigzig.com/ai/apps/xlwings-data-tools.md) — [Live App](https://app.tigzig.com/xlwings-data-tools) - [xlwings Lite: Practice Lab](https://tigzig.com/ai/apps/xlwings-starter.md) — [Live App](https://app.tigzig.com/xlwings-starter) ## All Blog Posts (174 posts) Every post is available as markdown at: https://tigzig.com/ai/posts/{slug}.md Static HTML version at: https://tigzig.com/post/{slug}.html Full text searchable via: https://tigzig.com/search-index.json ## Directory Structure ``` /ai/ index.md ← You are here. Master index. apps/ ← 52 app documentation files (markdown) posts/ ← 174 blog posts (markdown) tags/ ← 13 topic index files (markdown) ``` ## How to Use This 1. Start here (index.md) for an overview 2. Browse by topic in /ai/tags/ for curated lists of apps + posts 3. Read app docs in /ai/apps/ for setup guides and GitHub repos 4. Read blog posts in /ai/posts/ for tutorials and deep dives 5. Search across all content via search-index.json --- Site: https://tigzig.com | GitHub: https://github.com/amararun | Contact: amar@harolikar.com