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 | |
TDQS
Scored across 6 tools
Each tool targets a distinct action: SELECT retrieval, listing tables, schema inspection, statistics, inserts, and updates. There is no overlap between query, DML, and metadata operations, making selection straightforward.
Naming mixes execute_query/execute_insert/execute_update with list_tables and get_table_schema/get_table_stats. The pattern is not uniform (execute_ vs list_ vs get_table_), though it remains readable and predictable within subgroups.
Six tools is a well-scoped set for a SQL server, covering query, data modification, and metadata needs without excessive surface area.
The toolset covers SELECT, INSERT, UPDATE, and metadata, but lacks a DELETE operation, DDL support (CREATE/ALTER/DROP), and transaction control. These are significant gaps that will hinder common database workflows.