Skip to main content
Glama
singlestore-mcp-server

singlestore-mcp-server

by jonasliesas

cas_caslib_code

Read-only

Generates the CASLIB statement and table.addCaslib action code for a given caslib from caslibInfo, using placeholders for secrets and executing nothing.

Instructions

The CASLIB statement and the table.addCaslib action (PROC CAS) for one caslib, reconstructed from caslibInfo (verbose); passwords / tokens / authentication domains as placeholders. Nothing is run.

Input Schema

NameRequiredDescriptionDefault
caslibYes
connectionNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv0.11.0

TDQS

B3.4/5.0
Behavior4/5

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

Annotations only declare readOnlyHint=true, and the description corroborates this by stating nothing is executed. It adds genuinely useful behavior beyond annotations: credentials, tokens, and authentication domains are emitted as placeholders (so output is not directly runnable and is safe to share), and the source of truth is caslibInfo in verbose mode.

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?

It is a single dense sentence that front-loads the produced artifacts before the caveats about placeholders and non-execution. The doubled backtick artifacts and stacked parentheticals ('(PROC CAS)', '(verbose)') make it slightly harder to parse than necessary, but there is no filler.

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

Completeness3/5

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

For a two-parameter, no-output-schema tool, the description covers what is generated and the placeholder behavior, which is the core risk. It omits the return form (presumably a text snippet) and the meaning of 'connection', which leaves a real gap given 0% schema coverage.

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

Parameters2/5

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

Schema description coverage is 0%, so the description must carry the burden. 'For one caslib' gives context for the required caslib parameter, but the second parameter, 'connection', is never mentioned, leaving its role (which CAS server/connection context the reconstruction targets) entirely unexplained.

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 the concrete artifact produced: a CASLIB statement plus the table.addCaslib action for a single caslib, reconstructed from caslibInfo (verbose). An agent can tell this is a code-generation/reconstruction tool rather than a lister like cas_caslibs or an action tool like cas_load_table. It stops short of naming the closest sibling (e.g. sas_library_code) for explicit differentiation.

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?

The phrase 'Nothing is run' implies a safe, generation-only use case, and 'reconstructed from caslibInfo' hints at when the tool is appropriate. However, there is no explicit when-to-use vs when-not guidance and no named alternative for retrieving caslib definitions, so the agent must infer selection from the sibling list.

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

Deploy Server

Other Tools