MCP.so
Sign In

sql-mcp-server

@prahveent

Repository

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

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

Basic information

Category

Databases

Transports

stdio

Author

prahveent

More Databases MCP servers

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K