Explore and query Microsoft SQL Server read-only: catalogue search, schema and bounded queries.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add sezzlee-sql --env SEZZLEE_MSSQL_SERVER='<SEZZLEE_MSSQL_SERVER>' --env SEZZLEE_MSSQL_DATABASE='<SEZZLEE_MSSQL_DATABASE>' --env SEZZLEE_MSSQL_USER='<SEZZLEE_MSSQL_USER>' --env SEZZLEE_MSSQL_PASSWORD='<SEZZLEE_MSSQL_PASSWORD>' -- npx -y @sezzlee/mssql-mcp~/.codex/config.toml
[mcp_servers.sezzlee-sql]
command = "npx"
args = ["-y", "@sezzlee/mssql-mcp"]
env = { SEZZLEE_MSSQL_SERVER = "<SEZZLEE_MSSQL_SERVER>", SEZZLEE_MSSQL_DATABASE = "<SEZZLEE_MSSQL_DATABASE>", SEZZLEE_MSSQL_USER = "<SEZZLEE_MSSQL_USER>", SEZZLEE_MSSQL_PASSWORD = "<SEZZLEE_MSSQL_PASSWORD>" }
# codex mcp add sezzlee-sql --env SEZZLEE_MSSQL_SERVER='<SEZZLEE_MSSQL_SERVER>' --env SEZZLEE_MSSQL_DATABASE='<SEZZLEE_MSSQL_DATABASE>' --env SEZZLEE_MSSQL_USER='<SEZZLEE_MSSQL_USER>' --env SEZZLEE_MSSQL_PASSWORD='<SEZZLEE_MSSQL_PASSWORD>' -- npx -y @sezzlee/mssql-mcp~/.cursor/mcp.json
{
"mcpServers": {
"sezzlee-sql": {
"command": "npx",
"args": [
"-y",
"@sezzlee/mssql-mcp"
],
"env": {
"SEZZLEE_MSSQL_SERVER": "<SEZZLEE_MSSQL_SERVER>",
"SEZZLEE_MSSQL_DATABASE": "<SEZZLEE_MSSQL_DATABASE>",
"SEZZLEE_MSSQL_USER": "<SEZZLEE_MSSQL_USER>",
"SEZZLEE_MSSQL_PASSWORD": "<SEZZLEE_MSSQL_PASSWORD>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"sezzlee-sql": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@sezzlee/mssql-mcp"
],
"env": {
"SEZZLEE_MSSQL_SERVER": "<SEZZLEE_MSSQL_SERVER>",
"SEZZLEE_MSSQL_DATABASE": "<SEZZLEE_MSSQL_DATABASE>",
"SEZZLEE_MSSQL_USER": "<SEZZLEE_MSSQL_USER>",
"SEZZLEE_MSSQL_PASSWORD": "<SEZZLEE_MSSQL_PASSWORD>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"sezzlee-sql": {
"command": "npx",
"args": [
"-y",
"@sezzlee/mssql-mcp"
],
"env": {
"SEZZLEE_MSSQL_SERVER": "<SEZZLEE_MSSQL_SERVER>",
"SEZZLEE_MSSQL_DATABASE": "<SEZZLEE_MSSQL_DATABASE>",
"SEZZLEE_MSSQL_USER": "<SEZZLEE_MSSQL_USER>",
"SEZZLEE_MSSQL_PASSWORD": "<SEZZLEE_MSSQL_PASSWORD>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"sezzlee-sql": {
"command": "npx",
"args": [
"-y",
"@sezzlee/mssql-mcp"
],
"env": {
"SEZZLEE_MSSQL_SERVER": "<SEZZLEE_MSSQL_SERVER>",
"SEZZLEE_MSSQL_DATABASE": "<SEZZLEE_MSSQL_DATABASE>",
"SEZZLEE_MSSQL_USER": "<SEZZLEE_MSSQL_USER>",
"SEZZLEE_MSSQL_PASSWORD": "<SEZZLEE_MSSQL_PASSWORD>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"sezzlee-sql": {
"command": "npx",
"args": [
"-y",
"@sezzlee/mssql-mcp"
],
"env": {
"SEZZLEE_MSSQL_SERVER": "<SEZZLEE_MSSQL_SERVER>",
"SEZZLEE_MSSQL_DATABASE": "<SEZZLEE_MSSQL_DATABASE>",
"SEZZLEE_MSSQL_USER": "<SEZZLEE_MSSQL_USER>",
"SEZZLEE_MSSQL_PASSWORD": "<SEZZLEE_MSSQL_PASSWORD>"
}
}
}
}Environment variables
SEZZLEE_MSSQL_SERVERSEZZLEE_MSSQL_DATABASESEZZLEE_MSSQL_USERSEZZLEE_MSSQL_PASSWORD
Replace the placeholders with your own credentials and keep them out of version control.