Skip to main content
Glama
dperussina

Microsoft SQL Server MCP Server (MSSQL)

MS SQL MCP Server 1.1

Eine benutzerfreundliche Brücke, mit der KI-Assistenten wie Claude Microsoft SQL Server-Datenbanken direkt abfragen und erkunden können. Keine Programmierkenntnisse erforderlich!

Was macht dieses Tool?

Mit diesem Tool können KI-Assistenten:

  1. Ermitteln von Tabellen in Ihrer SQL Server-Datenbank

  2. Tabellenstrukturen anzeigen (Spalten, Datentypen usw.)

  3. Führen Sie schreibgeschützte SQL-Abfragen sicher aus

  4. Generieren Sie SQL-Abfragen aus Anfragen in natürlicher Sprache

Related MCP server: MS SQL MCP Server

🌟 Warum Sie dieses Tool benötigen

Überbrücken Sie die Lücke zwischen Ihren Daten und der KI

  • Keine Codierung erforderlich : Geben Sie Claude und anderen KI-Assistenten direkten Zugriff auf Ihre SQL Server-Datenbanken, ohne komplexen Integrationscode schreiben zu müssen

  • Behalten Sie die Kontrolle : Alle Abfragen sind standardmäßig schreibgeschützt, sodass Ihre Daten sicher bleiben

  • Privat und sicher : Ihre Datenbankanmeldeinformationen bleiben lokal und werden niemals an externe Dienste gesendet

Praktische Vorteile

  • Sparen Sie Stunden manueller Arbeit : Kein Kopieren und Einfügen von Daten oder Abfrageergebnissen mehr zum Teilen mit der KI

  • Tiefergehende Analyse : KI kann durch Ihr gesamtes Datenbankschema navigieren und Einblicke in mehrere Tabellen liefern

  • Natural Language Interface : Stellen Sie Fragen zu Ihren Daten in einfachem Englisch

  • Beenden Sie das Kontextlimit-Problem : Greifen Sie auf große Datensätze zu, die normale KI-Kontextfenster überschreiten würden

Perfekt für

  • Datenanalysten , die KI-Hilfe bei der Interpretation von SQL-Daten wünschen, ohne Anmeldeinformationen weitergeben zu müssen

  • Entwickler , die nach einer schnellen Möglichkeit suchen, die Datenbankstruktur durch natürliche Konversation zu erkunden

  • Business-Analysten , die Einblicke benötigen, ohne SQL-Kenntnisse zu haben

  • Datenbankadministratoren , die kontrollierten Zugriff auf KI-Tools bereitstellen möchten

🚀 Kurzanleitung

Schritt 1: Voraussetzungen installieren

  • Installieren Sie Node.js (Version 14 oder höher)

  • Zugriff auf eine Microsoft SQL Server-Datenbank (vor Ort oder Azure)

Schritt 2: Klonen und Einrichten

# Clone this repository
git clone https://github.com/dperussina/mssql-mcp-server.git

# Navigate to the project directory
cd mssql-mcp-server

# Install dependencies
npm install

# Copy the example environment file
cp .env.example .env

Schritt 3: Konfigurieren Sie Ihre Datenbankverbindung

Bearbeiten Sie die .env Datei mit Ihren Datenbankanmeldeinformationen:

DB_USER=your_username
DB_PASSWORD=your_password
DB_SERVER=your_server_name_or_ip
DB_DATABASE=your_database_name
PORT=3333
HOST=0.0.0.0                    # Host for the server to listen on, e.g., 'localhost' or '0.0.0.0'
TRANSPORT=stdio
SERVER_URL=http://localhost:3333
DEBUG=false                     # Set to 'true' for detailed logging (helpful for troubleshooting)
QUERY_RESULTS_PATH=/path/to/query_results  # Directory where query results will be saved as JSON files

Schritt 4: Starten Sie den Server

# Start with default stdio transport
npm start

# OR start with HTTP/SSE transport for network access
npm run start:sse

Schritt 5: Probieren Sie es aus!

# Run the interactive client
npm run client

📊 Beispiel-Anwendungsfälle

  1. Erkunden Sie Ihre Datenbankstruktur, ohne SQL zu schreiben

    mcp_SQL_mcp_discover_database()
  2. Erhalten Sie detaillierte Informationen zu einer bestimmten Tabelle

    mcp_SQL_mcp_table_details({ tableName: "Customers" })
  3. Führen Sie eine sichere Abfrage aus

    mcp_SQL_mcp_execute_query({ sql: "SELECT TOP 10 * FROM Customers", returnResults: true })
  4. Tabellen nach Namensmuster suchen

    mcp_SQL_mcp_discover_tables({ namePattern: "%user%" })
  5. Verwenden der Paginierung zum Navigieren in großen Ergebnismengen

    // First page
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT * FROM Users ORDER BY Username OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY", 
      returnResults: true 
    })
    
    // Next page
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT * FROM Users ORDER BY Username OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY", 
      returnResults: true 
    })
  6. Cursorbasierte Paginierung für optimale Leistung

    // First page
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT TOP 10 * FROM Users ORDER BY Username", 
      returnResults: true 
    })
    
    // Next page using the last value as cursor
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT TOP 10 * FROM Users WHERE Username > 'last_username' ORDER BY Username", 
      returnResults: true 
    })
  7. Stellen Sie Fragen in natürlicher Sprache

    "Show me the top 5 customers with the most orders in the last month"

💡 Anwendungen in der realen Welt

Für Business Intelligence

  • Analyse der Verkaufsleistung : „Zeigen Sie mir die monatlichen Verkaufstrends des vergangenen Jahres und identifizieren Sie unsere leistungsstärksten Produkte nach Region.“

  • Kundensegmentierung : „Analysieren Sie unseren Kundenstamm nach Kaufhäufigkeit, durchschnittlichem Bestellwert und geografischem Standort.“

  • Finanzberichterstattung : „Erstellen Sie einen vierteljährlichen Gewinn- und Verlustbericht, in dem dieses Jahr mit dem letzten Jahr verglichen wird.“

Für die Datenbankverwaltung

  • Schemaoptimierung : „Helfen Sie mir, Tabellen mit fehlenden Indizes zu identifizieren, indem Sie die Abfrageleistungsdaten untersuchen.“

  • Datenqualitätsprüfung : „Finden Sie alle Kundendatensätze mit unvollständigen Informationen oder ungültigen Werten.“

  • Nutzungsanalyse : „Zeigen Sie mir, auf welche Tabellen am häufigsten zugegriffen wird und welche Abfragen am ressourcenintensivsten sind.“

Für die Entwicklung

  • API-Erkundung : „Ich erstelle eine API – helfen Sie mir, das Datenbankschema zu analysieren, um geeignete Endpunkte zu entwerfen.“

  • Abfrageoptimierung : „Überprüfen Sie diese komplexe Abfrage und schlagen Sie Leistungsverbesserungen vor.“

  • Datenbankdokumentation : „Erstellen Sie eine umfassende Dokumentation unserer Datenbankstruktur mit Erklärungen der Beziehungen.“

🖥️ Interaktive Clientfunktionen

Der mitgelieferte Client bietet eine einfache menügesteuerte Benutzeroberfläche:

  1. Verfügbare Ressourcen auflisten – Sehen Sie, welche Informationen verfügbar sind

  2. Liste der verfügbaren Tools – Sehen Sie, welche Aktionen Sie ausführen können

  3. SQL-Abfrage ausführen - Führen Sie eine schreibgeschützte SQL-Abfrage aus

  4. Tabellendetails abrufen – Struktur jeder beliebigen Tabelle anzeigen

  5. Datenbankschema lesen - Alle Tabellen und ihre Beziehungen anzeigen

  6. SQL-Abfrage generieren - Natürliche Sprache in SQL konvertieren

🧠 Leitfaden zur effektiven Eingabeaufforderung und Verwendung von Tools

Wenn Sie mit Claude oder anderen KI-Assistenten über diesen MCP-Server arbeiten, beeinflusst die Formulierung Ihrer Anfragen maßgeblich die Ergebnisse. So unterstützen Sie die KI bei der effektiven Nutzung der Datenbanktools:

Grundlegendes Tool-Aufrufformat

Wenn Sie eine KI auffordern, dieses Tool zu verwenden, folgen Sie dieser Struktur:

Can you use the SQL MCP tools to [your goal]?

For example:
- Check what tables exist in my database
- Query the Customers table and show me the first 10 records
- Find all orders from the past month

Wichtige Befehle und Syntax

Hier sind die wichtigsten Tools und ihre korrekte Syntax:

// Discover the database structure
mcp_SQL_mcp_discover_database()

// Get detailed information about a specific table
mcp_SQL_mcp_table_details({ tableName: "YourTableName" })

// Execute a query and return results
mcp_SQL_mcp_execute_query({ 
  sql: "SELECT * FROM YourTable WHERE Condition", 
  returnResults: true 
})

// Find tables by name pattern
mcp_SQL_mcp_discover_tables({ namePattern: "%pattern%" })

// Access saved query results (for large result sets)
mcp_SQL_mcp_get_query_results({ uuid: "provided-uuid-here" })

Wann welches Werkzeug verwendet werden soll:

  • Datenbankerkennung : Beginnen Sie damit, wenn die KI mit Ihrer Datenbankstruktur nicht vertraut ist.

  • Tabellendetails : Verwenden Sie diese Option, wenn Sie sich vor dem Schreiben von Abfragen auf eine bestimmte Tabelle konzentrieren.

  • Abfrageausführung : Wenn Sie tatsächliche Daten abrufen oder analysieren müssen.

  • Tabellenerkennung nach Muster : Bei der Suche nach Tabellen, die sich auf eine bestimmte Domäne beziehen.

