Strasmore market data

US stocks and options data via SQL: bars, ticks, greeks, fundamentals, filings. No key.

Should I use this

Quality & Safety

A
Description quality
100%
Schema completeness
65%
Naming quality
95%
Poisoning risk
100%
Permission match
100%
Protocol compliance
100%

Based on automated analysis of tool definitions and protocol compliance.

Context Cost

~423Tokens (tool definitions)
~323 BTypical response size
Minimal attention impact (0.33% of 128k context)

This is the approximate number of tokens consumed each time the server's tools are loaded into a model's context. Higher counts reduce the attention available for other tasks.

Install

One-Click Install

Add this to your `claude_desktop_config.json` file:

{
  "mcpServers": {
    "market-data": {
      "url": "https://ai.strasmore.com/mcp"
    }
  }
}

Remote endpoints

https://ai.strasmore.com/mcpstreamable-http

What it can do

Tool inventory

Tools (4)

🟢 Read-only🟡 Write🔴 Delete⚪ Unknown
🟢list_tables

List every table in the Strasmore US market-data warehouse (equities, options, corporate actions, fundamentals, SEC filings, news, macro) with a one-line description, the column its history window filters on, and whether this no-key access can read it. Call this first.

Input Schema

{
  "type": "object",
  "properties": {},
  "additionalProperties": false
}
🟢describe_table(table)

Columns of one table with their ClickHouse types, plus notes on columns whose meaning is not obvious from the name and known data caveats. Call before writing SQL against a table.

Input Schema

{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name, e.g. stocks_daily_aggs"
    }
  },
  "required": [
    "table"
  ],
  "additionalProperties": false
}
🟢run_sql(sql)

Run one read-only ClickHouse SELECT against the global_markets database and get the rows back. No key needed. Limits on this access: 500 rows and 20 seconds per query, history from 2025-01-01, and some tick-level tables excluded — each result states which limit, if any, it ran into. Connected with an API key, it runs at that key's plan instead.

Input Schema

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "A single SELECT statement."
    }
  },
  "required": [
    "sql"
  ],
  "additionalProperties": false
}
🟢get_plans

What this no-key access includes, what a free account and each paid plan add (history depth, datasets, row limits, price), and the link to start each one.

Input Schema

{
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

Community

Rate this Server

Evidence

Recent observations

verifiedversion not recorded4 tools