mssql-mcp

Overview

The mssql-mcp server provides database interaction capabilities through well-defined tools for reading and writing data, creating tables, and retrieving schema information. It also includes a unique business intelligence feature that can automatically generate insight memos based on data analysis. The implementation uses pyodbc for database connectivity and includes proper configuration options for different MCP clients.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• read_query

  Execute SELECT queries to read data from the database

  Try:Show me all customers from the databaseTry:What are the top 10 products by sales?Try:Find all orders placed in the last month
• write_query

  Execute INSERT, UPDATE, or DELETE queries

  Try:Add a new customer to the customers tableTry:Update the price of product XTry:Delete all orders older than a year
• create_table

  Create new tables in the database

  Try:Create a new inventory table with columns for product_id and quantityTry:Set up a user activity tracking tableTry:Make a new sales summary table
• list_tables

  Get a list of all tables in the database

  Try:What tables are available in this database?Try:Show me all the tablesTry:List all database tables
• describe-table

  View schema information for a specific table

  Try:Describe the structure of the customers tableTry:What columns are in the products table?Try:Show me the schema of the orders table
• append_insight

  Add new business insights to the memo resource

  Try:Add insights about Q3 sales performanceTry:Record findings about customer churnTry:Add observations about market trends

Comparable tools

Installation

{
  "mcpServers": {
    "mssql": {
      "command": "python",
      "args": ["/path/to/mssql-mcp/src/server.py"]
    }
  }
}```

FAQ

What SQL Server versions are supported?

The server uses ODBC Driver 17 for SQL Server, which supports SQL Server 2008 and later versions.

Can this server be used with other database systems?

This implementation is specifically designed for MSSQL. The README mentions it was adapted from an SQLite example.

Compare mssql-mcp with