MSSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

list_functions

Retrieve all user-defined functions from a SQL Server database, including scalar and table-valued types, by specifying schema, function type, or connection details.

Instructions

List all user-defined functions (scalar, table-valued, etc.)

Input Schema

Name	Required	Description
`connectionName`	No	Named connection to use (e.g., 'production', 'staging')
`connectionString`	No	SQL Server connection string (uses default if not provided)
`functionType`	No	Filter by function type (default: ALL)
`schema`	No	Schema 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"
    },
    "functionType": {
      "description": "Filter by function type (default: ALL)",
      "enum": [
        "ALL",
        "SCALAR",
        "TABLE_VALUED",
        "INLINE_TABLE_VALUED"
      ],
      "type": "string"
    },
    "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