execute_query
Execute read-only SELECT queries with safety validation
How to use it
execute_query is exposed by the MCP Sqlserver MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the execute_query tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Sqlserver
npx mcp-sqlserverOther tools in MCP Sqlserver (7)
Get detailed table schema including columns, data types, and constraints
Get foreign key relationships for tables
Get SQL Server version, edition, and configuration details
Get table statistics including row counts and size information
List all databases on the SQL Server instance
List tables in a database or schema
List views in a database or schema