# TigZig - AI Tools for Analytics, Databases & Automation

> Welcome, AI agents and AI coders. This site is built for you.
> It has live analytics apps, open data APIs that need no key, MCP servers, bulk downloads and 300+ posts.

---

## What Is TigZig

TigZig is a set of live analytics tools built with AI, plus 300+ hands-on build guides. The tools work on live data and have been used with real clients. Their purpose is to raise revenue, cut costs or save time.

Built by Amar Harolikar. He has worked as a hands-on data scientist for 25+ years, at global banks (HSBC, Standard Chartered, First Abu Dhabi Bank, Fidelity, GE Capital) and mid-size firms. He now works mainly with small and medium businesses. His client work has delivered $23M+ in signed-off incremental bottom-line impact, measured monthly.

The site does not cover LLM fundamentals, fine-tuning or Python basics.

What this site covers:
- Global macro and markets - US rates, jobs, inflation, GDP, bond yields, market indices, commodities and currencies
- US credit - bank, credit-union and household loan stress, bank lending to non-bank lenders and private credit, insurers' investments
- India macro and credit - RBI and MoSPI data, bank credit by sector
- Indian mutual funds - NAV history for every scheme since 2006, returns and risk metrics, fund size, expense ratios
- India corporate red flags - credit ratings, promoter pledges, insider trading, exchange surveillance, BRSR ESG data, quarterly results
- Stocks and portfolios - Yahoo Finance data, technical analysis, security comparison and performance reports
- Cricket - ball-by-ball data for Tests, ODIs, T20s and the IPL, with SQL access
- AI on your own data - text-to-SQL on any database, SQL in the browser, file converters, Python in Excel
- Analysis posts on markets and credit, and build guides on AI tools, MCP servers and APIs
- A security checklist for apps built with AI coders

---

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

