sql-mcp-server

Name: sql-mcp-server
Author: prahveent

@prahveent

代码仓库

关于 sql-mcp-server

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

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

prahveent

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "sql-mcp-server-prahveent": {
      "command": "npx",
      "args": [
        "mcp-debug"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

数据库分类下的更多 MCP 服务器

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245