Skip to main content
Glama

MSSQL MCP Server

by c0h1b4

analyze_table_stats

Retrieve table row counts, size details, and last update statistics for SQL Server databases to monitor and optimize database performance. Supports schema-specific filters and optional connection parameters.

Instructions

Get table row counts, size information, and last update statistics

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

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" }, "schema": { "description": "Schema name (default: dbo)", "type": "string" }, "tableName": { "description": "Filter by specific table name", "type": "string" } }, "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