Effektive Aufforderungsmuster

Schritt-für-Schritt-Workflows

Führen Sie die KI bei komplexen Aufgaben durch eine Reihe von Schritten:

I'd like to analyze our sales data. Please:
1. First use mcp_SQL_mcp_discover_tables to find tables related to sales
2. Use mcp_SQL_mcp_table_details to examine the structure of relevant tables
3. Create a query with mcp_SQL_mcp_execute_query that shows monthly sales by product category

Erst strukturieren, dann abfragen

First, discover what tables exist in my database. Then, look at the structure
of the Customers table. Finally, show me the top 10 customers by total purchase amount.

Bitten Sie um Erklärungen

Query the top 5 underperforming products based on sales vs. forecasts,
and explain your approach to writing this query.

Hinweise zum SQL Server-Dialekt

Erinnern Sie die KI an die spezifische Syntax von SQL Server:

Please use SQL Server syntax for pagination:
- For offset/fetch: "OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY"
- For cursor-based: "WHERE ID > last_id ORDER BY ID"

Korrigieren der Werkzeugnutzung

Wenn die KI eine falsche Syntax verwendet, können Sie ihr folgendermaßen helfen:

That's not quite right. Please use this format for the tool call:
mcp_SQL_mcp_execute_query({ 
  sql: "SELECT * FROM Customers WHERE Region = 'West'",
  returnResults: true
})

Fehlerbehebung durch Eingabeaufforderungen

Wenn die KI mit einer Datenbankaufgabe zu kämpfen hat, versuchen Sie diese Ansätze:

  1. Seien Sie bei Tabellen genauer: „Bevor Sie diese Abfrage schreiben, prüfen Sie, ob die Tabelle CustomerOrders vorhanden ist und welche Spalten sie hat.“

  2. Teilen Sie komplexe Aufgaben in Schritte auf: „Gehen wir Schritt für Schritt vor. Sehen Sie sich zunächst die Struktur der Produkttabelle an. Überprüfen Sie dann die Tabelle „Bestellungen“ …“

  3. Fordern Sie Zwischenergebnisse an: „Führen Sie zunächst eine einfache Abfrage für diese Tabelle aus, damit wir das Datenformat überprüfen können, bevor wir eine komplexere Analyse versuchen.“

  4. Abfrageerklärungen anfordern: „Erklären Sie nach dem Schreiben dieser Abfrage, was jeder Teil bewirkt, damit ich überprüfen kann, ob er das tut, was ich brauche.“

🔎 Erweiterte Abfragefunktionen

Tischentdeckung und -erkundung

Der MCP-Server bietet leistungsstarke Tools zum Erkunden Ihrer Datenbankstruktur:

  • Musterbasierte Tabellenerkennung : Finden Sie Tabellen, die bestimmten Mustern entsprechen

    mcp_SQL_mcp_discover_tables({ namePattern: "%order%" })
  • Schemaübersicht : Erhalten Sie eine Übersicht über die Tabellen nach Schema

    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT TABLE_SCHEMA, COUNT(*) AS TableCount FROM INFORMATION_SCHEMA.TABLES GROUP BY TABLE_SCHEMA" 
    })
  • Spaltenerkundung : Untersuchen Sie Spaltenmetadaten für jede Tabelle

    mcp_SQL_mcp_table_details({ tableName: "dbo.Users" })

Paginierungstechniken

Der Server unterstützt mehrere Paginierungsmethoden für die Verarbeitung großer Datensätze:

  1. Offset/Fetch-Paginierung : Standard-SQL-Paginierung mit OFFSET und FETCH

    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT * FROM Users ORDER BY Username OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY" 
    })
  2. Cursorbasierte Paginierung : Effizienter für große Datensätze

    // Get first page
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT TOP 10 * FROM Users ORDER BY Username" 
    })
    
    // Get next page using last value as cursor
    mcp_SQL_mcp_execute_query({ 
      sql: "SELECT TOP 10 * FROM Users WHERE Username > 'last_username' ORDER BY Username" 
    })
  3. Mit Daten zählen : Gesamtanzahl zusammen mit paginierten Daten abrufen

    mcp_SQL_mcp_execute_query({ 
      sql: "WITH TotalCount AS (SELECT COUNT(*) AS Total FROM Users) SELECT TOP 10 u.*, t.Total FROM Users u CROSS JOIN TotalCount t ORDER BY Username" 
    })

Komplexe Verknüpfungen und Beziehungen

Untersuchen Sie Beziehungen zwischen Tabellen mit Verknüpfungsvorgängen:

mcp_SQL_mcp_execute_query({ 
  sql: "SELECT u.Username, u.Email, r.RoleName FROM Users u JOIN UserRoles ur ON u.Username = ur.Username JOIN Roles r ON ur.RoleId = r.RoleId ORDER BY u.Username"
})

Analytische Abfragen

Führen Sie Aggregationen und analytische Abfragen aus, um Erkenntnisse zu gewinnen:

mcp_SQL_mcp_execute_query({ 
  sql: "SELECT UserType, COUNT(*) AS UserCount, SUM(CASE WHEN IsActive = 1 THEN 1 ELSE 0 END) AS ActiveUsers FROM Users GROUP BY UserType"
})

Verwenden von SQL Server-Funktionen

Der MCP-Server unterstützt SQL Server-spezifische Funktionen:

  • Gemeinsame Tabellenausdrücke (CTEs)

  • Fensterfunktionen

  • JSON-Operationen

  • Hierarchische Abfragen

  • Volltextsuche (sofern in Ihrer Datenbank konfiguriert)

🔗 Integrationsoptionen

Claude Desktop Integration

Verbinden Sie dieses Tool in wenigen einfachen Schritten direkt mit Claude Desktop:

  1. Installieren Sie Claude Desktop von anthropic.com

  2. Bearbeiten Sie Claudes Konfigurationsdatei:

    • Speicherort: ~/Library/Application Support/Claude/claude_desktop_config.json

    • Fügen Sie diese Konfiguration hinzu:

{
    "mcpServers": {
        "mssql": {
            "command": "node",
            "args": [
                "/FULL/PATH/TO/mssql-mcp-server/server.mjs"
            ]
        }
    }
}
  1. Ersetzen Sie /FULL/PATH/TO/ durch den tatsächlichen Pfad, in den Sie dieses Repository geklont haben

  2. Starten Sie Claude Desktop neu

  3. Suchen Sie in Claude Desktop nach dem Tool-Symbol – Sie können jetzt Datenbankbefehle direkt verwenden!

Herstellen einer Verbindung mit Cursor IDE

Cursor ist ein KI-gestützter Code-Editor, der dieses Tool für erweiterte Datenbankinteraktionen nutzen kann. So richten Sie ihn ein:

Setup im Cursor

  1. Öffnen Sie die Cursor-IDE (laden Sie sie von cursor.sh herunter, wenn Sie sie nicht haben)

  2. Starten Sie den MS SQL MCP-Server mithilfe des HTTP/SSE-Transports:

    npm run start:sse
  3. Erstellen Sie einen neuen Arbeitsbereich oder öffnen Sie ein vorhandenes Projekt in Cursor

  4. Cursoreinstellungen eingeben

  5. Klicken Sie auf MCP

  6. Neuen MCP-Server hinzufügen

  7. Benennen Sie Ihren MCP-Server und wählen Sie den Typ: sse

  8. Geben Sie die Server-URL wie folgt ein: localhost:3333/sse (oder den Port, auf dem es ausgeführt wird).

Verwenden von Datenbankbefehlen im Cursor

Sobald die Verbindung hergestellt ist, können Sie MCP-Befehle direkt im KI-Chat von Cursor verwenden:

  1. Bitten Sie Claude in Cursor, Ihre Datenbank zu erkunden:

    Can you show me the tables in my database?
  2. Führen Sie bestimmte Abfragen aus:

    Query the top 10 records from the Customers table
  3. Generieren und Ausführen komplexer Abfragen:

    Find all orders from the last month with a value over $1000

Fehlerbehebung bei der Cursorverbindung

  • Stellen Sie sicher, dass der MS SQL MCP-Server mit dem HTTP/SSE-Transport ausgeführt wird

  • Überprüfen Sie, ob der Port korrekt ist und mit dem in Ihrer .env-Datei übereinstimmt

  • Stellen Sie sicher, dass Ihre Firewall die Verbindung nicht blockiert

  • Wenn Sie eine andere IP/einen anderen Hostnamen verwenden, aktualisieren Sie die SERVER_URL in Ihrer .env-Datei

🔄 Transportmethoden erklärt

Option 1: stdio-Transport (Standard)

Am besten geeignet für: Direkte Verwendung mit Claude Desktop oder dem mitgelieferten Client

npm start

Option 2: HTTP/SSE-Transport

Am besten geeignet für: Netzwerkzugriff oder Verwendung mit Webanwendungen

npm run start:sse

🛡️ Sicherheitsfunktionen

  • Standardmäßig schreibgeschützt : Kein Risiko der Datenänderung

  • Private Anmeldeinformationen : Datenbankverbindungsdetails bleiben in Ihrer .env Datei

  • Schutz vor SQL-Injection : Integrierte Validierung für SQL-Abfragen

🔎 Fehlerbehebung für neue Benutzer

„Verbindung zur Datenbank kann nicht hergestellt werden“

  • Überprüfen Sie Ihre .env Datei auf korrekte Datenbankanmeldeinformationen

  • Stellen Sie sicher, dass Ihr SQL Server ausgeführt wird und Verbindungen akzeptiert

  • Überprüfen Sie für Azure SQL, ob Ihre IP in den Firewall-Einstellungen zulässig ist

