mcp-sqlexpress

mcp-sqlexpress

3.3

If you are the rightful owner of mcp-sqlexpress and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.

The SQL Server Express MCP Server is designed to facilitate seamless interaction with Microsoft SQL Server Express instances. It supports both Windows and SQL Server authentication methods, providing flexibility in how users connect to their databases. The server requires Python 3.10 or higher and the Microsoft ODBC Driver 18 for SQL Server. Once set up, it allows users to execute a variety of database operations, including reading, writing, and managing tables. The server is particularly useful for developers and database administrators who need a reliable and efficient way to manage SQL Server Express databases.

Features

  • Supports both Windows and SQL Server authentication
  • Allows execution of SELECT, INSERT, UPDATE, and DELETE queries
  • Facilitates creation and management of database tables
  • Provides a list of accessible databases
  • Enables detailed schema descriptions of tables

Tools

  1. get_allowed_databases

    Get list of databases that are allowed to be accessed

  2. read_query

    Execute SELECT queries

  3. write_query

    Execute INSERT/UPDATE/DELETE queries

  4. create_table

    Create new tables

  5. list_tables

    List all tables in database

  6. describe_table

    Show table schema