US stocks and options data via SQL: bars, ticks, greeks, fundamentals, filings. No key.
Maintain this server? Claim it
Call this server's tools from your browser. Nothing to install.
Requests go through mcptry because browsers can't call most MCP servers directly. Header values are sent to the server for that request only and are never stored or logged.
Tool list from our last check. Connect live to refresh 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.
Table name, e.g. stocks_daily_aggs
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.
| Argument | Type | Description |
|---|---|---|
| table* | string | Table name, e.g. stocks_daily_aggs |
{
"type": "object",
"required": [
"table"
],
"properties": {
"table": {
"type": "string",
"description": "Table name, e.g. stocks_daily_aggs"
}
},
"additionalProperties": false
}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.
No arguments.
{
"type": "object",
"properties": {},
"additionalProperties": false
}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.
No arguments.
{
"type": "object",
"properties": {},
"additionalProperties": false
}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).
| Argument | Type | Description |
|---|---|---|
| sql* | string | A single SELECT statement. |
{
"type": "object",
"required": [
"sql"
],
"properties": {
"sql": {
"type": "string",
"description": "A single SELECT statement."
}
},
"additionalProperties": false
}