About Indian NSE Stock Insights
Indian NSE Stock Insights is a public MCP server for analyzing Indian equities across the Nifty 500 universe. It offers quotes, technical and price-action analysis, and screening across three timeframes; it is for educational and informational use, not investment advice.
Key features
- 01Stock quotes and OHLCV data
- 02Technical indicators and support/resistance
- 03Demand/supply zones and candlestick patterns
- 04Chart patterns and Fibonacci levels
- 05Volume analysis and market overview
- 06Stock comparison and screening
Use cases
- 01Review technical indicators for Nifty 500 stocks
- 02Compare trends and returns across stocks
- 03Screen stocks by RSI, trend, or pattern
- 04Check indices, market movers, and demand zones
MCP support
The MCP server exposes Indian stock data and analysis to MCP clients through 12 tools, covering the Nifty 500 and daily, 15min, and 5min timeframes.
Configuration
Remote servers need no local install. Pick your client, then copy the config or install in one click.
https://stockmcp.alokbarnwal.com/mcpclaude mcp add --transport http alokbarnwal-nse-public https://stockmcp.alokbarnwal.com/mcp{"mcpServers":{"alokbarnwal-nse-public":{"type":"http","url":"https://stockmcp.alokbarnwal.com/mcp"}}}Open in Cursor{"servers":{"alokbarnwal-nse-public":{"type":"http","url":"https://stockmcp.alokbarnwal.com/mcp"}}}Open in VS Code{"mcpServers":{"alokbarnwal-nse-public":{"type":"http","url":"https://stockmcp.alokbarnwal.com/mcp"}}}{"mcpServers":{"alokbarnwal-nse-public":{"serverUrl":"https://stockmcp.alokbarnwal.com/mcp"}}}Run commands in a terminal; paste JSON into the client’s MCP config and restart. Servers that need sign-in will prompt on first connect.
Tools
12| Parameter | Type | Required | Description |
|---|---|---|---|
| symbol | string | Yes |
Details
From the project READMEIndian NSE Stock Insights 🇮🇳📈
Public MCP server for Indian stock market analysis — Nifty 500 universe, 12 tools, 3 timeframes.
Built with FastMCP · Data from yfinance · Hosted at stockmcp.alokbarnwal.com
Educational only. Not investment advice. See DISCLAIMER.md.
Quick Connect — 30 Seconds
Claude.ai → Settings → Connectors → Add custom MCP connector:
Name: Indian NSE Stock Insights
URL: https://stockmcp.alokbarnwal.com/mcp
That's it. Start asking questions about Indian stocks.
12 Tools
| # | Tool | Parameters | What it returns |
|---|---|---|---|
| 1 | get_stock_quote | symbol | Last close, prev close, change %, day H/L, volume |
| 2 | get_ohlc_data | symbol, timeframe?, limit? | OHLCV candles (up to 500, newest first) |
| 3 | get_technical_indicators | symbol, timeframe? | EMAs, SMAs, RSI, MACD, Bollinger, ADX, Stoch, ATR, OBV, VWAP |
| 4 | get_support_resistance | symbol, timeframe? | Pivot points + historical S/R levels |
| 5 | get_demand_supply_zones | symbol, timeframe?, status? | Demand/supply zones (DBR/RBR/RBD/DBD) |
| 6 | get_candlestick_patterns | symbol, timeframe?, limit? | HAMMER, DOJI, ENGULFING, etc. |
| 7 | get_chart_patterns | symbol, timeframe?, status? | DOUBLE_TOP, HEAD_AND_SHOULDERS, etc. |
| 8 | get_fibonacci_levels | symbol, timeframe? | Retracement swings (UP/DOWN) with fib levels |
| 9 | get_volume_analysis | symbol | 5min hotspots, OBV trend, volume ratio |
| 10 | get_market_overview | (none) | Indices, top gainers/losers, most active, breadth |
| 11 | compare_stocks | symbols (2-5) , timeframe? | Side-by-side: quote, RSI/MACD/ADX, trend, 30d return |
| 12 | screen_stocks | filters | Filter by RSI, ADX, trend, pattern, sector, etc. |
timeframe defaults to daily. Options: daily, 15min, 5min.
Example Prompts
Try these in Claude.ai after connecting:
- "RELIANCE ka technical analysis do — RSI, MACD, aur support/resistance levels batao"
- "Show me Nifty 500 stocks with RSI below 30 and ADX above 25"
- "Compare TCS, INFY, and WIPRO — which one has the best setup right now?"
- "What does the overall market look like today? Show me top gainers and losers"
- "HDFC Bank ke demand and supply zones dikhao on the 15-minute chart"
Architecture
graph TB
subgraph Internet
C[Claude.ai / MCP Client]
end
subgraph Server["Production Server"]
subgraph Protection
F2B[fail2ban<br/>auto-ban repeat abusers]
NG[nginx<br/>rate limit 20r/s · conn limit · TLS]
end
subgraph Application
MCP["FastMCP Server<br/>port 8089 · 12 tools"]
TOOLS["Tool Modules<br/>quote · ohlc · indicators<br/>levels · zones · patterns<br/>fibonacci · volume · market<br/>compare · screener"]
end
subgraph Data
DB[(MySQL: nse_public<br/>500 stocks × 3 timeframes)]
CRON[Cron Jobs<br/>5min · 15min · daily]
end
end
subgraph External
YF[Yahoo Finance<br/>yfinance API]
end
C -->|HTTPS POST /mcp| NG
NG -->|proxy_pass| MCP
MCP --> TOOLS
TOOLS -->|read-only queries| DB
YF -->|OHLCV data| CRON
CRON -->|upsert| DB
F2B -.->|monitors| NG
Data Coverage
| Timeframe | Retention | Update Frequency | Stocks |
|---|---|---|---|
| Daily | 5 years | EOD (18:00 IST) | 500 |
| 15-minute | 2 years | Every 15 min (market hours) | 500 |
| 5-minute | 6 months | Every 5 min (market hours) | 500 |
Market hours: 09:15–15:30 IST, Monday–Friday (excluding NSE holidays).
Rate Limits
| Layer | Limit | Action |
|---|---|---|
| nginx | 20 requests/sec per IP (burst 40) | HTTP 429 |
| nginx | 10 simultaneous connections per IP | HTTP 429 |
| fail2ban | 5× rate-limit violations in 2 min | IP banned for 1 hour |
Self-Hosting
Click to expand — full deployment runbook
Runs on
/home/ubuntu/nse-public-mcp/— completely isolated from/home/ubuntu/swingtrader/.
1. Clone
cd /home/ubuntu
git clone https://github.com/alokbarnwal/nse-public-mcp.git
cd nse-public-mcp
2. Create database and user
sudo mysql <<'SQL'
CREATE DATABASE IF NOT EXISTS nse_public CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER IF NOT EXISTS 'nse_writer'@'localhost' IDENTIFIED BY 'CHANGE_ME_STRONG_PASSWORD';
GRANT ALL PRIVILEGES ON nse_public.* TO 'nse_writer'@'localhost';
FLUSH PRIVILEGES;
SQL
3. Apply schema
mysql -u nse_writer -p nse_public < db/schema.sql
mysql -u nse_writer -p nse_public < db/schema_indicators.sql
mysql -u nse_writer -p nse_public < db/schema_price_action.sql
4. Install dependencies
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
5. Configure environment
cp .env.example .env
chmod 600 .env
nano .env # set DB_PASSWORD to match step 2
6. (Optional) Refresh full Nifty 500 list
The repo ships with the top ~100 stocks hardcoded. To expand to all 500:
python -m config.stocks --refresh # fetches NSE archives, rewrites config/stocks.py
7. Load stock universe into DB
python -m config.stocks --load-to-db
8. Backfill historical data (long-running, use screen/tmux)
screen -S backfill
source .venv/bin/activate
python -m data.backfill --all
# Ctrl-A D to detach. Reattach: screen -r backfill
Expected runtime:
daily 5y × 500: ~30 min15min 2y × 500: ~2 h5min 6mo × 500: ~1 h
If anything fails, the failure list is written to backfill_failures_<timeframe>.json. Re-run:
python -m data.backfill --timeframe 15min --resume
8b. Bulk-compute indicators (long-running, use screen/tmux)
After the candle backfill completes, populate the indicators table for all 500 stocks across all 3 timeframes:
screen -S indicators
cd /home/ubuntu/nse-public-mcp
python3 -m indicators.runner --all
# Ctrl-A D to detach
Expected runtime: ~30–45 min. Idempotent — safe to re-run if interrupted.
8c. Bulk-compute price action (long-running, use screen/tmux)
After indicators are populated, compute price-action features (zones, S/R, patterns, breakouts, fibs, gaps, volume profile) for all 500 stocks across all 3 timeframes:
screen -S price_action
cd /home/ubuntu/nse-public-mcp
python3 -m price_action.runner --timeframe daily --all-features
python3 -m price_action.runner --timeframe 15min --all-features
python3 -m price_action.runner --timeframe 5min --all-features
# Ctrl-A D to detach
Expected runtime: ~60–90 min total. Idempotent — safe to re-run if interrupted.
9. Install crontab
crontab -e
Add:
# nse-public-mcp candle updaters
*/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
*/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
0 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
# nse-public-mcp indicator updaters (each runs after the matching candle fetch)
30 18 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_daily >> logs/indicators_daily.log 2>&1
20,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
5 16 * * 1-5 cd /home/ubuntu/nse-public-mcp && /usr/bin/python3 -m jobs.cron_indicators_15min >> logs/indicators_15min.log 2>&1
2-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
# nse-public-mcp price-action updaters (each runs after the matching indicator cron)
35 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
25,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
9-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
Cron times are server-local. Verify the server is on IST (
timedatectl) — if not, shift the hour ranges. The 5-min indicator cron is offset to2-57/5so it runs ~2 minutes aftercron_5minand never reads stale candles. The price-action 5-min cron is offset to9-54/15(minutes 9, 24, 39, 54) so it runs ~2 minutes after eachcron_indicators_5minslot.
10. Verification
mysql -u nse_writer -p nse_public <<'SQL'
SELECT 'daily' AS tf, COUNT(*) AS n FROM candles_daily
UNION ALL SELECT '15min', COUNT(*) FROM candles_15min
UNION ALL SELECT '5min', COUNT(*) FROM candles_5min;
-- Per-stock coverage on daily — flag any with < 1000 rows (~4 trading years)
SELECT symbol, COUNT(*) AS n
FROM candles_daily
GROUP BY symbol
HAVING n < 1000
ORDER BY n;
-- Latest data freshness
SELECT MIN(candle_date) AS earliest, MAX(candle_date) AS latest
FROM candles_daily;
-- Recent cron health
SELECT job_type, timeframe, symbols_success, symbols_failed, started_at, duration_seconds
FROM fetch_log
ORDER BY started_at DESC
LIMIT 20;
SQL
DB size on disk:
sudo du -sh /var/lib/mysql/nse_public/
Service Management
# Server status
sudo systemctl status nse-public-mcp
# Restart
sudo systemctl restart nse-public-mcp
# Logs
sudo journalctl -u nse-public-mcp -n 100 -f
# nginx
sudo nginx -t && sudo systemctl reload nginx
# fail2ban
sudo fail2ban-client status nginx-mcp-ratelimit
Layout
See PROJECT.md for architecture and data-flow diagram.
config/ # settings, stock universe, holiday calendar
data/ # yfinance fetcher, backfill CLI, shared upsert helpers
db/ # schema and pooled connection
indicators/ # technical indicator compute, persist, runner
price_action/ # zones, patterns, levels, trends
mcp_server/ # FastMCP server + 12 tool modules
jobs/ # cron entrypoints (candles + indicators + price action)
deploy/ # systemd service, nginx config, fail2ban rules
tests/ # mocked unit tests (82 tests)
Operational Notes
- Be respectful to Yahoo Finance. The fetcher sleeps 1–3 s between requests and retries with backoff. Don't reduce these.
- Idempotent. All inserts are
INSERT … ON DUPLICATE KEY UPDATE. Replaying a cron tick or rerunning backfill is safe. - Holiday calendar lives in
config/holidays.py. Update it once a year when NSE publishes the next year's list. - 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.
License
MIT — free to use, modify, and distribute.
Disclaimer
This project is for educational and informational purposes only. Not investment advice. See DISCLAIMER.md.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.