Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

sample_data

Retrieve sample rows from a specified table in Microsoft SQL Server. Configure schema, connection, and row limit to quickly explore database content without SQL coding.

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

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