sql-mcp-server
@prahveent
sql-mcp-server について
A Model Context Protocol (MCP) server built with mcp-framework for SQL Server database interactions
基本情報
設定
以下の設定を使って、このサーバーを 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-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
コメント