Databases & StorageMCP Registrynpm3 toolsA · 85

Kaiva Postgres MCP

ai.kaiv · Updated 8d ago

Read-only PostgreSQL MCP server. Drop-in replacement for the archived server-postgres.

At a glance

Kaiva Postgres MCP is an MCP server in the Databases & Storage category. It runs locally over stdio via `npx -y @kaiva/postgres-mcp <database_url>`, and declares no required credentials. It exposes 3 tools, including query, list_tables and describe_table. It scores A (85/100) on the MCP Skills Hub health score as of Oct 28, 2026.

Source 0

One-click install

VS Code VS Code Insiders Cursor

Opens your editor and pre-fills the config. Your editor will ask before adding it.

How to install Kaiva Postgres MCP in your AI client

Setup for Claude Code, Claude Desktop, Cursor, Codex, Windsurf, Cline and VS Code — copy-paste ready.

How to install Kaiva Postgres MCP in Claude CodeAnthropic's agentic CLI

Add the server

bash

claude mcp add postgres -- npx -y @kaiva/postgres-mcp '<database_url>'

2
Verify it's connected
bash
```
claude mcp list
```
Sharing it with your team?
Add `--scope project` to write it to .mcp.json in the repository root, which you can commit (with the secrets left as environment variables).
Use it in a session
Ask Claude to use the tools this server exposes (e.g. query, list_tables, describe_table). It discovers them automatically.

How to install Kaiva Postgres MCP in Claude DesktopDesktop app (MCP config)

Open your MCP config
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

Add this server

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@kaiva/postgres-mcp",
        "<database_url>"
      ]
    }
  }
}

Restart Claude Desktop
The tools appear under the 🔌 menu once the app reloads.

How to install Kaiva Postgres MCP in CursorAI-first code editor

Create / edit .cursor/mcp.json in your project

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@kaiva/postgres-mcp",
        "<database_url>"
      ]
    }
  }
}

Enable it
Cursor Settings → MCP → toggle the server on. Tools become available to the Composer/Agent.

How to install Kaiva Postgres MCP in Codex CLIOpenAI coding agent

Add to ~/.codex/config.toml

toml

[mcp_servers.postgres]
command = "npx"
args = ["-y", "@kaiva/postgres-mcp", "<database_url>"]

Run Codex
Codex loads MCP servers from config.toml on startup and exposes their tools to the agent.

How to install Kaiva Postgres MCP in WindsurfCodeium's agentic IDE

Edit ~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@kaiva/postgres-mcp",
        "<database_url>"
      ]
    }
  }
}

Reload
Windsurf → Cascade → refresh MCP servers. Cascade can now call the tools.

How to install Kaiva Postgres MCP in ClineVS Code autonomous agent

Open Cline → MCP Servers → Configure
Adds to cline_mcp_settings.json.

Add the server

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@kaiva/postgres-mcp",
        "<database_url>"
      ]
    }
  }
}

How to install Kaiva Postgres MCP in VS CodeCopilot / MCP support

Create .vscode/mcp.json

json

{
  "servers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@kaiva/postgres-mcp",
        "<database_url>"
      ]
    }
  }
}

Start it
VS Code shows a ▶ Start action above the server entry. Agent mode (Copilot Chat) can then use the tools.

What tools does Kaiva Postgres MCP expose? (3)

Taken from the project's README — the server itself was not queried, so check its docs for the exact schemas.

queryrun one read-only SQL statement (`SELECT`, `WITH`, `VALUES`, `TABLE`, `SHOW` or
list_tablesthe tables and views this login can read, with type, estimated row count and
describe_tableone table's columns, primary key, unique and foreign keys, the tables that

What the code can do

Read from the published package source — never executed. Parsed 8 of 8 source files.

This server can read and write files and read your environment variables.

How it was published

No provenance attestation — there is nothing linking this published artifact to a specific source commit.
1 npm maintainer — a single point of compromise · last published by kaiva.

Maintainer of this package and think something here is wrong? Tell us and we'll correct it.

Before you install

Signals gathered from the source repo and package registry — not a safety verdict.

What it can reach

Runs code on your machine — Executes as a local process with your user's permissions, including filesystem access.
Downloads at launch — The package is fetched from its registry each run unless you pin a version.

Last commit 9 days ago — Actively maintained.
Repository created 9 days ago — Very new project with little track record yet.
0 GitHub stars — Very little community usage so far.
194 weekly downloads — Regularly installed by other developers.

Client compatibility

Claude Code: NativeClaude Desktop: NativeCursor: NativeCodex CLI: NativeWindsurf: NativeCline: NativeVS Code: Native

Health score

A · 85

Maintenance, adoption, transparency and packaging — not a safety audit. How this is calculated

Maintenance30%100%
Last commit 9 days ago.
Adoption20%27%
0 stars, 194 weekly downloads.
Transparency20%100%
4/4: ✓ public source repo, ✓ declared license, ✓ documentation, ✓ discoverable tool list.
Provenance15%100%
Package and registry entry point at the same repository.
Packaging15%100%
Publishes a pinned version (0.1.1).

Documentation

Full README

Kaiva Postgres MCP

The Postgres MCP server that stays read-only. A drop-in replacement for the archived @modelcontextprotocol/server-postgres.

Switch in one line

Where your AI client starts the archived server today:

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"]
    }
  }
}

change the package name:

json

      "args": ["-y", "@kaiva/postgres-mcp", "postgresql://localhost/mydb"]

In Claude Code:

claude mcp add postgres -- npx -y @kaiva/postgres-mcp postgresql://localhost/mydb

The query tool, its sql input and the table schema resources are the same, so nothing else changes.

Other ways in, with DATABASE_URL set in your environment:

Claude Code plugin: /plugin install postgres-mcp --marketplace ai-kaiva/postgres-mcp
Gemini CLI extension: gemini extensions install https://github.com/ai-kaiva/postgres-mcp, then

gemini extensions config kaiva-postgres-mcp to enter the database URL

Docker: docker run -i --rm -e DATABASE_URL ghcr.io/ai-kaiva/postgres-mcp once the image is published

Excerpt — the full document is on GitHub.

Alternatives to Kaiva Postgres MCP

Maintain Kaiva Postgres MCP? Add a badge to your README

Shows its health grade, and links readers to install steps for every client.

markdown

[![Kaiva Postgres MCP on MCP Skills Hub](https://mcp-skills-hub.vercel.app/badge/ai-kaiv-postgres)](https://mcp-skills-hub.vercel.app/mcps/ai-kaiv-postgres)

Catalog data refreshed Oct 28, 2026. Something wrong? Report it.