Skip to main content
Glama
sql-ai-agent-mcp

sql-ai-agent-mcp

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
HTTP_PORTNoPort for npm run server:http, bound to 127.0.0.1.4104
LOG_LEVELNoLog level for JSON logs on stderr.info
DB_BACKENDNoDatabase backend to use: sqlite or mssql.sqlite
MSSQL_HOSTNoSQL Server host.localhost
MSSQL_PORTNoSQL Server port.1433
MSSQL_USERNoLeast-privilege SQL Server login created by the seed script.agent_reader
SQLITE_PATHNoSQLite database file path, created by npm run seed.data/sample.db
MSSQL_ENCRYPTNoTLS encryption option for the SQL Server driver.true
ROW_LIMIT_MAXNoHard maximum row limit.500
AUDIT_LOG_PATHNoAppend-only audit log path.logs/audit.jsonl
MSSQL_DATABASENoSQL Server database name.SampleBusiness
MSSQL_PASSWORDNoPassword for the least-privilege SQL Server login.
MAX_QUERY_CHARSNoLongest accepted query length.8000
QUERY_TIMEOUT_MSNoPer-query timeout in milliseconds.5000
RESULT_MAX_BYTESNoCap on the JSON size of returned rows.65536
ROW_LIMIT_DEFAULTNoRows returned when no limit is given.100
MSSQL_TRUST_SERVER_CERTIFICATENoWhether the SQL Server driver trusts the server certificate.true

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Server capabilities have not been inspected yet.

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