execute_query
Run SQL SELECT queries on MSSQL databases via the MCP server, retrieving top 20 rows by default. Specify connection details or use defaults for quick data extraction.
Instructions
Execute a custom SQL SELECT query with automatic limit (top 20 rows)
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
query | Yes | SQL SELECT query to execute |