Skip to main content
Glama
dperussina

Microsoft SQL Server MCP Server (MSSQL)

sample_data

Retrieve sample rows from SQL Server tables to preview data structure and content. Specify table name, schema, and row limit for quick data exploration.

Instructions

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

Input Schema

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

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

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