What parameters are required to execute a query?

You must provide either a connection string OR the host, username, and password, along with the SQL query you want to execute.

Does Mssql support encryption?

Yes, Mssql supports encryption via the `encrypt` option. You can also choose to trust the server certificate.

Mssql is a tool that allows you to connect to Microsoft SQL Server databases and execute SQL queries. It supports various connection methods and security options.

How do I connect to my MSSQL database?

You can connect either using a full connection string or by providing individual parameters such as host, port, database, username, and password.

Is Mssql free to use?

Yes, Mssql is free to use and distributed under the MIT license.

Mssql

Name: Mssql
Author: MCP-Mirror

0•

Connects to Microsoft SQL Server databases and executes SQL queries.

The MSSQL Model Context Protocol (MCP) Server facilitates interaction with Microsoft SQL Server databases. It offers a 'query' tool that allows users to execute SQL queries against a specified database, configurable via connection string or individual connection parameters. This server is designed to integrate seamlessly with MCP environments, providing a streamlined way to manage and query MSSQL databases.

主な機能

01Supports connection via connection string or individual parameters

02Integrates with MCP environments

03Supports encryption and trust server certificate options

040 GitHub stars

05Executes SQL queries

06Configurable connection parameters (host, port, database, user, password)

ユースケース

01Executing ad-hoc SQL queries against an MSSQL database

02Integrating MSSQL database queries into other applications

03Automating database interactions within an MCP workflow