Fehler „Modul nicht gefunden“

  • Führen Sie npm install erneut aus, um sicherzustellen, dass alle Abhängigkeiten installiert sind

  • Stellen Sie sicher, dass Sie Node.js Version 14 oder höher verwenden

„Transportfehler“ oder „Verbindung abgelehnt“

  • Überprüfen Sie für den HTTP/SSE-Transport, ob der PORT in Ihrer .env verfügbar ist

  • Stellen Sie sicher, dass keine Firewall die Verbindung blockiert

Claude Desktop kann keine Verbindung herstellen

  • Überprüfen Sie den Pfad in Ihrer claude_desktop_config.json

  • Stellen Sie sicher, dass Sie absolute Pfade verwenden, keine relativen

  • Starten Sie Claude Desktop nach den Änderungen vollständig neu

📚 SQL Server-Grundlagen verstehen

Wenn Sie mit SQL Server noch nicht vertraut sind, sind hier einige wichtige Konzepte:

  • Tabellen : Speichern Sie Ihre Daten in Zeilen und Spalten

  • Schemata : Logische Gruppierungen von Tabellen (wie Ordner)

  • Abfragen : Befehle zum Abrufen oder Analysieren von Daten

  • Ansichten : Vordefinierte Abfragen für einfachen Zugriff gespeichert

Mit diesem Tool können Sie all dies erkunden, ohne ein SQL-Experte sein zu müssen!

🏗️ Architektur und Kernmodule

Der MS SQL MCP-Server basiert auf einer modularen Architektur, die Aspekte der Wartbarkeit und Erweiterbarkeit voneinander trennt:

Kernmodule

database.mjs – Datenbankkonnektivität

  • Verwaltet das SQL Server-Verbindungspooling

  • Bietet Abfrageausführung mit Wiederholungslogik und Fehlerbehandlung

  • Verwaltet Datenbankverbindungen, Transaktionen und Konfiguration

  • Enthält Dienstprogramme zum Bereinigen von SQL- und Formatierungsfehlern

tools.mjs - Werkzeugregistrierung

  • Registriert alle Datenbanktools beim MCP-Server

  • Implementiert Toolvalidierung und Parameterprüfung

  • Bietet Kernfunktionen für SQL-Abfragen, Tabellenexploration und Datenbankerkennung

  • Ordnet Toolaufrufe Datenbankvorgängen zu

resources.mjs – Datenbankressourcen

  • Stellt Datenbankmetadaten über Ressourcenendpunkte bereit

  • Bietet Schemainformationen, Tabellenlisten und Verfahrensdokumentation

  • Formatiert Datenbankstrukturinformationen für die KI-Nutzung

  • Enthält Discovery-Dienstprogramme zur Datenbank-Exploration

pagination.mjs - Ergebnisnavigation

  • Implementiert eine Cursor-basierte Paginierung für große Ergebnismengen

  • Bietet Dienstprogramme zum Generieren von Cursorn für die nächste/vorherige Seite

  • Transformiert SQL-Abfragen zur Unterstützung der Paginierung

  • Verarbeitet die OFFSET/FETCH-Paginierungssyntax von SQL Server

errors.mjs - Fehlerbehandlung

  • Definiert benutzerdefinierte Fehlertypen für verschiedene Fehlerszenarien

  • Implementiert die JSON-RPC-Fehlerformatierung

  • Bietet menschenlesbare Fehlermeldungen

  • Enthält Middleware für die globale Fehlerbehandlung

logger.mjs - Protokollierungssystem

  • Konfiguriert Winston-Protokollierung mit mehreren Transporten

  • Bietet kontextbezogene Anforderungsprotokollierung

  • Verarbeitet die Protokollrotation und -formatierung

  • Erfasst nicht erfasste Ausnahmen und nicht behandelte Ablehnungen

Wie diese Module zusammenarbeiten

  1. Wenn ein Tool-Aufruf empfangen wird, leitet der MCP-Server ihn an den entsprechenden Handler in tools.mjs weiter

  2. Der Toolhandler validiert Parameter und erstellt eine Datenbankabfrage

  3. Die Abfrage wird über Funktionen in database.mjs ausgeführt, mit möglicher Paginierung aus pagination.mjs

  4. Die Ergebnisse werden formatiert und an den Kunden zurückgegeben

  5. Eventuelle Fehler werden abgefangen und durch errors.mjs verarbeitet

  6. Alle Vorgänge werden über logger.mjs protokolliert

Diese Architektur gewährleistet:

  • Klare Trennung der Belange

  • Konsistente Fehlerbehandlung

  • Umfassende Protokollierung

  • Effizientes Datenbankverbindungsmanagement

  • Skalierbare Abfrageausführung

⚙️ Erläuterung der Umgebungskonfiguration

Die .env -Datei steuert, wie der MS SQL MCP-Server eine Verbindung zu Ihrer Datenbank herstellt und arbeitet. Hier ist eine detaillierte Erklärung der einzelnen Einstellungen:

# Database Connection Settings
DB_USER=your_username           # SQL Server username
DB_PASSWORD=your_password       # SQL Server password
DB_SERVER=your_server_name_or_ip
DB_DATABASE=your_database_name

# Server Configuration
PORT=3333                       # Port for the HTTP/SSE server to listen on
HOST=0.0.0.0                    # Host for the server to listen on, e.g., 'localhost' or '0.0.0.0'
TRANSPORT=stdio                 # Connection method: 'stdio' (for Claude Desktop) or 'sse' (for network connections)
SERVER_URL=http://localhost:3333 # Base URL when using SSE transport. If HOST is '0.0.0.0', external clients use http://<your-machine-ip>:${PORT}

# Advanced Settings
DEBUG=false                     # Set to 'true' for detailed logging (helpful for troubleshooting)
QUERY_RESULTS_PATH=/path/to/query_results  # Directory where query results will be saved as JSON files

Erläuterung der Verbindungstypen

stdio Transport

  • Verwenden Sie diese Option, wenn Sie eine direkte Verbindung mit Claude Desktop herstellen

  • Die Kommunikation erfolgt über Standard-Ein-/Ausgabeströme

  • Legen Sie TRANSPORT=stdio in Ihrer .env-Datei fest

  • Ausführen mit npm start

HTTP/SSE-Transport

  • Verwenden Sie diese Option bei einer Verbindung über ein Netzwerk (z. B. mit Cursor IDE).

  • Verwendet Server-Sent Events (SSE) für Echtzeitkommunikation

  • Setzen Sie TRANSPORT=sse in Ihrer .env-Datei

  • Konfigurieren Sie SERVER_URL so, dass es mit Ihrer Serveradresse übereinstimmt

  • Ausführen mit npm run start:sse

Beispiele für SQL Server-Verbindungen

Lokaler SQL Server

DB_USER=sa
DB_PASSWORD=YourStrongPassword
DB_SERVER=localhost
DB_DATABASE=AdventureWorks

Azure SQL-Datenbank

DB_USER=azure_admin@myserver
DB_PASSWORD=YourStrongPassword
DB_SERVER=myserver.database.windows.net
DB_DATABASE=AdventureWorks

Abfrageergebnisspeicher

Abfrageergebnisse werden als JSON-Dateien im durch QUERY_RESULTS_PATH angegebenen Verzeichnis gespeichert. Dadurch wird verhindert, dass große Ergebnismengen die Konversation überlasten. Sie haben folgende Möglichkeiten:

  • Lassen Sie dieses Feld leer, um das Standardverzeichnis query-results im Projekt zu verwenden.

  • Legen Sie einen benutzerdefinierten Pfad wie /Users/username/Documents/query-results fest

  • Greifen Sie mithilfe der in der Toolantwort angegebenen UUID auf gespeicherte Ergebnisse zu

📝 Lizenz

ISC

Available Tools

33 tools
analyze_check_constraintsAnalyze Check ConstraintsB

Extract and analyze business rules from check constraints

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions 'extract and analyze,' which implies a read-only operation, but does not specify if it requires specific permissions, how it handles errors, or what the output format looks like (e.g., structured data or summary). For a tool with no annotations, this leaves significant gaps in understanding its behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'Extract and analyze business rules from check constraints.' It is front-loaded with the core purpose, has no unnecessary words, and earns its place by clearly stating what the tool does without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (analysis of constraints), lack of annotations, and no output schema, the description is somewhat incomplete. It covers the basic purpose but does not address behavioral aspects like error handling, output format, or performance considerations. However, it is adequate as a starting point, though more detail would improve completeness for an analysis tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, meaning all parameters are documented in the schema with clear descriptions (e.g., 'SQL Server connection string'). The description does not add any additional meaning or context beyond the schema, such as explaining interactions between parameters or default behaviors. Baseline score of 3 is appropriate as the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Extract and analyze business rules from check constraints.' It specifies both the action ('extract and analyze') and the resource ('business rules from check constraints'), making it easy to understand. However, it does not explicitly differentiate from sibling tools like 'list_constraints' or 'list_default_constraints,' which might also involve constraints, so it misses full sibling distinction.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It does not mention any context, prerequisites, or exclusions, such as when to prefer 'list_constraints' for a simple listing or 'analyze_database_size' for different analysis types. Without such guidance, users must infer usage from the name alone.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

analyze_database_sizeAnalyze Database SizeC

