Skip to main content
Glama

MSSQL MCP Server

by c0h1b4

execute_query

Run SQL SELECT queries on MSSQL databases via the MCP server, retrieving top 20 rows by default. Specify connection details or use defaults for quick data extraction.

Instructions

Execute a custom SQL SELECT query with automatic limit (top 20 rows)

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
queryYesSQL SELECT query to execute

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "connectionName": { "description": "Named connection to use (e.g., 'production', 'staging')", "type": "string" }, "connectionString": { "description": "SQL Server connection string (uses default if not provided)", "type": "string" }, "query": { "description": "SQL SELECT query to execute", "type": "string" } }, "required": [ "query" ], "type": "object" }

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

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