Strasmore market data
by ai.strasmore.com in Markets & finance
US stocks and options data via SQL: bars, ticks, greeks, fundamentals, filings. No key.
https://ai.strasmore.com/mcp
Last 30 days
- Uptime
- 100%
- Response time
- 280 ms typical, 340 ms slowest 5%
- Last check
- 2 h ago
- Next check
- in 4 h
How to call it
Add it to any MCP client that supports remote servers.
{
"mcpServers": {
"strasmore-market-data": {
"type": "http",
"url": "https://ai.strasmore.com/mcp"
}
}
}4 tools
- 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.
- 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. Call before writing SQL against a table.
- run_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 in
- 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.
Security scan
- No findings. We scan names, descriptions and tool definitions for hidden instructions and other prompt-injection patterns.
Recent checks
| When | Result | HTTP | Time |
|---|---|---|---|
| 2 h ago | Passed | 200 | 217 ms |
| 11 h ago | Passed | 200 | 340 ms |
| 21 h ago | Passed | 200 | 280 ms |
| 30 h ago | Passed | 200 | 572 ms |