Postgres MCP vs MCP Server Motherduck
A side-by-side look at the Postgres MCP and MCP Server Motherduck MCP servers: transport, auth, tools, quality signals, and the config to install either one in Claude, Cursor, Windsurf or VS Code.
Verdict: choose Postgres MCP for databases work as a local process; choose MCP Server Motherduck 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 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.
Choose MCP Server Motherduck when
- You need dedicated capabilities in the Databases domain.
- You prefer a local stdio subprocess transport.
- You want tools like
execute_query, list_databases, list_tables.
Feature & specification comparison
Rows where the two servers differ are marked.
| Spec | ||
|---|---|---|
| Category | Databases | Databases |
| Quality signal | 60/100 · Good | 56/100 · Good |
| Install command | Confirmed | Confirmed |
| Transport | Local subprocess (stdio) | Local subprocess (stdio) |
| Auth | other | Not declared |
| Pricing | Free | Not declared |
| Required env vars | POSTGRES_USERPOSTGRES_PASSWORDPOSTGRES_DB | None listed |
| Verified owner | Community listing | Community listing |
| GitHub stars | 12 | 534 |
| Directory activity | 4 views 0 installs 0 upvotes | 3 views 0 installs 0 upvotes |
| Tools | 15 | 4 |
| Full listing | View Postgres MCP | View MCP Server Motherduck |
Tools & capabilities
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
MCP Server Motherduck tools 4
execute_queryExecute SQL query (DuckDB dialect)list_databasesList all databases (useful for MotherDuck or multiple attached DBs)list_tablesList tables and viewslist_columnsList columns of a table/view
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.
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"
}
}
}
}
MCP Server Motherduck
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}
Frequently asked questions
Postgres MCP is categorized under Databases and uses a local stdio subprocess. MCP Server Motherduck belongs to Databases and uses a local stdio subprocess. Pick Postgres MCP for databases work and MCP Server Motherduck 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.
Postgres MCP is listed as free. Auth: other. MCP Server Motherduck has no declared pricing — check the project's own site. 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 javimaligno-postgres-mcp and mcp-server-motherduck as separate keys in the same mcpServers object, and your assistant will call tools from either one.
On AllMCPs, Postgres MCP has a quality signal of 60/100 (Good) with 4 views, 0 installs and 12 GitHub stars. MCP Server Motherduck has 56/100 (Good) with 3 views, 0 installs and 534 GitHub stars.