PostgreSQL MCP

A hosted MCP server that allows AI agents to safely interact with PostgreSQL databases. It provides 8 actions including reading table metadata, schemas, and health reports, as well as executing SQL queries. It supports various AI clients like Claude, ChatGPT, and Cursor without requiring local installation.

Visit InsightfulPipe

Endpoint and access

OAuth sign-in: the first time you connect, your client opens the vendor's own authorization prompt in a browser.

Vendor evidenceStreamable HTTPOAuth sign-inEndpoint checked 2026-11-01Operated by InsightfulPipe

You need:sign in with your InsightfulPipe account if askedsign in to InsightfulPipe if asked, and click Authorize access on the Grant access pageClick Connect , sign in to InsightfulPipe if asked, and click Authorize access on the Grant access page

MCP endpoint (Streamable HTTP)

https://postgresql.insightfulmcp.com/

Vendor documentation

What you can do with it

Explore unfamiliar database schemas and tables
Answer business questions by generating and running SQL queries
Tune slow queries by analyzing EXPLAIN plans and pg_stat_statements
Report on database health metrics like connections and cache hit rates

Source and maintenance

Vendor evidenceRegistry 1.0.0

mcp-registry: com.insightfulpipe/postgresql@1.0.0 Source repository Project website

Maintenance checked: Nov 1, 2026, 8:12 AM UTC

Tools

Reported by the attributed source; not independently observed by Koskamo.

No tool definitions available.

30-day availability

Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.

Successful checks: 1 of 1 (100%)
Average latency: 319 ms
95th percentile latency: 319 ms

Maintenance history

Public check and source-refresh events. Editorial and ownership records remain private.

Nov 1, 2026, 8:38 AM UTC · probe · passed · 319 ms · metadata changed · refuses unauthenticated initialize (HTTP 401)

Connect from your client

Each snippet registers the same endpoint; pick the client you use.

This server is operated by the named third party. Listing and endpoint checks are not an endorsement or a security audit. Review the operator's permissions, terms, and data handling before connecting. How listings are checked and corrected.

Claude Code

Run this once in a terminal. It registers the remote server. Use --scope project to write .mcp.json for the repo.

Claude Code configuration

claude mcp add --transport http postgresql-mcp https://postgresql.insightfulmcp.com/

Codex

Run this once. Codex stores MCP servers in ~/.codex/config.toml (or .codex/config.toml in a trusted project).

Codex configuration

codex mcp add postgresql-mcp --url https://postgresql.insightfulmcp.com/

Cursor

Merge this server into .cursor/mcp.json in your project, then enable postgresql-mcp in your MCP settings.

Cursor configuration

{
  "mcpServers": {
    "postgresql-mcp": {
      "url": "https://postgresql.insightfulmcp.com/"
    }
  }
}

Cline

Merge this into cline_mcp_settings.json (Cline → MCP Servers → Configure).

Cline configuration

{
  "mcpServers": {
    "postgresql-mcp": {
      "type": "streamableHttp",
      "url": "https://postgresql.insightfulmcp.com/",
      "disabled": false
    }
  }
}

VS Code

Merge this server into .vscode/mcp.json. Use MCP: List Servers to start postgresql-mcp and inspect its tools.

VS Code configuration

{
  "servers": {
    "postgresql-mcp": {
      "type": "http",
      "url": "https://postgresql.insightfulmcp.com/"
    }
  }
}

Gemini CLI

Run this once. It writes .gemini/settings.json in the current project; pass --scope user for ~/.gemini/settings.json.

Gemini CLI configuration

gemini mcp add --transport http postgresql-mcp https://postgresql.insightfulmcp.com/

Claude Desktop

Merge this into claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/, Windows: %APPDATA%\Claude\), then restart Claude Desktop.

Claude Desktop configuration

{
  "mcpServers": {
    "postgresql-mcp": {
      "url": "https://postgresql.insightfulmcp.com/"
    }
  }
}

Windsurf

Merge this into ~/.codeium/windsurf/mcp_config.json, then refresh MCP in Cascade. Windsurf remote servers use serverUrl, not url.

Windsurf configuration

{
  "mcpServers": {
    "postgresql-mcp": {
      "serverUrl": "https://postgresql.insightfulmcp.com/"
    }
  }
}

Let your agent find its tools

Find servers like PostgreSQL MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.

Connect Koskamo Explore workflows

See all 4,443

Do you run PostgreSQL MCP?

Prove ownership with a DNS record, a well-known file, or your Official MCP Registry entry, and your edits publish immediately. Proofs are re-checked weekly; admins can still hide or remove a listing.

Claim this listing