소개
This robust .NET Core client for Microsoft SQL Server implements the Model Context Protocol (MCP), offering extensive database interaction capabilities. It allows users to execute SQL queries, manage stored procedures, list tables, and retrieve detailed schema information, all through a standardized MCP interface. Designed to be lightweight yet powerful, the server can operate in either a database-specific context or provide server-wide operations across all databases, and supports deployment directly or via Docker containers.
주요 기능
- Operates in Database or Server-wide modes with configurable security for tool enablement.
- Export and import table data in CSV format.
- Execute SQL queries and manage stored procedures with granular control.
- 2 GitHub stars
- Support for paginated and streaming query results.
- Discover and retrieve detailed schema for tables, indexes, views, and functions.
사용 사례
- Automating database administration tasks such as schema discovery, data export, and script execution.
- Providing a secure and standardized interface for AI agents or external systems to interact with SQL Server databases.
- Integrating SQL Server database functionality into applications via the Model Context Protocol.