Skip to content

Strasmore market data

by ai.strasmore.com · remote · no sign-in to list tools · v1.0.0 · published by com.strasmore.ai

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

Changes · 1
CompareRegistry entry

4 tools: 1 change things and 3 only read.

Scanned Oct 21, 2026

1 check matched something in the tool definitions. No finding is not a safety guarantee. How the checks work.

claude mcp add --transport http market-data https://ai.strasmore.com/mcp

Findings

Matches of fixed checks, with the text they matched.

1 warn
  • Warnrun_sql

    The server marks "run_sql" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

    Matched text

    annotations: {"readOnlyHint":true,"destructiveHint":false,"idempotentHint":true,"openWorldHint":false}; The name "run_sql" says "run": a word for a change.

    What this check looks for

Tools

Open a tool for its reasons and full description. Descriptions are the publisher's own words, shown as they are.

4 tools

Changes things 1Claude Code: ask
  • run_sqlRun one read-only ClickHouse SELECT against the global_markets database and get the rows back.1 finding

    Why it is in this group

    • The name "run_sql" says "run": a word for a change.
    • The input takes a statement or command to run (input.sql), which can change anything it can reach.
    • The server marks it read-only (readOnlyHint: true), but an annotation never lowers a class.

    Findings

    • Warn

      The server marks "run_sql" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

      Matched text

      annotations: {"readOnlyHint":true,"destructiveHint":false,"idempotentHint":true,"openWorldHint":false}; The name "run_sql" says "run": a word for a change.

      What this check looks for
    Description, as the server wrote it
    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. Docs: https://ai.strasmore.com/llms.txt (tables and limits), https://api.strasmore.com/docs (API reference).

    Annotations the server declares

    • readOnlyHint: true
    • destructiveHint: false
    • idempotentHint: true
    • openWorldHint: false
Only reads 3Claude Code: allow
  • describe_tableColumns of one table with their ClickHouse types, plus notes on columns whose meaning is not obvious from the name and known data caveats.No findings

    Why it is in this group

    • The name "describe_table" says "describe": a word for reading.
    Description, as the server wrote it
    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.

    Annotations the server declares

    • readOnlyHint: true
    • destructiveHint: false
    • idempotentHint: true
    • openWorldHint: false
  • get_plansWhat 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.No findings

    Why it is in this group

    • The name "get_plans" says "get": a word for reading.
    Description, as the server wrote it
    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.

    Annotations the server declares

    • readOnlyHint: true
    • destructiveHint: false
    • idempotentHint: true
    • openWorldHint: false
  • list_tablesList 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 it…No findings

    Why it is in this group

    • The name "list_tables" says "list": a word for reading.
    Description, as the server wrote it
    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.

    Annotations the server declares

    • readOnlyHint: true
    • destructiveHint: false
    • idempotentHint: true
    • openWorldHint: false

This is not a safety rating, and no finding is not a safety guarantee. The groups and findings come from fixed checks of the tool definitions the server returned on the date shown, not from its code or what it does when called. How the checks work.

Install

Pinned to version 1.0.0. Values in angle brackets are yours to fill in.

claude mcp add --transport http market-data https://ai.strasmore.com/mcp

Run in a terminal.

Claude Code permissions

Allow the reads, ask before a change, deny the deletes. Paste into .claude/settings.json.

.claude/settings.json
{
  "permissions": {
    "allow": [
      "mcp__market-data__list_tables",
      "mcp__market-data__describe_table",
      "mcp__market-data__get_plans"
    ],
    "ask": [
      "mcp__market-data__run_sql"
    ],
    "deny": []
  }
}

Tools that only read are allowed, tools that change things ask first, tools that delete or cancel are denied. It assumes the server is installed as market-data. Review it before you use it.