Warp SQL Server MCP - Documentation

Complete setup guides, installation instructions, and usage examples.

📖 README →

🖥️ Warp Quick Start →

💻 VS Code Quick Start →

Download the latest version and view the changelog.

Download v1.7.2 →

View detailed test coverage reports and test results.

Coverage Report →

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