SQL Server Express
Summary
This MCP server implementation provides a bridge to Microsoft SQL Server Express, enabling AI assistants to interact with SQL databases. Developed by hanweg, it offers tools for executing SELECT, INSERT, UPDATE, and DELETE queries, as well as creating tables and describing database schemas. The server supports both Windows and SQL Server authentication, with configurable database access restrictions. Built using Python and pyodbc, it's designed for easy integration into Claude Desktop environments. The implementation focuses on secure database interactions and is particularly useful for AI applications requiring data analysis, reporting, or automated database management tasks within Microsoft SQL Server ecosystems.
Available Actions(6)
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 the database.
describe_table
Show table schema.
社区评论
暂无评论. 成为第一个评论的人!
登录以参与讨论