SQL Server MCP Service
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ORIGIN | No | Allowed CORS origins (comma-separated) | |
| NODE_ENV | No | Node environment (development/production) | development |
| SQL_PORT | No | SQL Server port | 1433 |
| SQL_USER | Yes | Database username | |
| HTTP_PORT | No | HTTP server port | 3333 |
| SQL_SERVER | No | SQL Server hostname/IP | localhost |
| SQL_ENCRYPT | No | Enable encryption | true |
| SQL_DATABASE | No | Database name | master |
| SQL_PASSWORD | Yes | Database password | |
| SQL_TRUST_CERT | No | Trust server certificate | false |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryC | Executes a SQL query in SQL Server |
| get_table_schemaC | Gets the schema of a specific table |
| list_tablesB | Lists all the tables in the database |
| get_database_infoC | Gets general information from the database |
| list_proceduresC | Lists all stored procedures in the database |
| list_functionsA | Lists all functions (scalar and table-valued) in the database |
| get_procedure_schemaA | Gets the schema and parameters of a specific stored procedure |
| get_function_schemaC | Gets the schema and parameters of a specific function |
| execute_procedureC | Executes a stored procedure with parameters |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
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