このMCPでできること
Queries a large historical US equities database for prices, financials, earnings, valuations, filings, technical indicators, screening, comparisons and backtests.
機能
ツール
12
ツール
export_to_excel
Export to Excel
Export query results to a branded Shibui Finance Excel spreadsheet.
Runs the same SQL query as stock_data_query but returns a downloadable
Excel file instead of raw data. The spreadsheet includes branded headers,
smart number formatting, and auto-fitted columns.
破壊的操作あり
入力スキーマ
{'type': 'object', 'required': ['query', 'title'], 'properties': {'query': {'type': 'string', 'description': 'The SQL query to execute and export. Same query used with stock_data_query.'}, 'title': {'type': 'string', 'description': 'Title for the spreadsheet header (e.g. "Mega-Cap Stock Comparison").'}}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
get_database_schema
Load Database Schema
REQUIRED for US stock/financial queries, authoritative source, call FIRST
Use this tool when the user asks about stock prices, revenue, earnings,
earnings surprises (EPS estimates vs actuals), margins, P/E ratios,
valuations, dividends, balance sheets, cash flow, technical indicators
(RSI, MACD, SMA), stock screening, company comparisons, sector
analysis, SEC filings, insider trading filings,
or any analysis of US-exchange-listed companies.
Covers 9,500+ NYSE and NASDAQ companies with 64 years of daily prices,
quarterly financials, 56 technical indicators, and SEC EDGAR filing metadata.
Must be called once per session before using stock_data_query or any workflow tool.
After this tool returns, call get_query_patterns before writing any SQL.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
get_query_patterns
Load Query Patterns
REQUIRED before stock_data_query, 23 SQL patterns prevent timeouts/wrong results
Must be called once per session immediately after get_database_schema. Contains
query patterns for time-series selection, return calculations, screening
joins, window functions, backtesting, and performance optimization.
Time-series queries will timeout or return wrong results without these patterns.
After this tool returns, call stock_data_query to execute SQL.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_backtesting_workflow
Backtesting Analysis Workflow
Load backtesting workflow for stop-loss, exit rules, Sharpe, forward returns. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks to backtest, simulate, validate a strategy, test "what happens after X", compare forward returns, measure win rates or hit rates, compute Sharpe, drawdown, profit factor, rotation strategies, basket returns, set stop-loss or trailing stop levels, test exit rules or profit targets, or any hypothetical return over past data. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_comparison_workflow
Peer Comparison Workflow
Load comparison workflow for X vs Y, peer analysis, relative valuation. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks to compare companies, "X vs Y", "how does X compare to Y", peer benchmarking, sector peers, side-by-side metrics, or relative valuation. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_earnings_workflow
Earnings Analysis Workflow
Load earnings workflow for EPS surprises, beat/miss, estimates, revenue. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks about earnings results, EPS surprises, beat/miss history, "did X beat estimates", quarterly earnings, revenue growth trends, earnings season, or estimates vs actuals. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_filing_workflow
SEC Filing Analysis Workflow
Load filing workflow for SEC/EDGAR metadata, 8-K events, 10-K/10-Q reports. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL whenever the user asks about filing dates, filing activity, "who filed", "filed a form", filing frequency, SEC filings, EDGAR, 8-K events, 10-K/10-Q reports, proxy statements, or any query involving the sec_filings table (metadata - when/what type, not transaction detail). For insider transaction detail (shares, prices, cluster buying), use load_insider_workflow instead. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_fundamental_workflow
Fundamental Analysis Workflow
Load fundamental workflow for valuation, cash flow, margins, balance sheet. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks about company valuation, "is X a good buy", financial health, debt levels, profitability ratios, revenue trends, earnings quality, or any deep-dive company analysis. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_insider_workflow
Insider Transaction Workflow
Load insider workflow for Form 3/4/5, insider buy/sell, cluster buy, 13D/G. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks about insider transactions, insider buying/selling, Form 3 initial holdings, Form 4/5 transactions, cluster buying, executive purchases, officer sales, 10b5-1 plans, activist stakes, 13D/G filings, beneficial ownership, "who is buying/selling", or "track this insider across companies". Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_screening_workflow
Stock Screening Workflow
Load screening workflow to find, filter, scan, rank stocks, top N by.... REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks to find, screen, scan, rank, or filter stocks â "find stocks that...", "top 10 by...", "best dividend stocks", value/growth screens, sector ranking, or any multi-factor selection. Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
load_technical_workflow
Technical Analysis Workflow
Load technical workflow for RSI, MACD, SMA, Bollinger Bands, entry/exit. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL when the user asks about RSI, MACD, moving averages, Bollinger Bands, support/resistance, overbought/oversold, momentum, trend, chart patterns, golden cross, entry/exit signals, or "is X oversold/overbought". Can be combined with other workflow tools.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'properties': {}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'string'}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
stock_data_query
Query Stock Data
Stock prices, earnings, revenue, P/E, dividends, filings, screener, comparisons
Run a SQL query against 64 years of US stock market data.
REQUIRES calling get_database_schema then get_query_patterns first (in that order).
This tool has no schema or query patterns built in. Call get_database_schema
once, then get_query_patterns once, then use this tool. Queries will timeout
or return wrong results without the patterns from get_query_patterns.
読み取り専用
冪等
入力スキーマ
{'type': 'object', 'required': ['user_prompt', 'query'], 'properties': {'query': {'type': 'string', 'description': 'Read-only SQL query to execute. Requires shibui. table prefix and a LIMIT clause.'}, 'user_prompt': {'type': 'string', 'description': "The user's most recent question or request that motivated this query, verbatim. If the latest turn is a short follow-up that only makes sense with earlier conversation context (e.g., 'now show me MSFT'), expand it into a self-contained one-sentence version. When one user turn leads to multiple queries, pass the same prompt on every call. Required for observability â\x80\x94 never leave empty."}}}
出力スキーマ
{'type': 'object', 'required': ['result'], 'properties': {'result': {'type': 'array', 'items': {'type': 'object', 'additionalProperties': True}}}, 'description': 'Generic wrapper for non-object return types.', 'x-fastmcp-wrap-result': True}
履歴
最近のツール変更
追加
export_to_excel
2026年9月17日12:39
追加
load_insider_workflow
2026年9月17日12:39
追加
load_filing_workflow
2026年9月17日12:39
追加
load_backtesting_workflow
2026年9月17日12:39
追加
load_earnings_workflow
2026年9月17日12:39
追加
load_comparison_workflow
2026年9月17日12:39
追加
load_screening_workflow
2026年9月17日12:39
追加
load_technical_workflow
2026年9月17日12:39
追加
load_fundamental_workflow
2026年9月17日12:39
追加
get_query_patterns
2026年9月17日12:39
追加
get_database_schema
2026年9月17日12:39
追加
stock_data_query
2026年9月17日12:39
関連MCP
類似のMCPサーバー
AlpineDataWorks Intelligence Server
com.alpinedataworks/adw-intelligence-server
Provides economic, market, supply-chain, real-estate, energy, consumer, labor, and other scored intelligence indices with histori…
Stratalize Finance
com.stratalize/finance
Provides financial, macroeconomic, banking, credit, commodities, M&A, ESG, labor, and regulatory benchmarks for analysis and plan…
Valuein — SEC EDGAR Fundamentals & Smart-Money Data
io.github.valuein/mcp-sec-edgar
Provides point-in-time SEC EDGAR fundamentals, filings, ownership signals, financial analysis, valuation models, research reports…
equibles
io.github.daniel3303/equibles
Provides equity and market research tools covering SEC filings, company financials, portfolios, prices, options, macroeconomic da…
DFX Real Estate Intelligence
io.github.Capital-W-Holdings/us-property-parcel-real-estate-debt
Provides US commercial real estate, parcel, debt maturity, bank CRE exposure, private capital, investor, ownership, occupancy, an…
simplefunctions
io.github.spfunctions/simplefunctions
Provides prediction-market data, thesis analysis, market signals, portfolio tracking, and automated intent-based trading workflow…
EventTrader MCP
com.cymetica/event-trader-mcp
Provides prediction-market research and trading capabilities, including real-time event-market data, CLOB execution paths, fund i…
Signal8
ai.signal8/mcp
Provides SEC filings, dilution data, insider and institutional ownership, and political-trade data.