sql-ai-agent-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| HTTP_PORT | No | Port for npm run server:http, bound to 127.0.0.1. | 4104 |
| LOG_LEVEL | No | Log level for JSON logs on stderr. | info |
| DB_BACKEND | No | Database backend to use: sqlite or mssql. | sqlite |
| MSSQL_HOST | No | SQL Server host. | localhost |
| MSSQL_PORT | No | SQL Server port. | 1433 |
| MSSQL_USER | No | Least-privilege SQL Server login created by the seed script. | agent_reader |
| SQLITE_PATH | No | SQLite database file path, created by npm run seed. | data/sample.db |
| MSSQL_ENCRYPT | No | TLS encryption option for the SQL Server driver. | true |
| ROW_LIMIT_MAX | No | Hard maximum row limit. | 500 |
| AUDIT_LOG_PATH | No | Append-only audit log path. | logs/audit.jsonl |
| MSSQL_DATABASE | No | SQL Server database name. | SampleBusiness |
| MSSQL_PASSWORD | No | Password for the least-privilege SQL Server login. | |
| MAX_QUERY_CHARS | No | Longest accepted query length. | 8000 |
| QUERY_TIMEOUT_MS | No | Per-query timeout in milliseconds. | 5000 |
| RESULT_MAX_BYTES | No | Cap on the JSON size of returned rows. | 65536 |
| ROW_LIMIT_DEFAULT | No | Rows returned when no limit is given. | 100 |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Whether 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
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo recent community issues