mcp-sqlexpress

mcp-sqlexpress

2
databases

This project is an MCP server facilitating interaction with Microsoft SQL Server Express, supporting both Windows and SQL Server authentication methods. It provides several tools for database management, including querying and table manipulation capabilities.

SQL Server Express MCP Server

An MCP server designed for interacting with Microsoft SQL Server Express, featuring support for Windows and SQL Server authentication.

Prerequisites

  • Python 3.10 or higher
  • Microsoft ODBC Driver 18 for SQL Server
  • SQL Server instance with appropriate permissions

Features

  • get_allowed_databases: Retrieve allowed databases
  • read_query: Execute SELECT queries
  • write_query: Perform INSERT/UPDATE/DELETE queries
  • create_table: Create new tables
  • list_tables: List all database tables
  • describe_table: Display table schema