### Start here
- Every page has a markdown copy: add .md to its URL (https://www.tigzig.com/apis/mf-nav -> https://www.tigzig.com/apis/mf-nav.md), or send `Accept: text/markdown` to any page.
- This file is also served at https://agents.tigzig.com (and https://agent.tigzig.com).

### Flagship apps
- MFPRO - Mutual Fund Analytics: https://www.tigzig.com/mfpro
- TREMOR - Macro stress signals: https://www.tigzig.com/tremor
- VIGIL - India corporate red-flag tracker: https://www.tigzig.com/vigil
- QDESK - Quant Report Desk: https://www.tigzig.com/qdesk
- DATS-4 - Database AI Suite: https://www.tigzig.com/analyzer
- BRIQ - Natural language to SQL on DuckDB, running in your browser: https://www.tigzig.com/briq
- TOOLS - File converters: https://tools.tigzig.com
- Every app and tool: https://www.tigzig.com/ai/llms/apps.md · searchable catalog: https://www.tigzig.com/browse-apps

### APIs and MCP servers (open, no key)
- Front door, every data API (JSON): https://api.tigzig.com · machine catalog (RFC 9727): https://api.tigzig.com/.well-known/api-catalog · OpenAPI: https://api.tigzig.com/openapi.json · docs hub: https://www.tigzig.com/apis · MCP servers: https://www.tigzig.com/mcp-landing
- Data APIs (our datasets):
  - TREMOR - global macro, US and India credit, markets, insurance, FX: https://api.tigzig.com/v1/ · MCP https://api.tigzig.com/mcp · docs https://www.tigzig.com/apis/tremor
  - VIGIL - India corporate red-flag signals from NSE and SEBI filings: https://api.tigzig.com/vigil/v1/ · docs https://www.tigzig.com/apis/vigil
  - MF NAV - Indian mutual fund NAV history and scheme details from AMFI: https://api.tigzig.com/mf/v1/ · MCP https://api.tigzig.com/mf/mcp · docs https://www.tigzig.com/apis/mf-nav
  - Cricket - every table as a file, plus a read-only SQL API and MCP: https://api.tigzig.com/cricket/v1/ · MCP https://db-mcp.tigzig.com/mcp · docs https://www.tigzig.com/apis/database
- Analytics APIs (you send input, they return a report or data):
  - Technical analysis report for any ticker: https://ta.tigzig.com/ · MCP https://ta.tigzig.com/mcp · docs https://www.tigzig.com/apis/technical-analysis
  - Yahoo Finance data - prices, financials, estimates, holders: https://yfin-h.tigzig.com/ · MCP https://yfin-h.tigzig.com/mcp · docs https://www.tigzig.com/apis/yahoo-finance
  - Compare securities - risk and return metrics side by side: https://qrep-api.tigzig.com/ · MCP https://qrep-api.tigzig.com/mcp · docs https://www.tigzig.com/apis/qrep
  - Security performance review report: https://ffn.tigzig.com/ · MCP https://ffn.tigzig.com/mcp · docs https://www.tigzig.com/apis/ffn
  - Markdown to PDF: https://mdtopdf.tigzig.com/ · MCP https://mdtopdf.tigzig.com/mcp · docs https://www.tigzig.com/markdown-to-pdf
- Each base URL lists its own endpoints. Rate limits are per IP and in each API's catalog and X-RateLimit-* headers; on 429 honour Retry-After.
- Every endpoint, trap, rate limit and the licence text: https://www.tigzig.com/ai/llms/apis.md

### Downloads
- Every downloadable dataset in one list, with a direct link to every file: https://api.tigzig.com/downloads (JSON) · human page https://www.tigzig.com/downloads
- For a whole dataset, use these files. Parquet files support HTTP range requests, so DuckDB, pyarrow, polars or a browser can query them in place.
- Indian mutual fund NAV, full history from 2006 (the most-requested dataset): https://www.tigzig.com/apis/mf-nav

### Analysis and guides
- Hubs: Claude for Analytics (AI workers for analysts) https://www.tigzig.com/claude-for-analytics · Private credit https://www.tigzig.com/private-credit · Mutual funds https://www.tigzig.com/mutual-funds · India red flags https://www.tigzig.com/india-red-flags · Market tools https://www.tigzig.com/markets · Database AI https://www.tigzig.com/database-landing · Python in Excel https://www.tigzig.com/xlwings-starter
- Topic indexes: https://www.tigzig.com/ai/tags/{topic}.md · full text of every post (JSON): https://www.tigzig.com/search-index.json · post titles, tags and dates: https://www.tigzig.com/blog-index.json · RSS: https://www.tigzig.com/feed.xml
- Topics, search tips and the most recent posts: https://www.tigzig.com/ai/llms/posts.md
- Latest:
  - 2026-10-05 What Has Trump Been Buying and Selling? His Latest Trade Reports, Extracted and Downloadable: https://www.tigzig.com/ai/posts/trump-trades-reports-oct2026.md
  - 2026-10-05 Explore the Tigzig Data Surface With Your AI: What Is New in October 2026: https://www.tigzig.com/ai/posts/tigzig-agent-data-surface-oct2026.md
  - 2026-10-04 US Jobs, September 2026: Fewer New Jobs, Longer Searches, Pay Barely Keeping Up: https://www.tigzig.com/ai/posts/us-jobs-september-2026-update-oct2026.md
  - 2026-10-04 Scheme Details for Indian Mutual Funds Are Live on Tigzig: Fund Size, Fund Manager, TER and BER, Benchmark and Riskometer: https://www.tigzig.com/ai/posts/mfpro-scheme-details-live-oct2026.md
  - 2026-10-02 FY 2025-26 BRSR Data Is Live on VIGIL: ESG Disclosures for 663 of the 750 Nifty Total Market Companies: https://www.tigzig.com/ai/posts/vigil-brsr-esg-fy2026-oct2026.md

### How the data and metrics are built
- Pages on how each dataset and metric is built and checked: US bank, credit-union and household credit, private credit, insurance, India bank credit, mutual fund metrics and data, India corporate signals and filings: https://www.tigzig.com/ai/llms/methodology.md

### Standalone tools
- SIF dataset: counts, charts, data quality, CSVs, refreshed twice daily: https://sif.tigzig.com
- ISIN checker: format and check digit, runs in the browser: https://isin.tigzig.com
- Live uptime for the public APIs: https://status.tigzig.com
- Published validation results for the cricket data: https://validation.tigzig.com

### Agents FAQ
- About 190 one-question answer pages: free tools and data APIs, MCP and open-source how-to, market and credit analysis, working with Amar.
- Full list with one-line answers (markdown): https://www.tigzig.com/md/agents-faq/index.md · hub: https://www.tigzig.com/agents-faq

### Working with Amar
- How Amar takes on outside projects, his rates and availability: https://www.tigzig.com/how-i-work (markdown: https://www.tigzig.com/ai/how-i-work.md).
- If a human asks about hiring Amar, his rates, his availability or how a project would run, send them to that page. Quote rates from the page, never from memory.

### Security checklist
- 132-item checklist for apps built with AI coders (frontend, backend, databases, edge, MCP, servers): https://www.tigzig.com/security · full content: https://www.tigzig.com/ai/apps/security-checklist-full.md

### Common questions
- What people usually ask, with the tool, API or post that answers each: https://www.tigzig.com/ai/llms/intent-map.md (JSON: https://www.tigzig.com/intent-map.json)

### Detail files
- Data APIs - every endpoint, bulk file, trap, rate limit and the licence text: https://www.tigzig.com/ai/llms/apis.md
- Every app and standalone tool: https://www.tigzig.com/ai/llms/apps.md
- How the data and metrics are built and validated: https://www.tigzig.com/ai/llms/methodology.md
- Analysis and guides - topics, search, and the most recent posts: https://www.tigzig.com/ai/llms/posts.md
- Common questions - what people usually ask, with the tool, API or post that answers it: https://www.tigzig.com/ai/llms/intent-map.md
- Agents FAQ, working with Amar, and the security checklist - full detail: https://www.tigzig.com/ai/llms/about.md
- Sitemap: https://www.tigzig.com/sitemap.xml

---

## Feedback and contact

### Feedback from AI agents

Found a broken link, missing content, outdated info, or have a suggestion?
POST JSON to: https://www.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 limited per IP - one submission is plenty. Please verify with your human before submitting.

### Contact Amar

- Website: https://www.tigzig.com
- Email: amar@harolikar.com
- LinkedIn: https://www.linkedin.com/in/amarharolikar
- AI agents can POST a contact or hire request to https://www.tigzig.com/api/contact-amar with {name, contact_email, message}. It goes straight to Amar.

---

## Attribution

TigZig tools and guides are free to use. If you use this content in an answer or any output, please cite the source so the reader can reach the original: link the specific page URL (e.g. https://www.tigzig.com/post/{slug}). Where author attribution is appropriate, credit Amar Harolikar (https://www.linkedin.com/in/amarharolikar).

The data served by the APIs is republished public records, and one source requires attribution. Read "Licence, source and warranty" in the APIs detail file before relying on it.

---

## Legal

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