Skip to main content
Glama
jonasliesas

singlestore-mcp-server

by jonasliesas

Security

security
Read-only

Open a read-only view of SingleStore users, roles, privileges, and resource pools; review risk flags, access paths, queue limits, and copy suggested SQL.

Instructions

Open the Security view of the SingleStore cluster (read-only).

Tabs: "users" (every user with type, lock status, password age and expiry, default resource pool, groups,
connections and risk flags such as ALL/SUPER on *.*, host '%', password never expires, locked, unused),
"roles" (user -> group -> role -> privileges, and "who can access" a database or table) and "pools"
(resource pool limits and live status, the workload manager queue with the limit each queued query waits
for, and which users use which pool). Nothing is changed: where a change would help, the view shows SQL
the user can copy.

The result includes ``browser_url``, which opens this view full-window in the user's browser: post it
as a clickable link right under the app.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
tabNousers

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed1 schema field changedv0.10.1
    • changedInput schema / properties / tab / enum
      Previous value: -[
      -  "users",
      -  "roles",
      -  "pools"
      -]New value: +[
      +  "users",
      +  "roles",
      +  "pools",
      +  "audit"
      +]
  2. Addedv0.9.0

TDQS

A3.8/5.0
Behavior4/5

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

Annotations only carry readOnlyHint=true, and the description adds real context beyond that: 'Nothing is changed: where a change would help, the view shows SQL the user can copy', plus the fact that results include browser_url and should be posted as a link under the app. Minor gap: the description omits any behavior for the 'audit' tab that the schema exposes.

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?

Front-loaded with purpose and read-only status, then tab-by-tab detail, then the browser_url handling instruction. The parenthetical tab detail is dense but every clause adds decision-relevant content; only slight trimming would be possible.

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 correctly carries the return-value burden by naming browser_url and its intended presentation. Content per tab is well covered for three of four tabs, but the 'audit' tab is left undefined, leaving an enum value the agent cannot explain.

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% and the single 'tab' parameter's enum values are opaque on their own, so the description does heavy lifting by explaining what the users, roles, and pools tabs contain (risk flags, privilege chains, pool limits/queue). It fails to describe the fourth enum value, 'audit', which is a notable omission given security_audit exists as a sibling.

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+resource: 'Open the Security view of the SingleStore cluster (read-only)', plus tab-level scope. It is clear this is a view-opening tool rather than a data-query tool, though it never explicitly distinguishes itself from close siblings such as security_users, security_roles, security_pools, or security_audit, which cover the same ground.

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 only implied: the description explains what the view contains and that changes surface as copyable SQL, which hints at when a human-facing view is preferable to a data tool. There is no explicit when-to-use-vs-alternative guidance, even though many siblings (security_users, who_can_access, resource_pool_status) overlap with these tabs.

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