Dev Tools & GitMCP Registrynpm5 toolsA · 85

ainative-postgres-mcp

Name: ainative-postgres-mcp
Author: AINative-Studio

io.github.AINative-Studio · Updated 2mo ago

Zero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.

At a glance

ainative-postgres-mcp is an MCP server in the Dev Tools & Git category. It runs locally over stdio via `npx -y ainative-postgres-mcp`, and declares no required credentials. It exposes 5 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 ainative-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 ainative-postgres-mcp in Claude CodeAnthropic's agentic CLI

Add the server

bash

claude mcp add ainative-postgres-mcp -- npx -y ainative-postgres-mcp

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 ainative-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": {
    "ainative-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "ainative-postgres-mcp"
      ]
    }
  }
}

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

How to install ainative-postgres-mcp in CursorAI-first code editor

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

json

{
  "mcpServers": {
    "ainative-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "ainative-postgres-mcp"
      ]
    }
  }
}

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

How to install ainative-postgres-mcp in Codex CLIOpenAI coding agent

Add to ~/.codex/config.toml

toml

[mcp_servers.ainative-postgres-mcp]
command = "npx"
args = ["-y", "ainative-postgres-mcp"]

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

How to install ainative-postgres-mcp in WindsurfCodeium's agentic IDE

Edit ~/.codeium/windsurf/mcp_config.json

json

{
  "mcpServers": {
    "ainative-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "ainative-postgres-mcp"
      ]
    }
  }
}

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

How to install ainative-postgres-mcp in ClineVS Code autonomous agent

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

Add the server

json

{
  "mcpServers": {
    "ainative-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "ainative-postgres-mcp"
      ]
    }
  }
}

How to install ainative-postgres-mcp in VS CodeCopilot / MCP support

Create .vscode/mcp.json

json

{
  "servers": {
    "ainative-postgres-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "ainative-postgres-mcp"
      ]
    }
  }
}

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

What tools does ainative-postgres-mcp expose? (5)

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

queryExecute read-only SQL queries (runs in READ ONLY transaction)
list_tablesList all tables with schema, name, and type
describe_tableGet full table schema: columns, types, constraints, indexes
create_tableCreate a new table with SQL DDL
insertInsert rows into a table (returns inserted rows)

What the code can do

Read from the published package source — never executed. Parsed 1 of 1 source file.

This server can read and write files, make network requests 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 ainative-studio.

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 1 month ago — Actively maintained.
0 GitHub stars — Very little community usage so far.
220 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%99%
Last commit 34 days ago.
Adoption20%27%
0 stars, 220 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 (1.0.1).

Documentation

Full README

ainative-postgres-mcp

Zero-config PostgreSQL MCP server with auto-provisioning. Drop-in replacement for @modelcontextprotocol/server-postgres — no DATABASE_URL needed.

The official @modelcontextprotocol/server-postgres requires you to bring your own Postgres database and pass a connection string. This fork auto-provisions a managed PostgreSQL instance with pgvector on first run. Agents get a database instantly with zero configuration.

Quick Start

bash

npx ainative-postgres-mcp

That's it. On first run:

A free managed PostgreSQL instance is provisioned
pgvector extension is enabled automatically
Connection details are saved to ~/.ainative/postgres-config.json, .env, and .mcp.json
A claim URL is printed so you can take ownership of the database

MCP Configuration

Claude Code / Claude Desktop

Add to your claude_desktop_config.json or .mcp.json:

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "ainative-postgres-mcp"]
    }
  }
}

With existing database

json

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "ainative-postgres-mcp"],
      "env": {
        "DATABASE_URL": "postgresql://user:pass@host:5432/mydb"
      }
    }
  }
}

Cursor

Alternatives to ainative-postgres-mcp

Maintain ainative-postgres-mcp? Add a badge to your README

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

markdown

[![ainative-postgres-mcp on MCP Skills Hub](https://mcp-skills-hub.vercel.app/badge/io-github-ainative-studio-ainative-postgres-mcp)](https://mcp-skills-hub.vercel.app/mcps/io-github-ainative-studio-ainative-postgres-mcp)

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