[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_104":105},"routes/modules.$creator.$moduleId",{"_14":15,"_16":17,"_18":19,"_20":21},"routes/modules.$creator.$moduleId.endpoints",{"_11":12,"_13":-5},"error","Module '@alokbarnwal/nse-public-mcp' is not configured","tools","module",{"_20":22,"_23":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":26,"_34":-5,"_35":36,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":48,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":-5,"_76":-5,"_77":48,"_78":-5,"_79":80,"_81":82,"_83":84,"_85":86,"_87":88,"_89":90,"_91":92},"apiUrl","https://odel.app/api","creator","alokbarnwal","moduleId","nse-public-mcp","@alokbarnwal/nse-public-mcp","displayName","Indian NSE Stock Insights","tagline","Analyze any Nifty 500 stock with AI — price action, demand zones, technicals & screener.","iconKey","https://avatars.githubusercontent.com/u/35222552?v=4","category","dev-tools","status","published","metaDescription","metaKeywords","deploymentType","external","workerName","bindingName","mcpConfig","{\"url\":\"https://stockmcp.alokbarnwal.com/mcp\",\"transport\":\"streamable-http\",\"authType\":\"none\"}","pricingModel","free","creatorUserId","system:external-import","createdAt",1781363387000,"updatedAt",1781499586000,"sourceRegistry","official-mcp-registry","sourceUrl","https://registry.modelcontextprotocol.io/v0/servers?search=io.github.alokbarnwal%2Fnse-public-mcp","sourceVerified",true,"importedAt","upstreamStars",1,"upstreamUpdatedAt",1777583710000,"detectedTransport","detectedAuthType","probeStatus","lastProbedAt","githubRepoUrl","https://github.com/alokbarnwal/nse-public-mcp","githubRepoFullName","alokbarnwal/nse-public-mcp","releaseId","ext-alokbarnwal-nse-public-mcp","version","1.0.1","descriptionMarkdown","# Indian NSE Stock Insights 🇮🇳📈\n\nPublic MCP server for Indian stock market analysis — **Nifty 500 universe**, **12 tools**, **3 timeframes**.\n\nBuilt with [FastMCP](https://github.com/jlowin/fastmcp) · Data from [yfinance](https://github.com/ranaroussi/yfinance) · Hosted at `stockmcp.alokbarnwal.com`\n\n> **Educational only. Not investment advice.** See [DISCLAIMER.md](https://github.com/alokbarnwal/nse-public-mcp/blob/main/DISCLAIMER.md).\n\n---\n\n## Quick Connect — 30 Seconds\n\n**Claude.ai** → Settings → Connectors → Add custom MCP connector:\n\n```\nName: Indian NSE Stock Insights\nURL: https://stockmcp.alokbarnwal.com/mcp\n```\n\nThat's it. Start asking questions about Indian stocks.\n\n---\n\n## 12 Tools\n\n| # | Tool | Parameters | What it returns |\n|---|------|-----------|-----------------|\n| 1 | `get_stock_quote` | `symbol` | Last close, prev close, change %, day H/L, volume |\n| 2 | `get_ohlc_data` | `symbol`, `timeframe?`, `limit?` | OHLCV candles (up to 500, newest first) |\n| 3 | `get_technical_indicators` | `symbol`, `timeframe?` | EMAs, SMAs, RSI, MACD, Bollinger, ADX, Stoch, ATR, OBV, VWAP |\n| 4 | `get_support_resistance` | `symbol`, `timeframe?` | Pivot points + historical S/R levels |\n| 5 | `get_demand_supply_zones` | `symbol`, `timeframe?`, `status?` | Demand/supply zones (DBR/RBR/RBD/DBD) |\n| 6 | `get_candlestick_patterns` | `symbol`, `timeframe?`, `limit?` | HAMMER, DOJI, ENGULFING, etc. |\n| 7 | `get_chart_patterns` | `symbol`, `timeframe?`, `status?` | DOUBLE_TOP, HEAD_AND_SHOULDERS, etc. |\n| 8 | `get_fibonacci_levels` | `symbol`, `timeframe?` | Retracement swings (UP/DOWN) with fib levels |\n| 9 | `get_volume_analysis` | `symbol` | 5min hotspots, OBV trend, volume ratio |\n| 10 | `get_market_overview` | *(none)* | Indices, top gainers/losers, most active, breadth |\n| 11 | `compare_stocks` | `symbols` (2-5) , `timeframe?` | Side-by-side: quote, RSI/MACD/ADX, trend, 30d return |\n| 12 | `screen_stocks` | `filters` | Filter by RSI, ADX, trend, pattern, sector, etc. |\n\n`timeframe` defaults to `daily`. Options: `daily`, `15min`, `5min`.\n\n---\n\n## Example Prompts\n\nTry these in Claude.ai after connecting:\n\n- *\"RELIANCE ka technical analysis do — RSI, MACD, aur support/resistance levels batao\"*\n- *\"Show me Nifty 500 stocks with RSI below 30 and ADX above 25\"*\n- *\"Compare TCS, INFY, and WIPRO — which one has the best setup right now?\"*\n- *\"What does the overall market look like today? Show me top gainers and losers\"*\n- *\"HDFC Bank ke demand and supply zones dikhao on the 15-minute chart\"*\n\n---\n\n## Architecture\n\n```mermaid\ngraph TB\n subgraph Internet\n C[Claude.ai / MCP Client]\n end\n\n subgraph Server[\"Production Server\"]\n subgraph Protection\n F2B[fail2ban
auto-ban repeat abusers]\n NG[nginx
rate limit 20r/s · conn limit · TLS]\n end\n\n subgraph Application\n MCP[\"FastMCP Server
port 8089 · 12 tools\"]\n TOOLS[\"Tool Modules
quote · ohlc · indicators
levels · zones · patterns
fibonacci · volume · market
compare · screener\"]\n end\n\n subgraph Data\n DB[(MySQL: nse_public
500 stocks × 3 timeframes)]\n CRON[Cron Jobs
5min · 15min · daily]\n end\n end\n\n subgraph External\n YF[Yahoo Finance
yfinance API]\n end\n\n C -->|HTTPS POST /mcp| NG\n NG -->|proxy_pass| MCP\n MCP --> TOOLS\n TOOLS -->|read-only queries| DB\n YF -->|OHLCV data| CRON\n CRON -->|upsert| DB\n F2B -.->|monitors| NG\n```\n\n---\n\n## Data Coverage\n\n| Timeframe | Retention | Update Frequency | Stocks |\n|-----------|-----------|-----------------|--------|\n| Daily | 5 years | EOD (18:00 IST) | 500 |\n| 15-minute | 2 years | Every 15 min (market hours) | 500 |\n| 5-minute | 6 months | Every 5 min (market hours) | 500 |\n\nMarket hours: 09:15–15:30 IST, Monday–Friday (excluding NSE holidays).\n\n---\n\n## Rate Limits\n\n| Layer | Limit | Action |\n|-------|-------|--------|\n| nginx | 20 requests/sec per IP (burst 40) | HTTP 429 |\n| nginx | 10 simultaneous connections per IP | HTTP 429 |\n| fail2ban | 5× rate-limit violations in 2 min | IP banned for 1 hour |\n\n---\n\n## Self-Hosting\n\n

Click to expand — full deployment runbook

\n\n> Runs on `/home/ubuntu/nse-public-mcp/` — completely isolated from `/home/ubuntu/swingtrader/`.\n\n### 1. Clone\n\n```bash\ncd /home/ubuntu\ngit clone https://github.com/alokbarnwal/nse-public-mcp.git\ncd nse-public-mcp\n```\n\n### 2. Create database and user\n\n```bash\nsudo mysql <<'SQL'\nCREATE DATABASE IF NOT EXISTS nse_public CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;\nCREATE USER IF NOT EXISTS 'nse_writer'@'localhost' IDENTIFIED BY 'CHANGE_ME_STRONG_PASSWORD';\nGRANT ALL PRIVILEGES ON nse_public.* TO 'nse_writer'@'localhost';\nFLUSH PRIVILEGES;\nSQL\n```\n\n### 3. Apply schema\n\n```bash\nmysql -u nse_writer -p nse_public < db/schema.sql\nmysql -u nse_writer -p nse_public < db/schema_indicators.sql\nmysql -u nse_writer -p nse_public < db/schema_price_action.sql\n```\n\n### 4. Install dependencies\n\n```bash\npython3 -m venv .venv\nsource .venv/bin/activate\npip install -r requirements.txt\n```\n\n### 5. Configure environment\n\n```bash\ncp .env.example .env\nchmod 600 .env\nnano .env # set DB_PASSWORD to match step 2\n```\n\n### 6. (Optional) Refresh full Nifty 500 list\n\nThe repo ships with the top ~100 stocks hardcoded. To expand to all 500:\n\n```bash\npython -m config.stocks --refresh # fetches NSE archives, rewrites config/stocks.py\n```\n\n### 7. Load stock universe into DB\n\n```bash\npython -m config.stocks --load-to-db\n```\n\n### 8. Backfill historical data (long-running, use screen/tmux)\n\n```bash\nscreen -S backfill\nsource .venv/bin/activate\npython -m data.backfill --all\n# Ctrl-A D to detach. Reattach: screen -r backfill\n```\n\nExpected runtime:\n- `daily 5y × 500`: ~30 min\n- `15min 2y × 500`: ~2 h\n- `5min 6mo × 500`: ~1 h\n\nIf anything fails, the failure list is written to `backfill_failures_.json`. Re-run:\n\n```bash\npython -m data.backfill --timeframe 15min --resume\n```\n\n### 8b. Bulk-compute indicators (long-running, use screen/tmux)\n\nAfter the candle backfill completes, populate the `indicators` table for all 500 stocks across all 3 timeframes:\n\n```bash\nscreen -S indicators\ncd /home/ubuntu/nse-public-mcp\npython3 -m indicators.runner --all\n# Ctrl-A D to detach\n```\n\nExpected runtime: ~30–45 min. Idempotent — safe to re-run if interrupted.\n\n### 8c. Bulk-compute price action (long-running, use screen/tmux)\n\nAfter indicators are populated, compute price-action features (zones, S/R,\npatterns, breakouts, fibs, gaps, volume profile) for all 500 stocks across\nall 3 timeframes:\n\n```bash\nscreen -S price_action\ncd /home/ubuntu/nse-public-mcp\npython3 -m price_action.runner --timeframe daily --all-features\npython3 -m price_action.runner --timeframe 15min --all-features\npython3 -m price_action.runner --timeframe 5min --all-features\n# Ctrl-A D to detach\n```\n\nExpected runtime: ~60–90 min total. Idempotent — safe to re-run if interrupted.\n\n### 9. Install crontab\n\n```bash\ncrontab -e\n```\n\nAdd:\n\n```cron\n# nse-public-mcp candle updaters\n*/5 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /home/ubuntu/nse-public-mcp/.venv/bin/python -m jobs.cron_5min >> logs/cron_5min.log 2>&1\n*/15 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /home/ubuntu/nse-public-mcp/.venv/bin/python -m jobs.cron_15min >> logs/cron_15min.log 2>&1\n0 18 * * 1-5 cd /home/ubuntu/nse-public-mcp && /home/ubuntu/nse-public-mcp/.venv/bin/python -m jobs.cron_daily >> logs/cron_daily.log 2>&1\n\n# nse-public-mcp indicator updaters (each runs after the matching candle fetch)\n30 18 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_daily >> logs/indicators_daily.log 2>&1\n20,35,50 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_15min >> logs/indicators_15min.log 2>&1\n5 16 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_15min >> logs/indicators_15min.log 2>&1\n2-57/5 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_5min >> logs/indicators_5min.log 2>&1\n\n# nse-public-mcp price-action updaters (each runs after the matching indicator cron)\n35 18 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_price_action_daily >> logs/price_action_daily.log 2>&1\n25,55 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_price_action_15min >> logs/price_action_15min.log 2>&1\n9-54/15 9-15 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_price_action_5min >> logs/price_action_5min.log 2>&1\n```\n\n> Cron times are server-local. Verify the server is on IST (`timedatectl`) — if not, shift the hour ranges.\n> The 5-min indicator cron is offset to `2-57/5` so it runs ~2 minutes after `cron_5min` and never reads stale candles.\n> The price-action 5-min cron is offset to `9-54/15` (minutes 9, 24, 39, 54) so it runs ~2 minutes after each `cron_indicators_5min` slot.\n\n### 10. Verification\n\n```bash\nmysql -u nse_writer -p nse_public <<'SQL'\nSELECT 'daily' AS tf, COUNT(*) AS n FROM candles_daily\nUNION ALL SELECT '15min', COUNT(*) FROM candles_15min\nUNION ALL SELECT '5min', COUNT(*) FROM candles_5min;\n\n-- Per-stock coverage on daily — flag any with < 1000 rows (~4 trading years)\nSELECT symbol, COUNT(*) AS n\nFROM candles_daily\nGROUP BY symbol\nHAVING n < 1000\nORDER BY n;\n\n-- Latest data freshness\nSELECT MIN(candle_date) AS earliest, MAX(candle_date) AS latest\nFROM candles_daily;\n\n-- Recent cron health\nSELECT job_type, timeframe, symbols_success, symbols_failed, started_at, duration_seconds\nFROM fetch_log\nORDER BY started_at DESC\nLIMIT 20;\nSQL\n```\n\nDB size on disk:\n\n```bash\nsudo du -sh /var/lib/mysql/nse_public/\n```\n\n