Get comprehensive database size information including data and log file sizes

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. While it states what information is returned ('database size information including data and log file sizes'), it doesn't disclose important behavioral aspects like whether this is a read-only operation, potential performance impact on the database, authentication requirements, rate limits, or what format the information is returned in.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that clearly states the tool's purpose without any wasted words. It's appropriately sized for a straightforward analysis tool and front-loads the essential information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a database analysis tool with no annotations and no output schema, the description is insufficient. It doesn't explain what format the size information is returned in, whether the operation has side effects, authentication requirements, or how it differs from other database inspection tools. Given the complexity of database operations and lack of structured metadata, more context is needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents both parameters thoroughly. The description adds no additional parameter information beyond what's in the schema. This meets the baseline expectation when schema coverage is complete.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Get') and resource ('database size information') with specific scope ('including data and log file sizes'). It distinguishes itself from many sibling tools that analyze other database aspects like constraints, indexes, or procedures, though it doesn't explicitly differentiate from tools like 'list_databases' which might provide different size information.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools available (e.g., 'list_databases', 'analyze_table_stats', 'describe_table'), there's no indication of when this specific size analysis is preferred over other database inspection tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

analyze_data_distributionAnalyze Data DistributionC

Get data distribution patterns for columns to understand data quality and patterns

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
tableNameYesName of the table to analyze
schemaNoSchema name (default: dbo)
columnNameNoSpecific column to analyze (analyzes all if not provided)
sampleSizeNoSample size for analysis (default: 1000)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It mentions analyzing 'data distribution patterns' but fails to describe key behaviors: what the output looks like (e.g., statistical summaries, visualizations), whether it performs read-only operations (implied but not stated), performance implications, or any limitations like data size constraints. This is inadequate for a tool with 6 parameters and no output schema.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It's front-loaded with the core action ('Get data distribution patterns'), making it easy to parse. However, it could be slightly more structured by explicitly mentioning the target (e.g., SQL databases) to enhance clarity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (6 parameters, no annotations, no output schema), the description is incomplete. It lacks details on behavioral traits, output format, and usage context. While the schema covers parameters, the description fails to compensate for missing annotations and output schema, leaving gaps in understanding how the tool behaves and what results to expect.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, so the input schema fully documents all 6 parameters with descriptions. The tool description adds no additional parameter semantics beyond what's in the schema (e.g., it doesn't explain how 'sampleSize' affects analysis quality). According to scoring rules, this results in a baseline score of 3, as the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Get data distribution patterns for columns to understand data quality and patterns.' It specifies the verb ('Get') and resource ('data distribution patterns for columns'), making the action clear. However, it doesn't explicitly differentiate from sibling tools like 'analyze_table_stats' or 'sample_data', which might have overlapping analysis functions.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools like 'analyze_table_stats' or 'sample_data' that might serve similar purposes, nor does it specify prerequisites or contexts for use. This leaves the agent without clear direction on tool selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

analyze_index_usageAnalyze Index UsageC

Show detailed index usage statistics to identify unused or underutilized indexes

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name
showUnusedOnlyNoShow only unused indexes (default: false)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden for behavioral disclosure. While it mentions the tool shows 'detailed index usage statistics', it doesn't describe what format the output takes, whether it's read-only, whether it requires specific permissions, or any performance implications. For a tool with 5 parameters and no annotations, this leaves significant behavioral gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that clearly states the tool's purpose. It's appropriately sized for a tool with good schema documentation, with zero wasted words or redundant information. The structure is front-loaded with the core functionality.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given 5 parameters, no annotations, and no output schema, the description is insufficiently complete. It doesn't address what the output looks like, how results are formatted, whether there are performance considerations for large databases, or what permissions are required. For a database analysis tool with multiple configuration options, more contextual information would be helpful.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already fully documents all 5 parameters. The description adds no additional parameter information beyond what's in the schema - it doesn't explain relationships between parameters (e.g., connectionString vs connectionName), parameter dependencies, or usage patterns. Baseline 3 is appropriate when schema does all the work.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Show detailed index usage statistics to identify unused or underutilized indexes'. It specifies the verb 'show' and resource 'index usage statistics', with a clear goal of identifying unused/underutilized indexes. However, it doesn't explicitly differentiate from sibling tools like 'list_indexes' or 'find_missing_indexes', which prevents a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools focused on database analysis (e.g., 'analyze_table_stats', 'find_missing_indexes'), there's no indication of when this specific index analysis tool is appropriate versus other analysis or listing tools. The description only states what it does, not when to choose it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

analyze_null_patternsAnalyze NULL PatternsC

Find columns with high null percentages and analyze null patterns

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
minNullPercentageNoMinimum null percentage to include (default: 10)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions 'find columns with high null percentages' and 'analyze null patterns,' but doesn't specify what constitutes 'high' (though the schema covers minNullPercentage), how results are returned, whether it's read-only, performance implications, or authentication needs. For a tool with 4 parameters and no annotations, this is insufficient.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'Find columns with high null percentages and analyze null patterns.' It's front-loaded with the core purpose and wastes no words. However, it could be slightly more structured by separating key actions, but overall it's concise.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (4 parameters, no annotations, no output schema), the description is incomplete. It doesn't cover behavioral aspects like read-only nature, output format, or error handling. For a database analysis tool with siblings, more context is needed to help the agent understand when and how to use it effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 4 parameters. The description adds no parameter-specific semantics beyond implying null percentage analysis. It doesn't explain interactions between parameters (e.g., connectionString vs. connectionName) or provide context beyond what the schema already states. Baseline 3 is appropriate when schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Find columns with high null percentages and analyze null patterns.' It specifies the verb ('find' and 'analyze') and resource ('columns'), but doesn't explicitly differentiate from siblings like 'analyze_data_distribution' or 'describe_table' which might also involve column analysis. The purpose is clear but lacks sibling distinction.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites, context (e.g., data quality assessment), or exclusions. With many sibling tools for database analysis, the lack of usage guidelines leaves the agent guessing about appropriate scenarios.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

analyze_table_statsAnalyze Table StatisticsB

Get table row counts, size information, and last update statistics

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. While 'Get' implies a read-only operation, it doesn't specify whether this requires specific permissions, what happens with large tables, whether results are cached, or what format the output takes. For a tool with no annotation coverage, this leaves significant behavioral gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is perfectly concise - a single sentence that efficiently communicates the core functionality without any wasted words. It's front-loaded with the essential information and doesn't include unnecessary elaboration.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read-only analysis tool with 4 well-documented parameters but no output schema, the description provides adequate basic context about what statistics are retrieved. However, it doesn't address important contextual aspects like performance implications for large tables, output format, or how it differs from similar sibling tools, leaving some gaps in completeness.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, so all parameters are well-documented in the schema itself. The description doesn't add any meaningful parameter semantics beyond what's already in the schema (like explaining how parameters interact or providing examples). This meets the baseline expectation when schema coverage is complete.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with specific verbs ('Get table row counts, size information, and last update statistics'), making it easy to understand what it does. However, it doesn't explicitly differentiate from sibling tools like 'describe_table' or 'analyze_database_size', which might have overlapping functionality.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools like 'describe_table', 'analyze_database_size', and 'list_tables', there's no indication of when this specific statistical analysis tool is preferred or what distinguishes it from other analysis tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describe_stored_procedureDescribe Stored ProcedureC

Get detailed information about a specific stored procedure including parameters and definition

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
procedureNameYesName of the stored procedure to describe
schemaNoSchema name (default: dbo)
includeDefinitionNoInclude the procedure definition/body (default: true)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It mentions 'detailed information' but doesn't disclose behavioral traits like what specific details are returned (e.g., parameter types, return values, permissions), whether it's a read-only operation, error handling, or performance implications. The description is too vague to guide an agent effectively beyond basic intent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose. It avoids unnecessary words and directly states the action and key details, though it could be slightly more structured by explicitly separating scope from output details.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and no output schema, the description is incomplete for a tool with 5 parameters and complex database interactions. It lacks details on return format, error conditions, authentication needs, or how it differs from similar tools. For a read operation in a database context, more behavioral context is needed to ensure correct usage.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all parameters thoroughly. The description adds minimal value by implying that 'parameters and definition' are part of the output, which loosely relates to the 'includeDefinition' parameter but doesn't provide additional semantics beyond what the schema specifies. Baseline 3 is appropriate as the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb 'Get' and resource 'detailed information about a specific stored procedure', including specific details like 'parameters and definition'. It distinguishes from siblings like 'list_stored_procedures' (which lists names) and 'get_stored_procedure_definition' (which might only return the definition), but doesn't explicitly name these alternatives.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives. It doesn't mention siblings like 'get_stored_procedure_definition' or 'get_all_stored_procedure_definitions', nor does it specify prerequisites such as needing a connection or schema context. The description assumes context without stating it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describe_tableDescribe TableB

Get detailed schema information for a specific table including columns, data types, and constraints

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
tableNameYesName of the table to describe
schemaNoSchema name (default: dbo)

TDQS

B3.3/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It describes a read operation ('Get'), but lacks details on permissions required, error handling (e.g., if table doesn't exist), output format, or performance considerations. For a tool with no annotation coverage, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose. Every word earns its place, with no redundancy or fluff. It's appropriately sized for a straightforward tool.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (4 parameters, no output schema, no annotations), the description is minimally adequate. It covers the purpose but lacks behavioral context, usage guidelines, and output details. Without annotations or output schema, more completeness would be beneficial, but it's not severely deficient.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all parameters thoroughly. The description adds no parameter-specific information beyond what's in the schema (e.g., it doesn't clarify parameter interactions or provide examples). Baseline 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Get detailed schema information') and resource ('for a specific table'), specifying what information is retrieved ('columns, data types, and constraints'). It distinguishes from siblings like list_tables (which lists tables) or analyze_table_stats (which analyzes statistics) by focusing on schema details.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., need for a connection), exclusions, or comparisons to siblings like list_constraints or list_indexes that might provide overlapping information. Usage is implied but not explicitly stated.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describe_triggerDescribe TriggerA

Get detailed information about a specific trigger including its definition and events

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
triggerNameYesName of the trigger to describe
includeDefinitionNoInclude the trigger definition (default: true)

TDQS

A3.5/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It states the tool retrieves information (a read operation) but does not disclose behavioral traits such as required permissions, rate limits, error handling, or what 'detailed information' includes beyond definition and events. This leaves significant gaps for a tool with database access.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose ('Get detailed information about a specific trigger') and specifies key details ('definition and events'). There is no wasted verbiage or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and no output schema, the description is incomplete for a database query tool. It lacks details on return format (e.g., structure of 'detailed information'), error conditions, or connection handling. However, it adequately states the purpose and parameters are well-documented in the schema, making it minimally viable.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 4 parameters. The description does not add meaning beyond the schema (e.g., it doesn't explain parameter interactions or provide examples). Baseline 3 is appropriate as the schema handles parameter documentation adequately.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Get') and resource ('detailed information about a specific trigger'), specifying what information is retrieved ('definition and events'). It distinguishes from siblings like 'list_triggers' (which lists triggers) and 'describe_stored_procedure' (which describes a different resource type).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage when detailed trigger information is needed, but does not explicitly state when to use this tool versus alternatives (e.g., 'list_triggers' for a list, 'describe_table' for table details). No exclusions or prerequisites are mentioned, leaving guidance incomplete.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

describe_viewDescribe ViewC

Get detailed information about a specific view including its definition and dependencies

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
viewNameYesName of the view to describe
schemaNoSchema name (default: dbo)
includeDefinitionNoInclude the view definition (default: true)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions what information is retrieved ('detailed information... definition and dependencies'), but doesn't cover critical aspects like whether this is a read-only operation, potential performance impacts, authentication needs, error handling, or output format. The description is minimal and lacks behavioral context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose. It avoids unnecessary words and gets straight to the point, though it could be slightly more structured (e.g., by explicitly noting it's for SQL Server views).

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (5 parameters, no annotations, no output schema), the description is incomplete. It doesn't address behavioral aspects like safety, performance, or output format, and provides no usage guidance. For a tool that interacts with databases and has multiple configuration options, this minimal description leaves significant gaps for an AI agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 5 parameters. The description doesn't add any parameter-specific information beyond what's in the schema (e.g., it doesn't explain relationships between parameters like connectionString vs. connectionName). Baseline score of 3 is appropriate since the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Get detailed information about a specific view including its definition and dependencies.' It specifies the verb ('Get detailed information') and resource ('a specific view'), but doesn't explicitly differentiate from sibling tools like 'describe_table' or 'describe_stored_procedure' beyond the view focus.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools like 'list_views' (for listing views) or 'execute_query' (for custom queries about views), nor does it specify prerequisites or contextual usage scenarios beyond the basic purpose.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

