An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication.
An MCP server for interacting with Microsoft SQL Server Express. Supports Windows and SQL Server authentication. That is what the mcp sqlexpress mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.
The server publishes 7 tools. What each one is for:
get_allowed_databases — Get list of databases that are allowed to be accessedread_query — Execute SELECT querieswrite_query — Execute INSERT/UPDATE/DELETE queriescreate_table — Create new tableslist_tables — List all tables in databasedescribe_table — Show table schemaTools — The Tools tool exposed by this serverSetup follows the usual MCP pattern — install or clone the server, register it in your client's configuration file, restart the client.
Among the database access options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. MCP Sqlexpress's toolset — get_allowed_databases, read_query, write_query and 4 more — is a fair guide to whether it matches your workflow. It is maintained by hanweg; worth a glance at recent repository activity before you build anything load-bearing on it.
This entry was verified against MCP Sqlexpress's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.
| Tool | What it does |
|---|---|
| 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 |
| Tools | The Tools tool exposed by this server. |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.