Mssql MCP vs Postgres MCP
A side-by-side look at the Mssql MCP and Postgres MCP MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Mssql MCPDatabases · Local subprocess (stdio)A Model Context Protocol (MCP) server for Microsoft SQL Server, built in C#/.NET 10. Lets AI agents (Claude Desktop, Cursor, etc.) safely query and interact with SQL Server databases through a controlled tool surface.61GoodAuth: otherVerdict: choose Mssql MCP for databases work as a local process; choose Postgres MCP for databases as a local process. You can also run both side by side in one mcpServers block.
Which MCP server should you choose?
Choose Mssql MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
MSSQL_CONNECTION_STRING. - You want tools like
list_databases, list_schemas, list_objects.
Choose Postgres MCP when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- Its auth model fits you: other.
- You have the keys it needs:
POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB. - You want tools like
query, execute, explain_query.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | Mssql MCP | |
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 61/100 · Good | 60/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | other |
| Pricing | Free | Free |
| Required env vars | MSSQL_CONNECTION_STRING | POSTGRES_USERPOSTGRES_PASSWORDPOSTGRES_DB |
| Verified owner | Community listing | Community listing |
| GitHub stars | 6 | 12 |
| Directory activity | 0 views 0 installs 0 upvotes | 4 views 0 installs 0 upvotes |
| Tools | 9 | 15 |
| Full listing | View Mssql MCP | View Postgres MCP |
Tools & capabilities
Mssql MCP tools 9
list_databasesList all databases with an `is_current` flag (system DBs excluded).list_schemasList schemas in the current or specified database.list_objectsList tables/views/procedures/functions with schema, type, and limit filters (default 1000).get_object_detailsReturn columns, parameters, indexes, and triggers for a specific object.execute_sqlExecute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.explain_queryShow the execution plan summary (or raw XML) without executing the query.analyze_indexesMissing-index analysis from `sys.dm_db_missing_index_*` DMVs (workload-wide or per-query).get_top_queriesTop queries by CPU/duration/reads from `sys.dm_exec_query_stats`.analyze_db_healthSummary health check: size, VLFs, fragmentation, stats staleness, blocking.
Postgres MCP tools 15
queryExecute read-only SQL queries against the databaseexecuteExecute write operations (INSERT/UPDATE/DELETE) when enabledexplain_queryGet EXPLAIN plan for query optimizationlist_schemasList all schemas in the databaselist_tablesList tables in a specific schemadescribe_tableGet table structure (columns, types, constraints)list_viewsList views in a schemadescribe_viewGet view definition and columnslist_functionsList functions and procedurestable_statsGet table statistics (row count, size, bloat)list_indexesList indexes for a tablelist_constraintsList constraints (PK, FK, UNIQUE, CHECK)- +3 more on the listing page
Ready-to-paste client configs
Paste either block (or both) into your client config, e.g. claude_desktop_config.json or ~/.cursor/mcp.json. We only show a config when the install command is confirmed.
Mssql MCP
{
"mcpServers": {
"codegiveness-mssql-mcp": {
"command": "npx",
"args": [
"-y",
"@codegiveness/mssql-mcp"
],
"env": {
"MSSQL_CONNECTION_STRING": "YOUR_MSSQL_CONNECTION_STRING_HERE"
}
}
}
}
Postgres MCP
{
"mcpServers": {
"javimaligno-postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@javiagui/postgresql-mcp"
],
"env": {
"POSTGRES_USER": "YOUR_POSTGRES_USER_HERE",
"POSTGRES_PASSWORD": "YOUR_POSTGRES_PASSWORD_HERE",
"POSTGRES_DB": "YOUR_POSTGRES_DB_HERE"
}
}
}
}
Frequently asked questions
Mssql MCP is categorized under Databases and uses a local stdio subprocess. Postgres MCP belongs to Databases and uses a local stdio subprocess. Pick Mssql MCP for databases work and Postgres MCP for databases.
Copy the mcpServers block from the config section on this page into your client's config (for example claude_desktop_config.json or ~/.cursor/mcp.json), then fully restart the client.
Mssql MCP is listed as free. Auth: other. Postgres MCP is listed as free. Auth: other. If a server needs environment variables such as API keys, define them under the env key in your client's MCP config.
Yes. MCP clients support multiple servers: add codegiveness-mssql-mcp and javimaligno-postgres-mcp as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Mssql MCP has a quality signal of 61/100 (Good) with 0 views, 0 installs and 6 GitHub stars. Postgres MCP has 60/100 (Good) with 4 views, 0 installs and 12 GitHub stars.