detect_audit_columnsDetect Audit ColumnsB

Identify common audit trail patterns (created/modified dates, user tracking)

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states what the tool does but lacks details on behavior: it doesn't specify if this is a read-only operation, what the output format might be (e.g., list of columns, report), whether it requires specific permissions, or if there are rate limits. For a tool with zero annotation coverage, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'Identify common audit trail patterns (created/modified dates, user tracking)'. It is front-loaded with the core purpose and includes clarifying examples in parentheses. There is zero waste, and every word contributes to understanding the tool's function.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (3 parameters, no output schema, no annotations), the description is minimally adequate. It states the purpose clearly but lacks context on behavior, output, or usage relative to siblings. With no output schema, the description doesn't explain return values, and with no annotations, it misses safety or operational details. It's complete enough for basic understanding but has clear gaps for effective agent use.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all three parameters (connectionString, connectionName, schema) with their descriptions. The description adds no additional meaning beyond the schema, such as explaining how parameters interact (e.g., precedence between connectionString and connectionName) or what 'audit trail patterns' entail in terms of parameter usage. Baseline 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Identify common audit trail patterns (created/modified dates, user tracking)'. It specifies the verb 'identify' and the resource 'audit trail patterns', making it distinct from siblings like 'analyze_null_patterns' or 'describe_table'. However, it doesn't explicitly differentiate from similar tools like 'find_computed_columns' or 'list_constraints', which could also involve column analysis.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., database connection), exclusions (e.g., non-SQL Server databases), or compare it to siblings like 'analyze_null_patterns' for other column types. Usage is implied through the action 'identify', but no explicit context is given.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

execute_queryExecute SQL QueryA

Execute a custom SQL SELECT query with automatic limit (top 20 rows)

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
queryYesSQL SELECT query to execute

TDQS

A3.9/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It adds valuable context beyond the input schema by specifying 'automatic limit (top 20 rows)', which informs the agent about result truncation behavior. However, it does not cover other potential behaviors like error handling, permissions required, or execution time limits.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose and includes a critical behavioral detail (automatic limit). There is no wasted verbiage, and every word contributes to understanding the tool's function and constraints.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (executing arbitrary SQL queries) and lack of annotations and output schema, the description is minimally adequate. It covers the core action and a key behavioral trait (row limit), but does not address output format, error conditions, or security implications, leaving gaps for a mutation-capable tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all three parameters thoroughly. The description does not add any meaning beyond what the schema provides for parameters like 'connectionString' or 'query'. Baseline 3 is appropriate as the schema handles parameter documentation adequately.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the specific action ('Execute a custom SQL SELECT query') and resource (SQL queries), distinguishing it from sibling tools that analyze, describe, list, or sample data rather than executing arbitrary queries. It precisely conveys the tool's function as a query executor.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for executing custom SELECT queries, but does not explicitly state when to use this tool versus alternatives like 'sample_data' or other analysis tools. It lacks guidance on prerequisites, exclusions, or specific scenarios favoring this tool over siblings.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

find_computed_columnsFind Computed ColumnsC

List computed columns and their formulas to understand derived business logic

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It states this is a listing operation but doesn't describe what the output looks like (format, structure, or content beyond 'computed columns and their formulas'). It doesn't mention whether this requires specific permissions, whether it's read-only (implied but not stated), or any rate limits or performance considerations for database queries.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is perfectly concise at 10 words. It's front-loaded with the core functionality ('List computed columns and their formulas') followed by the purpose ('to understand derived business logic'). Every word earns its place with zero redundancy or wasted text.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a database query tool with 4 parameters and no output schema, the description is insufficient. It doesn't explain what the output contains (beyond 'computed columns and their formulas'), how results are structured, whether there's pagination, or what happens when no computed columns exist. With no annotations and no output schema, the description should provide more behavioral context for effective tool use.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all 4 parameters thoroughly. The description adds no additional parameter information beyond what's in the schema - it doesn't explain how parameters interact, provide examples of connection strings, or clarify the relationship between connectionString and connectionName. Baseline 3 is appropriate when schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'List computed columns and their formulas' (verb+resource). It distinguishes from siblings by focusing specifically on computed columns rather than other database objects like tables, indexes, or stored procedures. However, it doesn't explicitly differentiate from similar tools like 'describe_table' which might also provide column information.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when this tool is preferable to 'describe_table' or other sibling tools that might provide overlapping information. There's no context about prerequisites, limitations, or typical use cases beyond the generic 'to understand derived business logic' phrase.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

find_lookup_tablesFind Lookup TablesC

Identify reference/lookup tables automatically based on table patterns

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
maxRowsNoMaximum rows to consider as lookup table (default: 1000)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It mentions the action ('identify') but doesn't describe what 'identify' entails—e.g., whether it returns a list, what patterns are used, if it's read-only or has side effects, or any performance considerations. This leaves significant gaps in understanding the tool's behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It's front-loaded with the core action and resource, making it easy to understand quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of identifying tables based on patterns, no annotations, and no output schema, the description is incomplete. It doesn't explain what constitutes a 'lookup table,' what 'patterns' are used, or what the output looks like. This leaves the agent with insufficient context to use the tool effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 100% description coverage, so the schema already documents all parameters thoroughly. The description adds no additional parameter semantics beyond what's in the schema, such as explaining how 'table patterns' relate to the parameters. This meets the baseline for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Identify reference/lookup tables automatically based on table patterns.' It specifies the verb ('identify'), resource ('reference/lookup tables'), and method ('based on table patterns'). However, it doesn't explicitly distinguish itself from sibling tools like 'list_tables' or 'analyze_table_stats,' which prevents a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools or contexts where this tool is preferred, such as for data analysis versus simple listing. Without any usage context, the agent must infer when this tool is appropriate.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

find_missing_indexesFind Missing IndexesC

