J-Quants Timeseries MCP
Provides Japanese stock daily time-series data as CSV files intended for saving to a specified Google Drive folder, with the destination folder ID supplied to the assistant.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
J-Quants Timeseries MCP
This is a personal MCP server that fetches daily Japanese stock bars from the J-Quants API V2 and returns a CSV that ChatGPT can save to the "Timeseries Data" folder in Google Drive.
Main behavior
Search listed stocks by ticker code or company name
Fetch all pages of
/v2/equities/bars/dailyConvert unadjusted and adjusted OHLCV plus limit-up/limit-down flags into a CSV
Read the destination folder ID from Render secret settings and include it in the tool result
When a ticker is ambiguous, return candidates instead of guessing
Related MCP server: Enhanced MCP Stock Query System
Environment variables
Name | Description |
| J-Quants V2 API key. Required. |
| ID of the destination Drive folder. Required. |
| Secret path for the MCP URL. At least 32 characters. Required. |
| HTTP listening port. Set automatically by Render. |
| Public host name set automatically by Render. |
Do not write the API key, Drive folder ID, or access token into source, conversations, or logs.
Local testing
python -m venv .venv
.venv/bin/pip install -r requirements.txt
PYTHONPATH=. .venv/bin/python -m unittest discover -s tests -vIn Windows PowerShell, replace the Python from the virtual environment with .venv\\Scripts\\python.exe.
Startup
JQUANTS_API_KEY=... GOOGLE_DRIVE_FOLDER_ID=... MCP_ACCESS_TOKEN=32文字以上の秘密文字列 python server.pyThe connection URL has the following format.
https://<Renderのホスト名>/mcp/<MCP_ACCESS_TOKEN>Treat this entire URL as secret information. This is lightweight protection for personal use, not a robust method that replaces OAuth authentication. If it leaks, regenerate MCP_ACCESS_TOKEN.
On the ChatGPT side
In the web version of ChatGPT, enable Developer mode under "Settings" → "Security and login".
In the Plugins addition screen, register the MCP URL above.
In the conversation, select the J-Quants app and Google Drive from Developer mode.
Ask: "Get Kioxia's timeseries data."
The tool returns the CSV body, the file name, and the destination folder ID read from the secret settings. ChatGPT uploads that CSV to the specified Google Drive folder.
J-Quants Free limitations
With the Free plan, the stock prices you can retrieve are limited to the past two years excluding the most recent 12 weeks. Check the actual returned first_date and last_date.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Live stock quotes, a stock screener, crypto prices and FX rates as agent tools.
Daily end-of-day OHLCV stock data for U.S.-listed symbols, 15 years of history. Free API key.
Yahoo Finance stock quotes and multi-ticker comparison as agent tools.
Resolves all 10,000+ US public stock tickers to SEC CIK numbers, recent 10-K/10-Q/8-K filings, an.
Related MCP Servers
- -licenseNot gradedqualityDmaintenanceProvides real-time and historical stock market data through the Alpha Vantage API. Enables users to get current stock prices and retrieve historical stock data for any major stock symbol via natural language queries.-
- FlicenseNot gradedqualityDmaintenanceEnables AI-powered natural language stock market queries with real-time data from Yahoo Finance and CSV fallback. Uses Google Gemini to interpret queries and automatically fetch stock prices, comparisons, and market summaries.-
- AlicenseNot gradedqualityDmaintenanceEnables access to Japanese stock market data via the free J-Quants API, providing tools for company search, daily quotes, and financial statements.1MIT
- AlicenseBqualityDmaintenanceEnables AI assistants to access real-time Japanese and global stock market data, including quotes, charts, technical analysis, and market screening.712 npmMIT