Databases

strasmore.com

Provides read-only SQL access to Strasmore's US market-data warehouse, with tools to list and describe tables and run ClickHouse SELECT queries against the global_markets database.

1 endpoint4 known toolsFirst detected September 23, 2026Last detected September 23, 2026

ENDPOINT 1

https://ai.strasmore.com/mcp

No auth detected

MCP server metadata

Name: strasmore
Version: 1.0.0

Capabilities

tools

Server instructions

Strasmore is a US market-data warehouse queried with ClickHouse SQL: equity minute and daily bars, trades and NBBO quotes, options trades/quotes/greeks, dividends, splits, fundamentals, SEC filings, insider and 13F holdings, news, and macro series. Start with list_tables, then describe_table, then run_sql. Qualify tables as global_markets.<table>. This access needs no key; its limits are stated in every result, and get_plans lists what each plan adds. Send an API key as 'Authorization: Bearer <key>' on the connection to query at that key's plan.

Known tools 4

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.

Inferred read-only

describe_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.

Inferred read-only

run_sql

Run one read-only ClickHouse SELECT against the global_markets database and get the rows back.

Inferred read-only

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.

Inferred read-only

CONNECT WITH APPROVAL

Client installation

Review this server and its permissions before adding it. Secret placeholders must be set locally.

Codex

~/.codex/config.toml

[mcp_servers.strasmore]
url = "https://ai.strasmore.com/mcp"
enabled = true

Claude Code

.mcp.json

{
  "mcpServers": {
    "strasmore": {
      "type": "http",
      "url": "https://ai.strasmore.com/mcp"
    }
  }
}

Claude Desktop

Settings → Connectors → Add custom connector

Name: strasmore
Remote MCP URL: https://ai.strasmore.com/mcp

Add this remote URL as a custom connector in Claude Desktop. Availability depends on the user plan and workspace policy.

Cursor

.cursor/mcp.json

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

Visual Studio Code

.vscode/mcp.json

Add to Visual Studio Code

{
  "servers": {
    "strasmore": {
      "type": "http",
      "url": "https://ai.strasmore.com/mcp"
    }
  }
}

Generic MCP

Client-specific MCP configuration

{
  "name": "strasmore",
  "transport": "streamable-http",
  "url": "https://ai.strasmore.com/mcp"
}

MCP Inspector

Run the official MCP Inspector locally and enter the indexed Streamable HTTP endpoint.

TRUST AND VERIFICATION EVIDENCE

Loading Trust v2 evidence…

Checking the associated registrable domain. The BuiltWith key remains server-side.

Indexed

Evidence is source-attributed and does not guarantee that a third-party server is safe. Risk labels are conservative metadata heuristics.