Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| READONLY | No | Enable read-only mode | false |
| SERVER_NAME | Yes | SQL Server hostname | |
| SQL_PASSWORD | Yes | SQL password | |
| SQL_USERNAME | Yes | SQL username | |
| DATABASE_NAME | Yes | Database name | |
| CONNECTION_TIMEOUT | No | Connection timeout in seconds | 30 |
| TRUST_SERVER_CERTIFICATE | No | Trust self-signed certificates | 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 |
|---|---|
| insert_data | Inserts data into an MSSQL Database table. Supports both single record insertion and multiple record insertion using standard SQL INSERT with VALUES clause. FORMAT EXAMPLES: Single Record Insert: { "tableName": "Users", "data": { "name": "John Doe", "email": "john@example.com", "age": 30, "isActive": true, "createdDate": "2023-01-15" } } Multiple Records Insert: { "tableName": "Users", "data": [ { "name": "John Doe", "email": "john@example.com", "age": 30, "isActive": true, "createdDate": "2023-01-15" }, { "name": "Jane Smith", "email": "jane@example.com", "age": 25, "isActive": false, "createdDate": "2023-01-16" } ] } GENERATED SQL FORMAT:
|
| read_data | Executes a SELECT query on an MSSQL Database table. The query must start with SELECT and cannot contain any destructive SQL operations for security reasons. |
| describe_table | Describes the schema (columns and types) of a specified MSSQL Database table. |
| update_data | Updates data in an MSSQL Database table using a WHERE clause. The WHERE clause must be provided for security. |
| create_table | Creates a new table in the MSSQL Database with the specified columns. |
| create_index | Creates an index on a specified column or columns in an MSSQL Database table |
| drop_table | Drops a table from the MSSQL Database. |
| list_table | Lists tables in an MSSQL Database, or list tables in specific schemas |