Skip to main content
Glama
jonasliesas

singlestore-mcp-server

by jonasliesas

SingleStore Notebook

notebook
Read-only

Open a SingleStore Jupyter-style file to run SQL and Python cells; SQL results become pandas DataFrames for Python analysis with matplotlib and database connections.

Instructions

Open a SingleStore notebook: SQL and Python cells on a Jupyter kernel.

SQL cell results become pandas DataFrames for the Python cells; Python has
pandas, matplotlib and `conn` (a SingleStore connection). Notebooks are
.ipynb files in the user's SQL folder. It's also the Notebook view of the
SingleStore Workspace (sql_editor with view="notebook").

The result includes ``browser_url``: post it as a clickable link under the app.

Args:
    name: Notebook file to open (e.g. "sales.ipynb"); omit for a new notebook.
    database: Database for SQL cells (case-sensitive).

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nameNo
databaseNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv0.8.1

TDQS

A3.8/5.0
Behavior4/5

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

Annotations only supply readOnlyHint=true, and the description adds real behavioral context: Python cells get pandas, matplotlib and a `conn` connection, SQL results become DataFrames, and the result carries a `browser_url` that should be posted as a clickable link. It does not explain session lifetime, kernel startup side effects, or persistence behavior.

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?

Efficient and front-loaded, opening with the verb+resource before elaborating on execution semantics. The middle paragraph is slightly dense but each sentence carries information the agent needs; nothing is pure 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?

No output schema exists, yet the description discloses the key return artifact (browser_url) and how to use it, and it covers both zero-required parameters. Minor gap: it doesn't clarify what happens to an existing notebook vs. a new one, or the relationship to the kernel-control siblings.

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?

Schema coverage is 0%, so the description carries the full burden, and it does: `name` is a notebook file with an example ('sales.ipynb') plus the omit-to-create semantics, and `database` is scoped to SQL cells and flagged case-sensitive. That is meaningfully more than the bare anyOf string schema provides.

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?

States a specific verb and resource ('Open a SingleStore notebook') and explains what the resource is: SQL and Python cells on a Jupyter kernel, stored as .ipynb in the user's SQL folder. It even names an equivalence with a sibling ('the Notebook view ... sql_editor with view="notebook"'), though it never differentiates itself from the very similar notebook_open/notebook_run siblings.

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 context is implied rather than stated: the args section gives 'omit for a new notebook' for name, which tells the agent how to trigger new-notebook creation, and the browser_url instruction implies a UI-flow. But there is no explicit when-to-use / when-not-to-use versus notebook_open, notebook_run or sql_editor.

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