Ainative Postgres Mcp

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:

1. A free managed PostgreSQL instance is provisioned
2. pgvector extension is enabled automatically
3. Connection details are saved to ~/.ainative/postgres-config.json, .env, and .mcp.json
4. 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:

{  "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  |  vDATABASE_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  vPOST /api/v1/public/instant-db   (get API key)  |  vPOST /api/v1/zerodb/postgres/provision   (get Postgres)  |  vSave to ~/.ainative/postgres-config.json + .env + .mcp.json  |  vConnect 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 distanceFROM documentsORDER BY distanceLIMIT 10;

Environment Variables

Free Tier

Auto-provisioned instances include:

• Managed PostgreSQL with pgvector
• Shared compute (suitable for development and light production)
• Automatic backups
• SSL encryption

Sign up at ainative.studio to claim your instance and unlock higher limits.

License

MIT

Powered by ZeroDB + AINative

This package is part of the AINative ecosystem — the AI-native developer platform.

Why ZeroDB?

Get Started Free

npx zerodb-cli init    # Auto-configures your IDE

Or sign up at ainative.studio — free tier, no credit card required.

View all ZeroDB packages →

Zero-Config Auto-Provisioning

No account needed to start. On first run, this package automatically:

1. Provisions a free ZeroDB instance (~800ms)
2. Saves credentials locally (.env, .mcp.json)
3. Prints a claim link in your terminal

The 72-Hour Window

Your auto-provisioned instance is free for 72 hours. To keep your data permanently, visit the claim URL printed in your terminal.

For AI Agents

If a coding agent (Claude Code, Cursor, Windsurf) installs this package:

• Auto-provisions without human intervention
• The claim URL appears in agent output — visit it to take ownership
• .claude/CLAUDE.md instructs agents to surface the claim link to you
• Check .env or ~/.ainative/config.json for your project ID if you miss it