Identify potentially missing indexes based on query execution patterns

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
minImpactNoMinimum impact score to include (default: 1000)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It mentions the tool 'identifies potentially missing indexes' but doesn't disclose behavioral traits like whether this is a read-only analysis, what permissions are required, how long it might take, whether it impacts database performance, or what format the output takes. The description is minimal and leaves critical operational context unspecified.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that gets straight to the point with zero wasted words. It's appropriately sized for the tool's complexity and is perfectly front-loaded with the core functionality.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's analytical nature, no annotations, and no output schema, the description is insufficiently complete. It doesn't explain what the tool returns (e.g., recommendations, impact scores, SQL statements), how results are structured, or any prerequisites for use. For a database analysis tool with zero structured metadata beyond the input schema, the description should provide more operational context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all four parameters thoroughly. The description adds no additional parameter semantics beyond what's in the schema. According to scoring rules, when schema coverage is high (>80%), the baseline is 3 even with no parameter information in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb ('identify') and resource ('potentially missing indexes'), and specifies the basis ('based on query execution patterns'). However, it doesn't explicitly differentiate from sibling tools like 'analyze_index_usage' or 'list_indexes', which could have overlapping analysis functions.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools focused on database analysis (e.g., 'analyze_index_usage', 'list_indexes'), there's no indication of when this specific index-finding tool is preferable or what distinguishes it from other analysis tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_all_stored_procedure_definitionsGet All Stored Procedure DefinitionsB

Get complete SQL definitions for all stored procedures in a schema

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
includeSystemProceduresNoInclude system stored procedures (default: false)
maxResultsNoMaximum number of procedures to return (default: 50, max: 100)

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It mentions 'complete SQL definitions' but doesn't disclose behavioral traits like pagination (implied by maxResults), authentication needs (connection parameters), rate limits, or whether this is a read-only operation. The description is minimal and lacks operational context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose. Every word earns its place with no redundancy or wasted phrasing, making it easy to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a tool with 5 parameters, no annotations, and no output schema, the description is inadequate. It doesn't explain return values (e.g., format of definitions), behavioral constraints (e.g., default limits), or error conditions. The minimal description leaves significant gaps for agent understanding.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 5 parameters. The description adds no parameter-specific information beyond implying schema scope. Baseline 3 is appropriate as the schema does the heavy lifting, but the description doesn't compensate with additional semantic context.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Get') and resource ('complete SQL definitions for all stored procedures in a schema'), specifying scope ('all stored procedures') and output format ('SQL definitions'). It distinguishes from sibling tools like 'get_stored_procedure_definition' (singular) and 'list_stored_procedures' (names only).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance on when to use this tool versus alternatives is provided. The description doesn't mention when to choose this over 'list_stored_procedures' (for names only), 'get_stored_procedure_definition' (for a single procedure), or 'get_multiple_stored_procedure_definitions' (for a subset). Usage context is implied but not explicit.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_multiple_stored_procedure_definitionsGet Multiple Stored Procedure DefinitionsC

Get complete SQL definitions for multiple stored procedures at once

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
procedureNamesYesArray of stored procedure names to get definitions for
schemaNoSchema name (default: dbo)
includeMetadataNoInclude metadata like creation date, modification date (default: true)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states the tool retrieves definitions but doesn't mention whether this is a read-only operation, what permissions are required, how it handles errors, or what the return format looks like. The description is minimal and lacks important behavioral context for a database query tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that states the core purpose without unnecessary words. It's appropriately sized for a straightforward retrieval tool and gets directly to the point.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a database query tool with 5 parameters, no annotations, and no output schema, the description is insufficient. It doesn't explain what 'complete SQL definitions' includes, how results are structured, or any behavioral aspects. The agent would need to guess about the tool's operation and output format.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, so all parameters are documented in the schema. The description doesn't add any meaningful parameter semantics beyond what's already in the schema - it doesn't explain relationships between parameters (e.g., connectionString vs connectionName) or provide usage examples. This meets the baseline for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb ('Get') and resource ('complete SQL definitions for multiple stored procedures at once'). It distinguishes from the sibling tool 'get_stored_procedure_definition' by specifying 'multiple stored procedures at once', though it doesn't explicitly mention how it differs from 'get_all_stored_procedure_definitions'.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to choose this over 'get_stored_procedure_definition' (for single procedures) or 'get_all_stored_procedure_definitions' (for all procedures), nor does it discuss prerequisites or context for usage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_relationshipsGet Table RelationshipsC

Get foreign key relationships between tables in the database

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states what the tool does but lacks critical behavioral details: it doesn't specify if this is a read-only operation (implied by 'Get' but not explicit), what permissions are required, how results are formatted (e.g., list of relationships with details), whether it's paginated or returns all data at once, or potential rate limits. For a database query tool with zero annotation coverage, this is a significant gap.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose ('Get foreign key relationships between tables in the database') with zero wasted words. It's appropriately sized for a straightforward tool and earns its place by clearly stating the tool's function without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (database metadata query with 3 parameters), lack of annotations, and no output schema, the description is incomplete. It doesn't cover behavioral aspects like safety (read-only vs. destructive), output format, error handling, or connection requirements. For a tool that interacts with database connections and returns relationship data, more context is needed to guide effective use.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all three parameters (connectionString, connectionName, schema) with clear descriptions. The description adds no parameter-specific information beyond what's in the schema—it doesn't explain how parameters interact (e.g., precedence between connectionString and connectionName) or provide examples. Baseline 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Get') and resource ('foreign key relationships between tables in the database'), making the tool's purpose immediately understandable. It distinguishes from siblings like 'list_constraints' or 'list_tables' by specifying foreign key relationships. However, it doesn't explicitly contrast with all potential alternatives like 'describe_table' which might include relationship info.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., needing a valid connection), compare it to siblings like 'list_constraints' (which might include foreign keys) or 'describe_table' (which might show relationships), or specify scenarios where this tool is preferred. Usage is implied but not explicitly stated.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_stored_procedure_definitionGet Stored Procedure DefinitionA

Get the complete SQL query/definition of a stored procedure - this is the actual source code

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
procedureNameYesName of the stored procedure to get definition for
schemaNoSchema name (default: dbo)
formatOutputNoFormat the SQL output for better readability (default: true)

TDQS

A3.5/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden but only states it retrieves the 'complete SQL query/definition'. It doesn't disclose behavioral traits like whether this requires specific permissions, if it's read-only, potential rate limits, or what happens on errors. The description is minimal beyond the basic action.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose ('Get the complete SQL query/definition') and adds clarifying detail ('actual source code'). There's zero waste, and it's appropriately sized for the tool's complexity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a read operation with 5 parameters and no output schema, the description is adequate but minimal. It covers the basic purpose but lacks details on return format (e.g., raw SQL string), error handling, or prerequisites. Given the schema's good coverage and no annotations, it's minimally viable but could be more complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 5 parameters. The description adds no parameter-specific information beyond what the schema provides, such as clarifying 'procedureName' format or 'connectionString' security implications. Baseline 3 is appropriate when schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('Get') and resource ('complete SQL query/definition of a stored procedure'), specifying it's the 'actual source code'. It distinguishes from siblings like 'describe_stored_procedure' (which likely provides metadata) and 'get_all_stored_procedure_definitions' (which retrieves multiple).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies usage for retrieving SQL source code, but doesn't explicitly state when to use this vs. alternatives like 'describe_stored_procedure' or 'get_all_stored_procedure_definitions'. It provides some context but lacks clear exclusions or comparative guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_connectionsList Available ConnectionsA

List all available named database connections configured in the server

ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

TDQS

A3.5/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries full burden for behavioral disclosure. It only states that it lists connections without mentioning auth requirements, rate limits, side effects, or whether the listing is scoped to the current user. For a read operation, minimal transparency is provided beyond the action itself.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence of 8 words. It is front-loaded with the action and resource, containing no fluff or repetition. Every word adds value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given low complexity (no params, no output schema), the description covers the essential purpose but lacks details on what the list contains (e.g., connection names, types, status). For a list tool, some context about the output would enhance usability.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The tool has zero parameters and schema coverage is 100% (empty schema). Per guidelines, baseline for 0 parameters is 4. The description does not need to add parameter info but provides concise purpose that aligns with the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb 'list' and resource 'database connections', clearly distinguishing it from sibling list tools like list_databases and list_tables. It adds clarity by specifying 'named database connections configured in the server', avoiding any ambiguity.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives like test_connection or other list tools. The description does not mention any prerequisites, exclusions, or context-dependent usage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_constraintsList All ConstraintsC

List all constraints (check, unique, foreign key, etc.) across tables in the database

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
constraintTypeNoFilter by constraint type (default: ALL)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It states the action ('List all constraints') but lacks behavioral details: it doesn't specify output format (e.g., list, table, JSON), pagination, error handling, permissions required, or performance implications. The description is minimal and doesn't compensate for missing annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Single sentence that is efficient and front-loaded with the core purpose. No wasted words, though it could be slightly more structured (e.g., by explicitly mentioning parameters). It earns its place by clearly stating the tool's function.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and no output schema, the description is incomplete for a tool with 4 parameters and database interaction. It doesn't explain what the output looks like (critical for a 'list' operation), error conditions, or connection requirements. For a read operation with potential complexity, more context is needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so parameters are fully documented in the schema. The description adds no additional meaning beyond implying filtering by constraint type ('check, unique, foreign key, etc.'), which aligns with the 'constraintType' enum. Baseline score of 3 is appropriate as the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('all constraints'), specifying constraint types like check, unique, foreign key, etc. It distinguishes from siblings like 'list_default_constraints' by covering all constraint types, but doesn't explicitly contrast with other constraint-related tools like 'analyze_check_constraints'.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No explicit guidance on when to use this tool versus alternatives. It doesn't mention when to prefer 'list_constraints' over 'list_default_constraints' or 'analyze_check_constraints', nor does it provide context about prerequisites like needing a valid connection. Usage is implied by the description but not articulated.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_databasesList DatabasesB

