Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SqlAugur__MaxRows | No | Maximum rows returned per query | 1000 |
| SqlAugur__AzureKeyVaultUri | No | Azure Key Vault URI (e.g., https://myvault.vault.azure.net/). When set, secrets from the vault are added as a configuration source. | |
| SqlAugur__EnableDarlingData | No | Enable DarlingData diagnostic tools (sp_PressureDetector, sp_QuickieStore, etc.) | false |
| SqlAugur__EnableWhoIsActive | No | Enable sp_WhoIsActive session monitoring | false |
| SqlAugur__MaxQueriesPerMinute | No | Maximum queries allowed per minute (token bucket rate limit) | 60 |
| SqlAugur__MaxConcurrentQueries | No | Maximum number of SQL queries that can execute concurrently | 5 |
| SqlAugur__CommandTimeoutSeconds | No | SQL command timeout for all queries and procedures | 30 |
| SqlAugur__EnableDynamicToolsets | No | Enable progressive tool discovery — DBA tools load on demand via 3 meta-tools instead of at startup. | false |
| SqlAugur__EnableFirstResponderKit | No | Enable First Responder Kit diagnostic tools (sp_Blitz, sp_BlitzFirst, etc.) | false |
| SqlAugur__Servers__production__ConnectionString | No | The connection string for a SQL Server instance named 'production'. Format: Server=myserver;Database=master;Integrated Security=True;TrustServerCertificate=False;Encrypt=True; |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| get_extended_properties | Read extended properties (descriptions, metadata) from tables and columns. Returns JSON with schema, table, column, property name, and value. |
| describe_table | Get comprehensive metadata about a single table including columns, data types, indexes, primary key, foreign keys, check constraints, and default constraints. |
| get_plantuml_diagram | Generate a PlantUML ER diagram saved to a file. Shows tables, columns, PKs, and FK relationships with smart cardinality. |
| list_databases | List all databases on a named SQL Server instance. Returns database names, IDs, states, and creation dates. Use list_servers first to discover available server names. |
| get_schema_overview | Markdown overview of database schema: tables, columns, types, PKs, FKs, unique/check constraints, defaults. Use get_plantuml_diagram for visual ER output or describe_table for single-table detail. |
| get_object_dependencies | Show what a database object references and what references it. Returns JSON with 'references' and 'referencedBy' arrays for dependency analysis. |
| get_mermaid_diagram | Generate a Mermaid ER diagram saved to a file. Shows tables, columns, PKs, and FK relationships with smart cardinality. |
| list_programmable_objects | List stored procedures, functions, views, and triggers in a database. Returns JSON with schema, name, type, and create/modify dates. |
| get_query_plan | Get the estimated or actual XML execution plan for a SELECT query. Estimated plans show the optimizer's plan without executing. Actual plans execute the query and include runtime statistics. Uses the same query validation as read_data (SELECT only). |
| read_data | Execute a read-only SQL SELECT query against a named SQL Server instance. Only SELECT and WITH (CTE) queries are allowed. Use list_servers first to discover available server names. |
| list_servers | List the available SQL Server instances that can be queried. Call this first to discover server names before using read_data. |
| get_object_definition | Get the T-SQL source code of a stored procedure, function, view, or trigger. Returns Markdown with the object type and definition. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |