Skip to main content
Glama
vicagbasi

MSSQL MCP Server

by vicagbasi

Execute SQL Query

execute_query

Execute SQL SELECT queries on MSSQL databases with automatic 20-row limit to prevent excessive data retrieval.

Instructions

Execute a custom SQL SELECT query with automatic limit (top 20 rows). Disabled unless MSSQL_ENABLE_EXECUTE_QUERY=true.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
queryYesSQL SELECT query to execute
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
Behavior2/5

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

With no annotations provided, the description carries full burden. It discloses the automatic limit and configuration requirement but omits behavioral details such as return format, error handling, or safety precautions, which are critical for a potentially risky operation.

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, no extraneous information. The first sentence captures the core purpose, the second adds an essential precondition. Every word earns its place.

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?

Given no output schema and no annotations, the description is adequate but incomplete. It lacks details on result format and potential risks, which are important for a tool that executes arbitrary SQL queries.

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 coverage is 100%, so baseline is 3. The description adds automatic limit context for the query parameter but does not significantly enhance understanding beyond the schema descriptions for either parameter.

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 tool executes a custom SQL SELECT query with an automatic limit. It is distinct from sibling tools which are analytical or metadata retrieval tools, not query execution.

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 description mentions a precondition (MSSQL_ENABLE_EXECUTE_QUERY=true) but lacks explicit guidance on when to use this tool versus alternatives or when not to use it (e.g., heavy queries). It only implies usage context.

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

Install Server

Other Tools

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/vicagbasi/mssql-mcp'

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