sql-mcp-server
@prahveent
About sql-mcp-server
A Model Context Protocol (MCP) server built with mcp-framework for SQL Server database interactions
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"sql-mcp-server-prahveent": {
"command": "npx",
"args": [
"mcp-debug"
]
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is sql-mcp-server?
A Model Context Protocol (MCP) server built with mcp-framework for SQL Server database interactions. It provides tools to list databases, retrieve schema, and execute parameterized SELECT queries.
How to use sql-mcp-server?
Install dependencies with npm install, build with npm run build, and start with npm start. Configure the .env file with your SQL Server connection details. Use with VS Code by creating a .vscode/mcp.json file pointing to http://localhost:1337/mcp. Debug with npx mcp-debug in a separate terminal.
Key features of sql-mcp-server
- Lists available databases on SQL Server
- Retrieves schema information for databases
- Executes parameterized SELECT queries
- Uses environment variables for configuration
- Built with the mcp-framework
- Supports read-only user setup
Use cases of sql-mcp-server
- Query database schema for LLM-assisted data exploration
- Run read-only SELECT queries via MCP tools
- List databases to understand server layout
- Integrate with VS Code for development workflows
- Test SQL tools
Basic information
More Databases MCP servers
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
Sqlite
modelcontextprotocolModel Context Protocol Servers
Elasticsearch MCP Server
elastic
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
MySQL MCP Server
designcomputerA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Comments