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 |