List all databases available on the SQL Server instance

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden but lacks behavioral details. It doesn't mention permissions required, rate limits, whether it returns all databases or only accessible ones, or if it includes system databases. 'List all databases' implies a read operation, but no further context is given about the behavior beyond the basic action.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, clear sentence with no wasted words. It's front-loaded with the core action and resource, making it easy to parse. Every word earns its place by conveying essential information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a simple listing tool with no annotations and no output schema, the description is minimally adequate. It covers the basic purpose but lacks context about behavior, usage, or output format. Given the complexity is low (2 optional parameters), it's complete enough to understand what it does but not how to use it effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents both parameters. The description doesn't add any parameter-specific information beyond what's in the schema (e.g., it doesn't explain how connectionString and connectionName interact). This meets the baseline of 3 when schema coverage is high.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('all databases available on the SQL Server instance'), making the purpose unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'list_connections' or 'list_tables', which would require a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives. For example, it doesn't mention if this is for discovery versus analysis tools like 'analyze_database_size', or if it should be used before other listing operations. The description only states what it does, not when to use it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_default_constraintsList Default ConstraintsC

List all default value constraints and their definitions

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It states it's a list operation, implying read-only behavior, but doesn't mention any side effects, permissions required, rate limits, or what the output looks like (e.g., format, pagination). For a database query tool with zero annotation coverage, this leaves significant gaps in understanding how it behaves.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without any fluff. It's appropriately sized and front-loaded with the core functionality, making it easy to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and no output schema, the description is incomplete for a database query tool with 4 parameters. It doesn't explain what 'default value constraints' are in this context, what the output format will be, or any behavioral aspects like error handling. For a tool that likely returns structured data, more context is needed to use it effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so all parameters are documented in the schema. The description adds no additional parameter information beyond what's in the schema (it doesn't explain parameter interactions, defaults beyond schema hints, or provide examples). Baseline 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('default value constraints and their definitions'), making the purpose unambiguous. It distinguishes from generic 'list_constraints' by specifying 'default' constraints, but doesn't explicitly differentiate from all sibling tools like 'analyze_check_constraints' or 'find_computed_columns' which might also relate to constraints.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to prefer this over 'list_constraints' (which might include all constraint types) or how it relates to other analysis tools. There's no context about prerequisites, typical use cases, or limitations.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_functionsList User-Defined FunctionsB

List all user-defined functions (scalar, table-valued, etc.)

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
functionTypeNoFilter by function type (default: ALL)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool lists functions but doesn't describe output format, pagination, error handling, or authentication requirements. The description lacks details on what 'list all' entails (e.g., scope, limitations), leaving behavioral traits unclear for an agent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence: 'List all user-defined functions (scalar, table-valued, etc.)'. It's front-loaded with the core purpose and includes helpful examples without unnecessary elaboration. Every word earns its place, making it highly concise and well-structured.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (listing database objects), no annotations, and no output schema, the description is minimally adequate. It states what the tool does but lacks details on behavior, output, or usage context. For a read-only listing tool with full parameter documentation, it's passable but leaves gaps in guiding an agent effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 4 parameters with descriptions and an enum. The description adds no parameter-specific information beyond implying filtering by function types (e.g., 'scalar, table-valued, etc.'), which aligns with the 'functionType' parameter. This meets the baseline of 3 when schema coverage is high.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'List all user-defined functions (scalar, table-valued, etc.)'. It specifies the verb ('List') and resource ('user-defined functions'), and includes examples of function types. However, it doesn't explicitly differentiate from sibling tools like 'list_stored_procedures' or 'list_views', though the resource type distinction is implicit.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools like 'list_stored_procedures' or 'describe_stored_procedure', nor does it specify prerequisites or contexts where this tool is preferred. Usage is implied by the name and purpose but not explicitly stated.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_indexesList Table IndexesB

List all indexes on tables with usage statistics and detailed information

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name
includeUsageStatsNoInclude index usage statistics (default: true)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It mentions 'usage statistics and detailed information', implying read-only behavior and output details, but doesn't disclose critical traits like whether it requires specific permissions, potential performance impact on the database, rate limits, or error handling. For a tool with 5 parameters and no annotations, this leaves significant gaps in understanding its behavior.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose ('List all indexes on tables') and adds key details ('with usage statistics and detailed information'). There's zero waste, and every word earns its place by specifying scope and output characteristics without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (5 parameters, no annotations, no output schema), the description is minimally adequate. It covers the basic purpose and output scope but lacks completeness for a tool that interacts with databases: it doesn't explain return format, error conditions, or dependencies on other tools like 'list_connections'. With no output schema, the description should ideally hint at what 'detailed information' includes, but it doesn't, leaving gaps in contextual understanding.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 5 parameters. The description adds no additional meaning beyond the schema, such as explaining parameter interactions (e.g., how 'connectionString' and 'connectionName' relate) or providing examples. With high schema coverage, the baseline score of 3 is appropriate, as the description doesn't compensate but also doesn't detract.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('List all indexes') and resource ('on tables'), specifying the scope includes 'usage statistics and detailed information'. It distinguishes from siblings like 'list_tables' or 'analyze_index_usage' by focusing on indexes rather than tables or usage analysis alone. However, it doesn't explicitly differentiate from 'find_missing_indexes' or 'list_constraints', which could overlap in purpose.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools like 'analyze_index_usage' for deeper analysis, 'find_missing_indexes' for optimization, or 'list_constraints' for related metadata. There's no context on prerequisites, such as needing a connection, or exclusions for specific database types.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_stored_proceduresList Stored ProceduresC

List all stored procedures, functions, and their basic information

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
includeSystemObjectsNoInclude system stored procedures (default: false)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden for behavioral disclosure. It mentions 'basic information' but doesn't specify what that includes (e.g., names, schemas, creation dates) or behavioral aspects like pagination, error handling, or performance implications. This leaves significant gaps for a tool with 4 parameters.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It's appropriately sized and front-loaded, making it easy to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (4 parameters, no annotations, no output schema) and rich sibling context, the description is insufficient. It doesn't explain what 'basic information' includes, how results are formatted, or when to choose this over similar tools, leaving the agent with incomplete operational context.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 4 parameters. The description adds no additional parameter semantics beyond what's in the schema, such as explaining interactions between parameters or default behaviors. This meets the baseline for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('stored procedures, functions, and their basic information'), making the purpose unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'list_functions', 'get_all_stored_procedure_definitions', or 'search_stored_procedures_by_content', which prevents a perfect score.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools like 'list_functions', 'get_all_stored_procedure_definitions', and 'search_stored_procedures_by_content', the agent is left to infer usage context without explicit direction.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_tablesList TablesB

List all tables in the connected database

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. While 'List all tables' implies a read-only operation, it doesn't disclose behavioral traits such as whether it requires specific permissions, how it handles large result sets, or what the output format looks like (e.g., list of names vs. detailed metadata). This is a significant gap for a tool with no annotation coverage.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose without any wasted words. It's appropriately sized for a straightforward listing tool, making it easy for an agent to parse quickly.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's low complexity (a simple list operation) and 100% schema coverage, the description is minimally adequate. However, with no output schema and no annotations, it lacks details on return values or behavioral constraints, leaving gaps that could hinder correct invocation in more complex scenarios.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema description coverage is 100%, with all three parameters well-documented in the input schema (e.g., connectionString, connectionName, schema). The description adds no additional parameter semantics beyond what the schema provides, so it meets the baseline of 3 for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('all tables in the connected database'), making the purpose immediately understandable. However, it doesn't explicitly differentiate from sibling tools like 'list_databases' or 'list_views', which would require more specificity to earn a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With many sibling tools like 'list_databases', 'list_views', and 'describe_table', there's no indication of context, prerequisites, or exclusions, leaving the agent to infer usage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_triggersList TriggersB

List all triggers in the database with their associated tables

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
tableNameNoFilter by specific table name

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It states it lists triggers 'with their associated tables,' hinting at output structure, but lacks details on permissions needed, rate limits, pagination, or error handling for a database tool, which is a significant gap for safe operation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence with zero waste—it directly states the action and scope. It's front-loaded and appropriately sized for a listing tool, earning full marks for conciseness.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (4 parameters, no output schema, no annotations), the description is minimally adequate. It clarifies the purpose but lacks usage guidelines and behavioral details, making it incomplete for safe and effective use, though not critically so.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all 4 parameters. The description adds no additional meaning beyond implying filtering by table via 'associated tables,' but this is already covered in the schema's 'tableName' description. Baseline 3 is appropriate as the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('all triggers in the database'), making the purpose evident. It distinguishes from siblings like 'describe_trigger' by focusing on listing rather than describing details, though it doesn't explicitly contrast with other listing tools like 'list_tables' or 'list_constraints'.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., needing a connection), compare to siblings like 'describe_trigger' for detailed info, or specify scenarios where filtering by table is useful, leaving usage context unclear.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_user_defined_typesList User-Defined Data TypesC

List all user-defined data types and their definitions

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden but offers minimal behavioral context. It states it's a listing operation but doesn't disclose pagination, rate limits, permissions required, or what 'definitions' include. For a tool with zero annotation coverage, this is inadequate.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence with zero wasted words. It's appropriately sized for a simple listing tool and front-loads the core purpose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and no output schema, the description is incomplete. It doesn't explain what 'definitions' entail, the return format, or behavioral aspects like error handling. For a tool with 3 parameters and rich sibling context, it should provide more guidance.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema fully documents all three parameters. The description adds no parameter-specific information beyond what's in the schema, resulting in the baseline score of 3.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('user-defined data types and their definitions'), making the purpose unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'list_functions' or 'list_stored_procedures', which would require a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites (e.g., needing a connection), exclusions, or how it differs from other listing tools like 'list_tables' or 'list_functions'.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_viewsList ViewsC

