Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DB_USERYesDatabase user credentials
DB_SERVERYesSQL Server hostname
DB_ENCRYPTNoEnable encryptiontrue
DB_DATABASEYesDatabase name
DB_PASSWORDYesDatabase password credentials
DRAFT_SCHEMANoSchema for testing SPs before deploymentdbo_draft
MAX_ROWS_AFFECTEDNoMaximum rows that can be modified in one operation10000
REQUIRE_TRANSACTIONSNoRequire explicit transactions for modificationstrue
ENABLE_SP_MODIFICATIONSNoEnable stored procedure managementtrue
ENABLE_WRITE_OPERATIONSNoEnable INSERT/UPDATE/DELETEtrue
AUTO_BACKUP_BEFORE_DEPLOYNoAuto-backup SPs before deployingtrue
DB_TRUST_SERVER_CERTIFICATENoTrust server certificate for dev environmentsfalse

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

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/jpcanter/sql-server-mcp'

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