Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | Yes | The host address of the MSSQL database server | localhost |
| DB_PORT | Yes | The port number of the MSSQL database server | 1433 |
| DB_DATABASE | Yes | The name of the MSSQL database to connect to | |
| DB_PASSWORD | Yes | The password for connecting to the MSSQL database | |
| DB_USERNAME | Yes | The username for connecting to the MSSQL database |
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 |
|---|---|
| get-tables | Get a list of all tables in the database |
| get-table | Get a specific table by name |
| get-stored-procedures | Get a list of all stored procedures in the database |
| get-stored-procedure | Get a specific stored procedure by name |
| query | Query the database with a SQL statement |
| start-transaction | Start a new transaction |
| commit-transaction | Commit a transaction |
| rollback-transaction | Rollback a transaction |