warp-sql

Warp SQL MCP exposes an AI-enabled interface for interacting with SQL Server databases. It enables natural language queries to be translated into SQL, supports enterprise-grade security defaults, and provides tools for schema exploration, data analysis, and operational insights. After starting the server, you can leverage the bundled MCP tools to perform tasks such as schema discovery, ad-hoc query generation, data export, and performance analysis, all through natural language prompts integrated with your AI assistant or development environment.

To use it, install the MCP package (either globally or via npx) and initialize the configuration. With the server running, connect your AI assistant or client to the MCP endpoints and issue requests like “Show me the top customers by revenue,” “Explain this query plan,” or “Export orders from last quarter to CSV.” The server exposes 16 database tools that cover common operations such as schema discovery, query generation, data export, performance insights, and routine maintenance tasks, enabling seamless AI-assisted database workflows.

Prerequisites:

• Node.js 20.19+ and npm
• Git (for manual source installation, if desired)
• Access to a SQL Server instance (host, port, database, credentials)

Option 1: Global npm installation (recommended)

1. Install the MCP globally: npm install -g @egarcia74/warp-sql-server-mcp
2. Initialize configuration: warp-sql-server-mcp init
3. Edit the generated config file (located at ~/.warp-sql-server-mcp.json) with your SQL Server details and security preferences.

Option 2: Run via npx (no global install)

1. Run the MCP server directly with npx: npx -y @egarcia74/warp-sql-server-mcp init
2. Edit the config as above in ~/.warp-sql-server-mcp.json.

Option 3: Manual installation from source

1. Clone the repository: git clone https://github.com/egarcia74/warp-sql-server-mcp.git
2. Navigate into the project and install dependencies: cd warp-sql-server-mcp npm install
3. Initialize and configure as above.

After installation, start the server using the configuration you created. Ensure your SQL Server environment variables (SQL_SERVER_HOST, SQL_SERVER_PORT, SQL_SERVER_DATABASE, SQL_SERVER_USER, SQL_SERVER_PASSWORD, etc.) are properly set in the config or environment.

Tips and common issues:

• Ensure SQL_SERVER_HOST, SQL_SERVER_PORT, and SQL_SERVER_DATABASE are set to the correct SQL Server instance you intend to query.
• If using Windows Authentication, leave SQL_SERVER_USER and SQL_SERVER_PASSWORD empty as described in the docs.
• Review the security defaults: by default, read-only mode is enabled and destructive/schema changes are disabled. Adjust environment variables accordingly for production vs. development.
• The config file is located at ~/.warp-sql-server-mcp.json. Keep its permissions restricted (600) to protect credentials.
• If you encounter connectivity issues, verify that SQL Server accepts TCP connections on the configured port and that any firewalls permit access from the MCP server host.
• The MCP tools include 16 capabilities for database analysis, query generation, data export, and performance insights. Refer to the complete documentation index in docs/ for specifics on each tool and usage examples.