Skip to main content
Glama

Server Details

9,900+ US equities, 64 years of prices, financials, technicals, and earnings. Ask in plain English.

If you are the author of this connector, you can claim ownership. Claimed connector authors can inspect health checks, view analytics, and manage their listing.
Status
Healthy
Uptime
100.0% over the last 24 hours
Last Tested
Transport
Streamable HTTP · MCP 2025-11-25
URL
ChatGPT
–
Claude
–

TDQS

A4.3/5.0

Scored across 12 tools

Disambiguation4/5

Most tools have distinct roles: schema/pattern setup, SQL query, Excel export, and domain-specific workflow loaders. However, the eight load_*_workflow tools overlap at the edges (e.g., earnings vs. fundamental for revenue trends, comparison vs. fundamental for valuation, backtesting vs. technical for indicators), so an agent may occasionally need to combine or choose among them.

Naming Consistency4/5

Nearly all names are snake_case with clear action prefixes: get_* for setup, load_*_workflow for workflows, and export_to_excel for export. The main minor deviation is stock_data_query, which uses a noun phrase rather than a verb_noun pattern.

Tool Count5/5

12 tools is well within a reasonable range for a broad financial-data analysis server. The set is scoped by responsibility: two setup tools, one query tool, one export tool, and eight focused workflow loaders covering major analysis patterns.

Completeness5/5

The surface covers the full read-only analysis lifecycle: schema discovery, query patterns, SQL execution, Excel export, and workflow guidance for backtesting, comparison, earnings, filings, fundamentals, insider activity, screening, and technical analysis. No obvious domain operation is missing for this purpose.

Available Tools

12 tools
export_to_excelExport to ExcelA
Destructive
Inspect

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.

Inputs: query (required), title (required).

get_database_schemaLoad Database SchemaA
Read-onlyIdempotent
Inspect

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 10,000+ NYSE and NASDAQ securities with 64 years of daily prices, quarterly financials, 61 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.

Inputs: no named parameters.

get_query_patternsLoad Query PatternsA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_backtesting_workflowBacktesting Analysis WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_comparison_workflowPeer Comparison WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_earnings_workflowEarnings Analysis WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_filing_workflowSEC Filing Analysis WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_fundamental_workflowFundamental Analysis WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_insider_workflowInsider Transaction WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_screening_workflowStock Screening WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

load_technical_workflowTechnical Analysis WorkflowA
Read-onlyIdempotent
Inspect

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.

Inputs: no named parameters.

stock_data_queryQuery Stock DataA
Read-onlyIdempotent
Inspect

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.

Inputs: query (required), user_prompt (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables financial research on US-listed equities by answering natural language questions with structured data from fundamentals, prices, earnings, and insider activity.
      3
      MIT
    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables natural-language research and structured, source-backed answers across SEC filings, earnings transcripts, company financials, stock and crypto market data, and prediction markets news and research.
      -
    • A
      license
      Not graded
      quality
      A
      maintenance
      Enables natural-language research across SEC filings, earnings transcripts, financial metrics, stock and crypto market data, and prediction markets, returning structured, source-backed answers for investors, analysts, and researchers.
      MIT
    • F
      license
      Not graded
      quality
      A
      maintenance
      Enables users to ask natural-language questions and receive structured, source-backed answers across public filings, earnings transcripts, company financials, stock and crypto market data, news, and prediction markets research.
      -
    Try in Browser

    Glama MCP Gateway

    Add one secure layer between your agents and this server.

    Resources