List all views in the database with their basic information

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
schemaNoSchema name (default: dbo)
includeSystemViewsNoInclude system views (default: false)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It mentions 'basic information' but doesn't specify what that includes (e.g., view names, schemas, creation dates). It also doesn't disclose behavioral aspects like whether this is a read-only operation, if it requires specific permissions, or how results are formatted/paginated.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that gets straight to the point with no wasted words. It could potentially be improved with more specific information about what 'basic information' includes, but it's appropriately concise for its current content.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a tool with no annotations and no output schema, the description is insufficient. It doesn't explain what 'basic information' includes in the return values, doesn't mention behavioral constraints, and provides no context about how this differs from related tools. The 100% schema coverage helps, but the description itself lacks completeness.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all 4 parameters thoroughly. The description adds no additional parameter information beyond what's in the schema, which is acceptable but not exceptional - meeting the baseline 3 for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('List') and resource ('all views in the database'), making the purpose unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'describe_view' or 'list_tables', which would require more specific scope information to earn a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With sibling tools like 'describe_view' (detailed view info) and 'list_tables' (similar listing for tables), there's no indication of when this listing tool is preferred over other analysis or description tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

sample_dataSample Table DataB

Retrieve sample data from a table (top 10 rows by default)

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
tableNameYesName of the table to sample
schemaNoSchema name (default: dbo)
limitNoNumber of rows to return (default: 10, max: 100)

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries full burden. It mentions the default row limit (10) and maximum (100), which is useful behavioral context. However, it doesn't disclose important traits like whether this is a read-only operation (implied but not stated), potential performance impact on large tables, authentication requirements through connection parameters, or what happens with invalid table names. For a data retrieval tool with zero annotation coverage, this leaves significant gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is perfectly concise - a single sentence that immediately communicates the core functionality. Every word earns its place: 'Retrieve' (action), 'sample data' (what), 'from a table' (where), and '(top 10 rows by default)' (key behavioral detail). No wasted words or redundant information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity (5 parameters, database operations) and lack of both annotations and output schema, the description is minimally adequate. It covers the basic purpose and default behavior but misses important context about authentication, error handling, performance considerations, and return format. For a data retrieval tool that could have significant implications depending on the database accessed, more completeness would be expected.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all 5 parameters thoroughly. The description adds minimal value beyond the schema - it implies the 'limit' parameter exists through mentioning 'top 10 rows by default', but doesn't provide additional semantic context about parameter interactions or usage patterns. The baseline of 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Retrieve sample data') and resource ('from a table'), making the purpose immediately understandable. It distinguishes from siblings like 'describe_table' or 'execute_query' by focusing on sampling rather than metadata or arbitrary queries. However, it doesn't explicitly differentiate from 'analyze_data_distribution' which might also involve data sampling.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. With siblings like 'describe_table' (metadata), 'execute_query' (custom queries), and 'analyze_data_distribution' (statistical analysis), there's no indication of when sampling is preferred over these other approaches. The default limit (10 rows) is mentioned but without context about why this default exists or when to override it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_stored_procedures_by_contentSearch Stored Procedures by ContentB

Search for stored procedures containing specific text or patterns in their SQL definition

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')
searchTextYesText or pattern to search for in procedure definitions
schemaNoSchema name (default: dbo)
caseSensitiveNoCase sensitive search (default: false)
includeDefinitionsNoInclude full procedure definitions in results (default: false)

TDQS

B3.2/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden but only states the basic operation. It doesn't disclose behavioral traits like whether this is a read-only operation, performance implications, authentication requirements, rate limits, or what the results look like. For a search tool with database access, this is inadequate.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that states the core purpose without waste. It's appropriately sized for this tool and front-loads the essential information. Every word earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a database search tool with no annotations and no output schema, the description is insufficient. It doesn't explain what results to expect, how they're formatted, whether this is a safe read operation, or any performance considerations. The description alone doesn't provide enough context for an agent to use this tool effectively.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all 6 parameters thoroughly. The description doesn't add any parameter semantics beyond what's in the schema - it mentions 'text or patterns' which aligns with searchText parameter but provides no additional context about parameter interactions or usage patterns.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb ('search for') and resource ('stored procedures') with specific scope ('containing specific text or patterns in their SQL definition'). It distinguishes from siblings like list_stored_procedures (which lists all) and get_stored_procedure_definition (which retrieves specific ones).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to prefer this over list_stored_procedures, get_all_stored_procedure_definitions, or other search-related tools. No prerequisites, exclusions, or comparative context is provided.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

test_connectionTest ConnectionC

Test the database connection and return basic server information

ParametersJSON Schema
NameRequiredDescriptionDefault
connectionStringNoSQL Server connection string (uses default if not provided)
connectionNameNoNamed connection to use (e.g., 'production', 'staging')

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool tests a connection and returns server information, but it doesn't cover critical aspects like whether this is a read-only operation, if it requires authentication, potential side effects (e.g., logging or network traffic), error handling, or rate limits. For a tool that interacts with a database, this is a significant gap in transparency.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, clear sentence that efficiently conveys the core functionality without any wasted words. It's front-loaded with the main action and outcome, making it easy for an agent to parse quickly. This is an excellent example of conciseness.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of database operations and the lack of annotations and output schema, the description is incomplete. It doesn't explain what 'basic server information' includes, how errors are handled, or any dependencies. For a tool that could involve network calls and authentication, more context is needed to ensure safe and effective use by an agent.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents both parameters ('connectionString' and 'connectionName') with descriptions. The tool description adds no additional parameter semantics beyond what's in the schema, such as examples or usage tips. According to the rules, with high schema coverage, the baseline is 3 even without param info in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'Test the database connection and return basic server information.' It specifies the verb ('test') and resource ('database connection') with an outcome ('return basic server information'). However, it doesn't explicitly differentiate from sibling tools like 'list_connections' or 'execute_query', which might involve connection testing indirectly, so it's not a perfect 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention prerequisites, such as whether a connection must be established first, or compare it to siblings like 'list_connections' for checking available connections or 'execute_query' for testing with a query. This lack of context leaves the agent to guess based on the tool name alone.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 1 tool updatev1.0.0
    • Changedlist_connections1 field changed
      • removedInput schema / additionalProperties
        Removed value: -false
  2. 33 tool updates
    • First observedanalyze_check_constraints
    • First observedanalyze_data_distribution
    • First observedanalyze_database_size
    • First observedanalyze_index_usage
    • First observedanalyze_null_patterns
    • First observedanalyze_table_stats
    • First observeddescribe_stored_procedure
    • First observeddescribe_table
    • First observeddescribe_trigger
    • First observeddescribe_view
    • First observeddetect_audit_columns
    • First observedexecute_query
    • First observedfind_computed_columns
    • First observedfind_lookup_tables
    • First observedfind_missing_indexes
    • First observedget_all_stored_procedure_definitions
    • First observedget_multiple_stored_procedure_definitions
    • First observedget_relationships
    • First observedget_stored_procedure_definition
    • First observedlist_connections
    • First observedlist_constraints
    • First observedlist_databases
    • First observedlist_default_constraints
    • First observedlist_functions
    • First observedlist_indexes
    • First observedlist_stored_procedures
    • First observedlist_tables
    • First observedlist_triggers
    • First observedlist_user_defined_types
    • First observedlist_views
    • First observedsample_data
    • First observedsearch_stored_procedures_by_content
    • First observedtest_connection

TDQS

B3.4/5.0

Scored across 33 tools

Disambiguation4/5

Most tools have distinct purposes, but there is some overlap that could cause confusion. For example, 'describe_stored_procedure' and 'get_stored_procedure_definition' both provide stored procedure details, and 'list_stored_procedures' overlaps with 'search_stored_procedures_by_content' in listing procedures. However, descriptions help clarify differences, and most tools target specific analysis or listing tasks without significant ambiguity.

Naming Consistency5/5

Tool names follow a highly consistent verb_noun pattern throughout, such as 'analyze_check_constraints', 'describe_table', 'list_databases', and 'find_missing_indexes'. All tools use snake_case without deviation, and verbs like 'analyze', 'describe', 'list', 'find', and 'get' are applied predictably across similar resource types, making the naming scheme clear and uniform.

Tool Count3/5

With 33 tools, the count is borderline high for a database analysis server, feeling somewhat heavy and potentially overwhelming. While the tools cover a wide range of analysis and listing tasks, the number could be streamlined by consolidating overlapping functions (e.g., stored procedure tools). It's reasonable but leans toward excessive for typical agent use.

Completeness5/5

The tool set provides comprehensive coverage for database analysis and exploration, including listing resources, describing schemas, analyzing performance and data patterns, and executing queries. There are no obvious gaps; it supports full lifecycle tasks from connection testing to in-depth analysis, ensuring agents can handle most database-related workflows without dead ends.

Maintenance

ActivityInactive
ResponsivenessSyncing

Related MCP Connectors

Related MCP Servers

  • A
    license
    B
    quality
    D
    maintenance
    A Model Context Protocol server that enables AI assistants (Cursor, Windsurf, Claude Code) to interact with Microsoft SQL Server databases by providing connectivity through environment-configurable connections.
    8
    537 npm
    8
    MIT
  • F
    license
    A
    quality
    D
    maintenance
    Enables natural language to SQL queries on MSSQL databases via Claude, with safe SELECT-only execution and schema discovery.
    3
    -
  • F
    license
    Not graded
    quality
    F
    maintenance
    Enables AI assistants to connect to on-premises SQL Server databases using natural language for queries, schema management, and data operations.
    1
    -