MSSQL MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

list_views

Retrieve details of all database views, including schema and system views, by specifying connection and schema details within MSSQL MCP Server.

Instructions

List all views in the database with their basic information

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)
`includeSystemViews`	No	Include system views (default: false)
`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"
    },
    "includeSystemViews": {
      "description": "Include system views (default: false)",
      "type": "boolean"
    },
    "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