Skip to main content
Glama

MSSQL MCP Server

by c0h1b4

find_lookup_tables

Identify reference or lookup tables automatically by analyzing table patterns in SQL Server. Specify schema, connection details, and row limits to streamline database management.

Instructions

Identify reference/lookup tables automatically based on table patterns

Input Schema

NameRequiredDescriptionDefault
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
connectionStringNoSQL Server connection string (uses default if not provided)
maxRowsNoMaximum rows to consider as lookup table (default: 1000)
schemaNoSchema name (default: dbo)

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" }, "maxRows": { "description": "Maximum rows to consider as lookup table (default: 1000)", "type": "number" }, "schema": { "description": "Schema name (default: dbo)", "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