SQL-AI-samples
SQL-AI-samples copied to clipboard
Azure-Samples
Samples using AI and Azure SQL DB
Problem Statement Currently, the MCP server only supports a single authentication method at a time (either Azure AD or SQL Authentication), and can only connect to one database per server...
## Summary This PR adds comprehensive authentication documentation and enhances the MCP server to support multiple authentication methods for connecting to MSSQL databases. ## Changes Made ### Documentation (README.md) -...
Many MCP servers implement streamable HTTP endpoints so that agents can connect across devices. I think it would be wise to implement this here as well.
It would be great if we can have a guide for using it in VS2022. Been struggling with enabling to use with VS2022.
I see no way to connect MCP on the locally served database. It always opens azure login, which makes this MCP useless.
# Summary: This pull request introduces the implementation of an MCP (Model Control Protocol) Server in Python. The server provides the core functionalities required to handle incoming requests, process responses,...
Hi How do we circumvent this behaviour, this is not required for windows or sql authentication. Thanks
Is there a way to enable the SQL Authentication in the Node version for the MSSQL MCP? Instead of Over Entra?
dotnet changes: - Add CRITICAL security restrictions and sanitization to C# per the TS - Implement READONLY property on the MCP like we have in NODE
Hello and thanks for MSSQL MCP, it's a really useful tool. It'd be nice to see more tools added, beyond CRUD. In particular, Stored Procedures calling/metadata retrieval. This would allow...
