Multi-database-sql-mcp-server
by akkki98
Overview
Provides a Model Context Protocol (MCP) server for AI assistants and applications to interact with multiple Azure SQL databases.
Installation
dotnet runEnvironment Variables
- AZURESQL_DB1_CONN
- AZURESQL_DB2_CONN
Security Notes
The `run_query` tool accepts raw SQL queries as a string. While the documentation strongly recommends using parameterized queries to prevent SQL injection, the truncated source code does not provide the concrete implementation of `ToolHandlers.cs` or `DatabaseManager.cs`. Without this, there is a significant potential for SQL injection if the queries are not properly parameterized and sanitized internally. The project explicitly states it is a 'development/demonstration project' and warns about implementing 'additional security measures' for production use. Hardcoded secrets are generally avoided by using environment variables for connection strings.
Similar Servers
mcp-kql-server
An AI-powered MCP server that facilitates KQL query execution against Azure Data Explorer through natural language conversion, intelligent schema discovery, and RAG-enhanced context.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.
jewei-mssql-mcp-server
Provides a Micro-Agent Protocol (MCP) server for querying Microsoft SQL Server databases and retrieving table structures.
photons
A comprehensive demonstration MCP server showcasing various functionalities of the Photon runtime, including basic data handling, streaming responses, progress reporting, in-memory state management, and interactive UI elements. It serves as a reference for developers building new photons.