sql-mcp-server

Name: sql-mcp-server
Author: prahveent

@prahveent

Repository

About sql-mcp-server

A Model Context Protocol (MCP) server built with mcp-framework for SQL Server database interactions

Basic information

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

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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

Comments

More Databases MCP servers

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Snowflake MCP Server

isaacwasserman

185

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K