Skip to main content
Glama

MSSQL MCP Server

by c0h1b4

sample_data

Retrieve top 10 rows (customizable) from a specified table in MSSQL databases using a connection string or named connection for quick data sampling.

Instructions

Retrieve sample data from a table (top 10 rows by default)

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
limitNoNumber of rows to return (default: 10, max: 100)
schemaNoSchema name (default: dbo)
tableNameYesName of the table to sample

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" }, "limit": { "description": "Number of rows to return (default: 10, max: 100)", "type": "number" }, "schema": { "description": "Schema name (default: dbo)", "type": "string" }, "tableName": { "description": "Name of the table to sample", "type": "string" } }, "required": [ "tableName" ], "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