\n\n---\n\n## Service Management\n\n```bash\n# Server status\nsudo systemctl status nse-public-mcp\n\n# Restart\nsudo systemctl restart nse-public-mcp\n\n# Logs\nsudo journalctl -u nse-public-mcp -n 100 -f\n\n# nginx\nsudo nginx -t && sudo systemctl reload nginx\n\n# fail2ban\nsudo fail2ban-client status nginx-mcp-ratelimit\n```\n\n---\n\n## Layout\n\nSee [PROJECT.md](https://github.com/alokbarnwal/nse-public-mcp/blob/main/PROJECT.md) for architecture and data-flow diagram.\n\n```\nconfig/ # settings, stock universe, holiday calendar\ndata/ # yfinance fetcher, backfill CLI, shared upsert helpers\ndb/ # schema and pooled connection\nindicators/ # technical indicator compute, persist, runner\nprice_action/ # zones, patterns, levels, trends\nmcp_server/ # FastMCP server + 12 tool modules\njobs/ # cron entrypoints (candles + indicators + price action)\ndeploy/ # systemd service, nginx config, fail2ban rules\ntests/ # mocked unit tests (82 tests)\n```\n\n---\n\n## Operational Notes\n\n- **Be respectful to Yahoo Finance.** The fetcher sleeps 1–3 s between requests and retries with backoff. Don't reduce these.\n- **Idempotent.** All inserts are `INSERT … ON DUPLICATE KEY UPDATE`. Replaying a cron tick or rerunning backfill is safe.\n- **Holiday calendar** lives in `config/holidays.py`. Update it once a year when NSE publishes the next year's list.\n- **Retention cleanup** runs at the end of `jobs/cron_daily.py`. Daily candles older than 5 y, 15min older than 2 y, 5min older than 6 mo are purged.\n\n---\n\n## License\n\n[MIT](https://github.com/alokbarnwal/nse-public-mcp/blob/main/LICENSE) — free to use, modify, and distribute.\n\n## Disclaimer\n\nThis project is for **educational and informational purposes only**. Not investment advice. See [DISCLAIMER.md](https://github.com/alokbarnwal/nse-public-mcp/blob/main/DISCLAIMER.md).\n","changelogMarkdown","videoKey","requiredSecretsJson","publishedAt","priceCents","trialDays",0,"categoryDisplayName","Developer Tools","upstream",{"_95":96,"_97":98,"_99":100,"_101":102,"_103":-5},"requiredSecrets",[],"tags",[],"assets",[],"stats",{"_93":80,"_94":80},"ratingAvg","reviewCount","topics",[],"license","MIT","language","Python","registryName","io.github.alokbarnwal/nse-public-mcp","homepage","ENV",{"_106":107,"_108":109,"_110":111},"ENVIRONMENT","production","TURNSTILE_SITE_KEY","0x4AAAAAAB8-rEI2gNDf_QhU","SENTRY_DSN","https://45fd1229f78089d5c3ee78be128030e1@o4510583261757440.ingest.de.sentry.io/4510584253448272"]