Strasmore Research

Worked examples of the Strasmore API

One page per task that people and AI agents run against the API: the SQL, a result we ran and checked, and the same call in curl, MCP and Python. Every example runs on the free demo, with no key and no signup.

Pages

The first pages are in review. A page is published here only after it has been reviewed, and never more than one a day.

Start without a key

Run read-only SQL over HTTP

Any SELECT, against the whole schema. Rejections say why, so a failed call is worth reading.

curl 'https://ai.strasmore.com/api/demo/sql?sql=SELECT+ticker,close+FROM+delayed_stocks_minute_aggs+LIMIT+5'

See every table and column

36 tables in one schema, all joinable on ticker.

curl 'https://ai.strasmore.com/api/demo/schema'

Connect an AI assistant (MCP)

The same read-only access over the Model Context Protocol, with no key.

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

Without a key: 500 rows, 20 seconds and 1 year of history per query. With an API key, the same calls run at your plan's limits. The API documentation lists every endpoint.