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 |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_query | Executes a SQL query in SQL Server |
| get_table_schema | Gets the schema of a specific table |
| list_tables | Lists all the tables in the database |
| get_database_info | Gets general information from the database |
| list_procedures | Lists all stored procedures in the database |
| list_functions | Lists all functions (scalar and table-valued) in the database |
| get_procedure_schema | Gets the schema and parameters of a specific stored procedure |
| get_function_schema | Gets the schema and parameters of a specific function |
| execute_procedure | Executes a stored procedure with parameters |