sqlserver
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SQL_SERVER_HOST | No | The SQL Server host | localhost |
| SQL_SERVER_PORT | No | The SQL Server port | 1433 |
| SQL_SERVER_USER | No | The database user | sa |
| SQL_SERVER_ENCRYPT | No | Whether to encrypt the connection | false |
| SQL_SERVER_DATABASE | No | The database name | SampleDB |
| SQL_SERVER_PASSWORD | No | The database password | YourStrong@Passw0rd |
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
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryA | Execute a SQL query and return results. Use for SELECT queries to retrieve data. |
| get_table_schemaA | Get the schema/structure of a table including column names, types, and constraints |
| list_tablesA | List all tables in the database |
| get_table_statsB | Get statistics about a table including row count and column information |
| execute_insertA | Insert data into a table. Returns the inserted row ID if available. |
| execute_updateB | Update data in a table. Returns the number of affected rows. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |