Skip to main content
Glama
TGich

dm_mcp_server

by TGich

execute_sql

Run SQL queries on Dameng database with enforced schema limits. Supports conditional row fetching and pagination via limit and offset.

Instructions

执行 SQL 语句(强制限定配置下的SCHEMA操作)

参数: sql: 要执行的 SQL 语句 fetch_results: 是否返回查询结果(默认 True) limit: 限制返回的行数,用于分页(可选) offset: 跳过的行数,用于分页(可选)

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sqlYes
limitNo
offsetNo
fetch_resultsNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. First observedv2.6.2

TDQS

C2.9/5.0
Behavior2/5

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

With no annotations, the description carries the full burden of disclosing behavior, but it only says SQL statements are executed. It does not state whether the tool is read-only, whether commits occur, what SQL dialects or operations are allowed, what happens with destructive statements, or what the response contains. The '强制限定配置' phrase suggests restriction but fails to define it concretely.

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 appropriately short and front-loads the main purpose before listing parameters. The parameter list is easy to scan and avoids excessive detail. The parenthetical is somewhat cryptic, but no sentences are wasted.

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

Completeness2/5

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

For a tool named execute_sql with multiple siblings, no annotations, and a potentially dangerous operation, the description is incomplete. It omits allowed SQL statement types, result format, pagination behavior, error handling, and security restrictions. An agent cannot confidently decide whether this tool will safely execute a given SQL statement or whether to choose execute_sql_file or list_tables instead.

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 0%, so the description must compensate. The parameter list restates the schema names but does add minimal meaning: limit is for pagination, offset skips rows, and fetch_results controls result return. However, it does not explain how these interact, whether limit/offset apply to all statements or only queries, or what constraints exist on the sql parameter.

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 clearly identifies the core action: '执行 SQL 语句' (execute SQL statements). The parenthetical '强制限定配置下的SCHEMA操作' adds some scoping, suggesting operations are constrained, but it is vague about whether this means schema-only, read-only, or sandboxed execution. It is distinguishable from execute_sql_file because it executes a raw SQL string rather than a file.

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

Usage Guidelines2/5

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

No explicit guidance is given about when to use this tool versus its siblings like execute_sql_file, list_tables, or switch_schema. The parenthetical hints at a restricted configuration but never states the conditions under which execute_sql is appropriate or when another tool should be chosen. An agent is left to infer usage context.

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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/TGich/dm_mcp_server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server