Ainative Postgres MCP server

by AINative-Studio·io.github.AINative-Studio/ainative-postgres-mcp·v1.0.1

No reviews yet

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

A89/100grade A

Write a review Install

What users say

No reviews yet

Be the first

Safety scan

A89/100

full report

Adoption

Growing

0 stars281 downloads/wk

Reviews

Write one

Nobody has reviewed Ainative Postgres yet.

If you have run it, two minutes of your experience saves the next person an afternoon.

Ainative Postgres tools (5, 3 write)

write = sends, deletes, buys or posts

Read from the package source without running it. The installed server may list more.

create_tablewrite action
Create a new table in the database using a SQL CREATE TABLE statement. Supports all PostgreSQL column types including pgvector vector columns.
describe_table
Get the full schema of a table including columns (name, type, nullable, default), constraints (primary key, foreign key, unique), and indexes. Supports schema.table format.
insertwrite action
Insert one or more rows into a table. Rows are provided as an array of objects where keys are column names. Returns the inserted rows.
list_tables
List all tables in the connected PostgreSQL database, including schema, table name, and type (BASE TABLE or VIEW).
querywrite action
Execute a read-only SQL query against the connected PostgreSQL database. All queries run inside a READ ONLY transaction for safety. Use this for SELECT, EXPLAIN, and other read operations.

Public scan report

scanner v0.1.10 · 2026-11-05 · same rubric, same numbers if you re-run it

no findings

Code scan2 source files scanned25/25
–Live reliabilityno gateway calls yet and no remote to proben/a
–Tool poisoningtools not inspected (local package is not executed); not countedn/a
Auth qualitylocal package, no credentials required12/15
Maintenancelast push 41 days ago12/15
Maintainer identityregistry namespace matches repository owner; GitHub account older than a year9/10

Overall 89/100. Components that don't apply are left out of the denominator. Any critical finding is an F.Rubric Appeal a finding JSON

How Ainative Postgres compares

Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.

Safety score: 89/100; higher than 80% of 802 Databases servers
Tools: 5; the typical Databases server has 10
Tools that change things: 60%; typical: 7%. Fewer write tools means less an agent can break
Downloads a week: 281; more than 69% of 411 Databases servers with a package

What its tools let an agent do: 2 read · 2 create · 1 change

Install Ainative Postgres in Claude Code, Cursor or VS Code

Runs npx -y ainative-postgres-mcp on your machine. Read the scan report first; the gateway never runs local packages.

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

Add to Cursor

What the publisher says

From the Ainative Postgres repository's README, as published. We do not edit it. Read it on GitHub

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

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 claudedesktopconfig.json or .mcp.json:

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

With existing database

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

Cursor

Add to .cursor/mcp.json:

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

Windsurf

Add to ~/.windsurf/mcp.json:

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

Tools

Comparison with official server-postgres

How Auto-Provisioning Works

Start
  |
  v
DATABASE_URL set? ----yes----> Connect directly
  |
  no
  v
~/.ainative/postgres-config.json exists? ----yes----> Load and connect
  |
  no
  v
.mcp.json has DATABASE_URL? ----yes----> Load and connect
  |
  no
  v
POST /api/v1/public/instant-db   (get API key)
  |
  v
POST /api/v1/zerodb/postgres/provision   (get Postgres)
  |
  v
Save to ~/.ainative/postgres-config.json + .env + .mcp.json
  |
  v
Connect and enable pgvector

pgvector Support

pgvector is automatically enabled on provisioned instances. You can use vector columns in your tables:

CREATE TABLE documents (
  id SERIAL PRIMARY KEY,
  content TEXT,
  embedding vector(1536)
);

And run similarity searches:

SELECT content, embedding <=> '[0.1, 0.2, ...]'::vector AS distance
FROM documents
ORDER BY distance
LIMIT 10;

Environment Variables

Free Tier

Shortened. The full README is on GitHub.

Nothing above is checked by us. What we check is on the safety report.

Ainative Postgres: common questions

Is Ainative Postgres MCP server safe?: Yes, by our scan: it is graded A (89/100). Read the Ainative Postgres safety report
How do I install Ainative Postgres?: It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
Does Ainative Postgres need an API key?: Not as far as the registry entry and our scan can tell: no credentials are declared or required.
Is Ainative Postgres maintained?: The last commit was 52 days ago (2026-09-25). The latest release is v1.0.1.
What can I use instead of Ainative Postgres?: Servers from other publishers that do the same job: Gnosis MCP server, Appwrite MCP server and Ekwo OS — open source accounting: ledger, invoices and VAT on your own Supabase or Postgres MCP server.
How does Ainative Postgres compare with other Databases MCP servers?: safety score 89/100 (higher than 80% of 802 Databases servers); tools 5 (the typical Databases server has 10); tools that change things 60% (typical: 7%. Fewer write tools means less an agent can break). Full comparison.

Alternatives to Ainative Postgres

Same job from other publishers: the closest match first, then the best rated.

Gnosis MCP
Zero-config MCP server for searchable documentation. SQLite or PostgreSQL.
not reviewed
Growing
A
Appwrite
Build and deploy backends: auth, Postgres/MySQL/vector databases, storage, functions, hosting, CDN
not reviewed
Established
A
Ekwo OS — open source accounting: ledger, invoices and VAT on your own Supabase or Postgres
Double-entry books an agent keeps as the user: invoices, VAT returns, 174 country packs.
not reviewed
Established
A
Run402
x402 pay-per-call infra for agents: $0.03 image generation, Postgres, auth, storage, functions.
not reviewed
Established
A
Neon
Official Neon MCP server for managing Neon projects and Lakebase Postgres databases.
not reviewed
Established
A