Skip to main content
Glama

Strasmore market data

Server Details

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

If you are the author of this connector, you can claim ownership with GitHub, an HTTP challenge, or a DNS record. Claimed connector authors can inspect health checks, view analytics, and manage their listing.
Status
Healthy
Last Tested
Transport
Streamable HTTP · MCP 2025-11-25
URL

TDQS

A4.4/5.0

Scored across 4 tools

Disambiguation5/5

Each tool has a distinct responsibility: discovering tables, inspecting schemas, running queries, and explaining access plans. There is no overlap or ambiguity between them.

Naming Consistency5/5

All tool names follow the same verb_noun snake_case pattern: describe_table, get_plans, list_tables, run_sql. The naming is predictable and easy to reason about.

Tool Count5/5

Four tools is an appropriate scope for a read-only market-data warehouse server. Each tool serves a clear purpose in the workflow without redundancy or bloat.

Completeness5/5

The set covers the full user journey: list available tables, understand their schemas, run read-only SQL, and learn about plan limitations. There are no obvious dead ends or missing operations for the stated purpose.

Available Tools

4 tools
describe_tableDescribe a tableA
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
tableYesTable name, e.g. stocks_daily_aggs

TDQS

A4.3/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The annotations already mark the operation as read-only, and the description adds useful behavioral context by explaining that the tool returns per-column type information plus non-obvious column notes and known data caveats. It does not discuss auth, rate limits, or side effects, but the absence of side effects is already conveyed by the readOnlyHint.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two sentences efficiently cover what the tool returns and when to call itainer. There is no redundant restatement of the tool name or title, and every clause adds useful information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple, read-only, single-parameter introspection tool, the description is complete: it states the resource, the output, the caveats, and the correct point in the workflow. No critical missing context would prevent an agent from using it correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%: the only parameter, 'table', is fully documented with a name, type, and example value. The description does not add any extra parameter-level guidance, so the baseline score of 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the resource ('one table'), the kind of information returned (columns with ClickHouse types, notes, data caveats), and distinguishes it from siblings like list_tables by narrowing scope to a single table. It also frames the tool as a pre-SQL inspection step rather than a query execution tool like run_sql.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives an explicit trigger: 'Call before writing SQL against a table.' This tells the agent when to use it, though it does not explicitly name alternatives or say when not to use it. The intended placement in the workflow is still clear enough to guide selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_plansPlans and limitsA
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A3.8/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The readOnlyHint is already provided by annotations, and the description adds useful context by mentioning 'no-key access' (auth behavior) and outlining what the operation covers. It does not contradict the annotations and discloses enough for a simple no-parameter read operation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single compact sentence that front-loads the key idea and packs the relevant dimensions into a parenthetical. It is slightly awkward grammatically, but every element earns its place and there is no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

There is no output schema, so the description carries the burden of explaining return values. It lists the main content categories (included access, plan additions, pricing, links) at a sufficient level for an agent to call a parameterless tool correctly, though exact output formatting is not specified.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, so there is nothing for the description to explain beyond what the empty schema already conveys. The description adds no parameter-specific ambiguity, matching the baseline for a no-parameter tool.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description identifies a clear resource ('no-key access', 'free account', 'paid plans') and the specific content areas (history depth, datasets, row limits, price). It is obviously distinct from the sibling tools, which all deal with tables or SQL queries, though it lacks an explicit verb like 'returns' or 'lists'.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Usage is implied through the content: an agent would use this when it needs plan or limit information. However, the description does not explicitly state when to choose this tool over alternatives, nor does it mention any exclusions or prerequisites.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_tablesList tablesA
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true, and the description reinforces this by mentioning 'no-key access can read it,' implying some tables may not be readable. It also discloses the structure of each returned entry (description, filter column, readability), which goes beyond the bare read-only annotation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, well-structured sentence that front-loads the main action, lists the market-data categories parenthetically, and ends with the crucial 'Call this first' guidance. No wasted words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a zero-parameter tool with no output schema, the description fully specifies what an agent will receive: table names with a description, a filter column, and readability status. The 'Call this first' instruction provides contextual placement, making the description sufficient for correct invocation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters, so the schema provides no information to supplement. With a parameter count of 0, the baseline is 4, and the description appropriately focuses on what the tool returns rather than parameter details.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb and resource ('List every table') and enumerates the exact contents returned: a one-line description, the history-window filter column, and readability under no-key access. This clearly distinguishes it from the sibling describe_table (which presumably details a single table) without needing to name it.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description explicitly says 'Call this first,' establishing it as the initial discovery step before using siblings like describe_table or run_sql. However, it doesn't explicitly state when not to use it or name alternatives, leaving some inference to the agent.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run_sqlRun SQLA
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
sqlYesA single SELECT statement.

TDQS

A4.5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the readOnlyHint annotation, the description discloses meaningful behavioral constraints: 500-row and 20-second limits, data history starting 2025-01-01, excluded tick-level tables, and that each result indicates which limit was hit. It also clarifies authentication requirements with 'No key needed,' which annotations do not include.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is two front-loaded sentences with no filler. The main action is stated first, followed by compact, high-value constraints and result behavior.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a single-parameter read-only tool with no output schema, the description is complete: it explains what is run, what is returned, access requirements, limits, and result behavior. Nothing needed for a correct invocation is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the sql parameter is already documented as 'A single SELECT statement.' The description adds the read-only and limits context for the query but does not add new semantic detail about the parameter format beyond the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb and resource: 'Run one read-only ClickHouse SELECT against the global_markets database and get the rows back.' It clearly distinguishes the tool from siblings like list_tables and describe_table by framing it as actual SQL query execution rather than metadata inspection.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives clear operational context: read-only SELECTs, no key needed, and explicit access limits. It does not name alternatives or state when not to use this tool versus list_tables/describe_table, so it misses explicit exclusion guidance but still conveys sufficient context for basic selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 4 tool updates
    • First observeddescribe_table
    • First observedget_plans
    • First observedlist_tables
    • First observedrun_sql

Related MCP Connectors

Related MCP Servers

  • A
    license
    Not graded
    quality
    B
    maintenance
    Provides US stock market data for AI agents, including intraday and daily bars, SEC fundamentals, filings, and insider data, with pay-per-query via USDC on Base.
    1
    MIT
  • A
    license
    A
    quality
    B
    maintenance
    Provides as-reported US equity fundamentals, live quotes, financial statements, valuation comps, and a screener from SEC filings, with per-cell filing provenance for citations.
    7
    MIT
  • A
    license
    Not graded
    quality
    B
    maintenance
    Provides free SEC filing fundamentals for US public companies, including financial statements, 10-K/10-Q summaries, and 8-K event histories. No API key or signup required.
    MIT
  • -
    license
    Not graded
    quality
    Not graded
    maintenance
    Real-time financial market data MCP server. Stocks, crypto, technicals, sentiment, FDA calendar. No API keys required.
    -
Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources