sql-mcp-server
If you are the rightful owner of sql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server built with mcp-framework for SQL Server database interactions.
The sql-mcp-server is a specialized server designed to facilitate interactions with SQL Server databases using the Model Context Protocol (MCP) framework. It provides a structured approach to executing SQL queries and retrieving database information through a set of predefined tools. The server is built using Node.js and TypeScript, ensuring a robust and scalable solution for database management tasks. The project is organized into services and tools, with a focus on SQL operations. It includes tools for listing databases, retrieving database schemas, and executing SELECT queries. The server is configured using environment variables, allowing for flexible deployment across different environments. Additionally, it supports integration with Visual Studio Code for development and debugging, making it a versatile tool for developers working with SQL Server databases.
Features
- Predefined SQL tools for database management
- Environment-based configuration for flexible deployment
- Integration with Visual Studio Code for development
- Support for AdventureWorks sample database
- Debugging capabilities with mcp-debug tool
Tools
get-databases-tool
List the available databases on SQL Server
get-database-schema-tool
Retrieve schema information for the specified database
execute-select-query-tool
Run parameterized SELECT query