Skip to main content
Glama

SQL Server MCP Service

by vini-cius

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
ORIGINNoAllowed CORS origins (comma-separated)
NODE_ENVNoNode environment (development/production)development
SQL_PORTNoSQL Server port1433
SQL_USERYesDatabase username
HTTP_PORTNoHTTP server port3333
SQL_SERVERNoSQL Server hostname/IPlocalhost
SQL_ENCRYPTNoEnable encryptiontrue
SQL_DATABASENoDatabase namemaster
SQL_PASSWORDYesDatabase password
SQL_TRUST_CERTNoTrust server certificatefalse

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
execute_query

Executes a SQL query in SQL Server

get_table_schema

Gets the schema of a specific table

list_tables

Lists all the tables in the database

get_database_info

Gets general information from the database

list_procedures

Lists all stored procedures in the database

list_functions

Lists all functions (scalar and table-valued) in the database

get_procedure_schema

Gets the schema and parameters of a specific stored procedure

get_function_schema

Gets the schema and parameters of a specific function

execute_procedure

Executes a stored procedure with parameters

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/vini-cius/mcp-sqlserver'

If you have feedback or need assistance with the MCP directory API, please join our Discord server