Skip to main content
Glama

Microsoft SQL Server MCP Server (MSSQL)

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
PORTNoPort for the HTTP/SSE transport3333
DEBUGNoEnable detailed logging
DB_USERYesYour MS SQL Server/Azure SQL database username
DB_SERVERYesYour MS SQL Server name or Azure SQL server address
TRANSPORTNoTransport method (stdio or HTTP/SSE)stdio
SERVER_URLNoURL where the server is accessible when using HTTP/SSE transporthttp://localhost:3333
DB_DATABASEYesYour database name
DB_PASSWORDYesYour MS SQL Server/Azure SQL database password

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
list_connections

List all available named database connections configured in the server

test_connection

Test the database connection and return basic server information

list_databases

List all databases available on the SQL Server instance

list_tables

List all tables in the connected database

describe_table

Get detailed schema information for a specific table including columns, data types, and constraints

sample_data

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

execute_query

Execute a custom SQL SELECT query with automatic limit (top 20 rows)

get_relationships

Get foreign key relationships between tables in the database

list_stored_procedures

List all stored procedures, functions, and their basic information

describe_stored_procedure

Get detailed information about a specific stored procedure including parameters and definition

list_views

List all views in the database with their basic information

describe_view

Get detailed information about a specific view including its definition and dependencies

list_triggers

List all triggers in the database with their associated tables

describe_trigger

Get detailed information about a specific trigger including its definition and events

list_functions

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

list_indexes

List all indexes on tables with usage statistics and detailed information

analyze_table_stats

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

find_missing_indexes

Identify potentially missing indexes based on query execution patterns

analyze_index_usage

Show detailed index usage statistics to identify unused or underutilized indexes

analyze_database_size

Get comprehensive database size information including data and log file sizes

list_constraints

List all constraints (check, unique, foreign key, etc.) across tables in the database

analyze_check_constraints

Extract and analyze business rules from check constraints

list_user_defined_types

List all user-defined data types and their definitions

find_computed_columns

List computed columns and their formulas to understand derived business logic

list_default_constraints

List all default value constraints and their definitions

analyze_data_distribution

Get data distribution patterns for columns to understand data quality and patterns

find_lookup_tables

Identify reference/lookup tables automatically based on table patterns

analyze_null_patterns

Find columns with high null percentages and analyze null patterns

detect_audit_columns

Identify common audit trail patterns (created/modified dates, user tracking)

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