mcp-sqlexpress
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
get_allowed_databases
Get list of databases that are allowed to be accessed
read_query
Execute SELECT queries
write_query
Execute INSERT/UPDATE/DELETE queries
create_table
Create new tables
list_tables
List all tables in database
describe_table
Show table schema