AgentHubAgentHub

Devart MCP Server for PostgreSQL (AD… MCP Setup & Guide

MCP ServerMCP RegistryOfficial

com.devart/mcp-postgresql · v1.1.0

Schema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider.

Repository ↗

Copy the install config on this page first, then verify docs and permissions upstream.

Overview

Schema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider. Devart MCP Server for PostgreSQL (ADO.NET) is a MCP Server listed from MCP Registry. Transports: stdio. This page includes an overview, setup tutorial, install commands, and use cases for Trae, Tongyi Lingma, Cursor, Claude Code, and VS Code.

Use cases

Database tools

AgentHub Verified AvailabilityTested & Ready

Automated pipeline validated install commands, protocol & client compatibility

Verified At2026-10-04
Install Snippets TestedCLI & JSON config syntax verified
Protocol Handshake ReadyComplies with JSON-RPC 2.0 specifications
Origin Registry ActiveSourced from official-mcp-registry
Verified ClientsClaude Code、Claude Desktop、Cursor 等
Security Tier: A+ 级 · 官方认证推荐 (A+)·Maintained by official/verified teams, audited for standard MCP protocol compliance.
No auto-generated install guide — see the source repository README.

Troubleshooting & Common ErrorsFAQ

Common connection errors and verified fixes for Devart MCP Server for PostgreSQL (ADO.NET)

Getting 'connection closed' or exit code 1 in Cursor / Claude Code for Devart MCP Server for PostgreSQL (ADO.NET)?

Usually caused by missing runtime paths or IDE environment inheritance. Fix steps: 1. Verify Node.js 18+ (npx) or Python 3.10+ (uvx) is installed; 2. Run 'which npx' or 'which uvx' in terminal, and replace 'command' with absolute path; 3. Reload or restart the client window after modifying config.

Fix Snippet
# Check binary path in terminal:
which npx
node -v
Getting 'spawn npx ENOENT' or 'command not found'?

The editor background process does not inherit your full terminal PATH. Solution: Globally install the package, or set the absolute binary path (e.g. C:\Program Files\nodejs\npx.cmd on Windows, or /usr/local/bin/npx on macOS).

Missing required environment variable or authentication failure?

Devart MCP Server for PostgreSQL (ADO.NET) requires environment variables (DEVART_MCP_POSTGRESQL_CONNECTION). Ensure you have added valid keys under the 'env' object in your config file without trailing whitespace.

Fix Snippet
// .cursor/mcp.json 或 claude_desktop_config.json
{
  "env": {
    "DEVART_MCP_POSTGRESQL_CONNECTION": "your_actual_key_here"
  }
}
Still not connecting? Read the MCP troubleshooting guide →

Tool Mock Playground

Sandbox

Devart MCP Server for PostgreSQL (ADO.NET) Database Query Simulator · Preview tool schema & outputs without local runtime

Sandbox Ready
fn: execute_read_queryExecute SQL query and format rows safely
Request ArgumentsJSON Schema
{
  "query": "SELECT id, name, status, created_at FROM records WHERE status = 'active' LIMIT 3;"
}
💡Parameters generated dynamically by Agent runtime
Agent Tool Output

Click 'Run Mock' above

to preview the raw response returned to the LLM

Env: AgentHub Virtual SandboxJSON-RPC 2.0

Decision Guide: Why & When to Use

Assess suitability before installing to save trial-and-error time

Best Suited For
  • Dev data exploration
  • Read-only analytics SQL
  • Schema documentation
When NOT to Use
  • Unrestricted writes on production
  • Exposing raw PII to AI
Recommended Workflow Pairing:View Scenario →

Postgres MCP + SQL skill → conversational BI

MCP hands-on: install to visible results

Follow the full lab (expected UI/output + contrast checks). After installing this item, verify with the tutorial prompts.

Open tutorial →

Related resources

Often paired with

Keep exploring AgentHub

Most people compare similar tools or check scenario guides before installing—start here.

Browse more like thisSearch similarPick by scenarioPrompt playbooksMCP hands-onReviews & comparisons

Listing badge: put AgentHub on your site

Copy either snippet into your project homepage, docs, or GitHub README. The badge is a hotlinked SVG — nothing to host — and it links back to this page so visitors can find the install steps.

PreviewListed on AgentHub: Devart MCP Server for PostgreSQL (ADO.NET)
HTML
<a href="https://myagenthub.cn/p/com.devart/mcp-postgresql" title="Listed on AgentHub: Devart MCP Server for PostgreSQL (ADO.NET)" target="_blank" rel="noopener">
  <img src="https://myagenthub.cn/badge/com.devart/mcp-postgresql?lang=en" alt="Listed on AgentHub: Devart MCP Server for PostgreSQL (ADO.NET)" height="20" style="border:0"/>
</a>
Markdown (GitHub README)
[![Listed on AgentHub: Devart MCP Server for PostgreSQL (ADO.NET)](https://myagenthub.cn/badge/com.devart/mcp-postgresql?lang=en)](https://myagenthub.cn/p/com.devart/mcp-postgresql)

Badges are generated on the fly from /badge/<package-id>, so name and listing changes propagate automatically. Keep the link target unchanged — it is what counts as the referral.

Unified Manifest

{
  "id": "com.devart/mcp-postgresql",
  "type": "mcp-server",
  "version": "1.1.0",
  "displayName": "Devart MCP Server for PostgreSQL (ADO.NET)",
  "description": "Schema-aware read/write access to PostgreSQL through Devart dotConnect ADO.NET data provider.",
  "repository": {
    "url": "https://github.com/devart-ai-connectivity/devart-mcp-server-postgresql",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "nuget",
        "identifier": "Devart.Mcp.PostgreSql",
        "version": "1.1.0",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "DEVART_MCP_POSTGRESQL_CONNECTION",
            "description": "A dotConnect for PostgreSQL connection string.",
            "isRequired": true,
            "isSecret": true
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode",
    "trae",
    "cherry-studio",
    "lingma",
    "windsurf",
    "cline",
    "workbuddy"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "com.devart/mcp-postgresql",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/com.devart%2Fmcp-postgresql/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
Devart MCP Server for PostgreSQL (AD… MCP Setup - AgentHub