Shibui Finance
finance.shibui/data
11 toolsHTTPregistry active
Summary
This connects Claude to over six decades of US equity market data covering 9,900+ stocks through a plain English interface. You get access to historical prices, company financials, technical indicators, and earnings reports without wrestling with typical financial data APIs. Reach for this when you need to analyze stock performance, compare fundamentals across companies, or pull historical market data for backtesting strategies. The streamable HTTP transport means you can query decades of financial data conversationally rather than constructing complex API calls or downloading CSV files.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Tools
Public tool metadata for what this MCP can expose to an agent.
11 tools
stock_data_queryStock prices, earnings, revenue, P/E, dividends, margins, 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. Cal...2 params
Stock prices, earnings, revenue, P/E, dividends, margins, 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. Cal...
Parameters* required
querystringRead-only SQL query to execute. Requires shibui. table prefix and a LIMIT clause.
user_promptstringThe 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 — never leave empty.
get_database_schemaREQUIRED 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 ind...
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 ind...
No parameter schema in public metadata yet.
get_query_patternsREQUIRED before stock_data_query, 19 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 p...
REQUIRED before stock_data_query, 19 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 p...
No parameter schema in public metadata yet.
load_fundamental_workflowLoad 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 le...
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 le...
No parameter schema in public metadata yet.
load_technical_workflowLoad 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, o...
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, o...
No parameter schema in public metadata yet.
load_screening_workflowLoad screening workflow to find, filter, 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, rank, or filter stocks — "find stocks that...", "top 10 by....
Load screening workflow to find, filter, 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, rank, or filter stocks — "find stocks that...", "top 10 by....
No parameter schema in public metadata yet.
load_comparison_workflowLoad 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 benchmark...
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 benchmark...
No parameter schema in public metadata yet.
load_earnings_workflowLoad 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 es...
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 es...
No parameter schema in public metadata yet.
load_backtesting_workflowLoad backtesting workflow for signal testing, forward returns, win rates. 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, test a strategy, check "what happens after X", compare for...
Load backtesting workflow for signal testing, forward returns, win rates. 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, test a strategy, check "what happens after X", compare for...
No parameter schema in public metadata yet.
load_filing_workflowLoad filing workflow for SEC/EDGAR, insider trades, 8-K, Form 4, 10-K queries. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL whenever the user asks about filings, "who filed", "filed a form", filing dates, fili...
Load filing workflow for SEC/EDGAR, insider trades, 8-K, Form 4, 10-K queries. REQUIRES get_database_schema then get_query_patterns to be called first (in that order). Call BEFORE writing SQL whenever the user asks about filings, "who filed", "filed a form", filing dates, fili...
No parameter schema in public metadata yet.
export_to_excelExport 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.2 params
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.
Parameters* required
querystringThe SQL query to execute and export. Same query used with stock_data_query.
titlestringTitle for the spreadsheet header (e.g. "Mega-Cap Stock Comparison").
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
