Warp SQL Server MCP - Documentation

Complete setup guides, installation instructions, and usage examples.

Download the latest version and view the changelog.

View detailed test coverage reports and test results.

Comprehensive documentation for all 16 available MCP tools with parameters, examples, and usage details.

Quick overview of MCP tools provided by this server:

executeQuery - Execute a SQL query on the connected SQL Server database
listDatabases - List all databases on the SQL Server instance
listTables - List all tables in a specific database
describeTable - Get the schema information for a specific table
listForeignKeys - List all foreign key relationships in a schema
getTableData - Get sample data from a table with optional filtering and limiting
exportTableCsv - Export table data in CSV format
getPerformanceStats - Get overall performance statistics and health summary
getQueryPerformance - Get detailed query performance breakdown by tool
getConnectionHealth - Get connection pool health metrics and diagnostics
explainQuery - Get the execution plan for a SQL query to analyze performance
analyzeQueryPerformance - Analyze query performance and provide optimization suggestions
getIndexRecommendations - Get index recommendations for database optimization
detectQueryBottlenecks - Detect and analyze query bottlenecks in the database
getOptimizationInsights - Get comprehensive database optimization insights and health analysis
getServerInfo - Get MCP server configuration, status, and logging information

Environment variables and configuration options:

SQL_SERVER_HOST - SQL Server hostname
SQL_SERVER_PORT - SQL Server port (default: 1433)
SQL_SERVER_DATABASE - Initial database (default: master)
SQL_SERVER_USER - SQL Server username (optional)
SQL_SERVER_PASSWORD - SQL Server password (optional)
SQL_SERVER_ENCRYPT - Enable encryption (default: false)
SQL_SERVER_TRUST_CERT - Trust server certificate (default: true)
SQL_SERVER_READ_ONLY - Read-only mode (default: true)
SQL_SERVER_ALLOW_DESTRUCTIVE_OPERATIONS - Allow INSERT/UPDATE/DELETE (default: false)
SQL_SERVER_ALLOW_SCHEMA_CHANGES - Allow CREATE/DROP/ALTER (default: false)
ENABLE_PERFORMANCE_MONITORING - Enable query performance tracking (default: true)
MAX_METRICS_HISTORY - Maximum performance records to retain (default: 1000)
SLOW_QUERY_THRESHOLD - Milliseconds to flag slow queries (default: 5000)
TRACK_POOL_METRICS - Enable connection pool monitoring (default: true)
PERFORMANCE_SAMPLING_RATE - Fraction of queries to monitor (default: 1.0)

Useful resources and links:

🗄️ Warp SQL Server MCP