Zero-config Postgres MCP with auto-provisioning — drop-in for server-postgres.
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.
npx ainative-postgres-mcp
That's it. On first run:
~/.ainative/postgres-config.json, .env, and .mcp.jsonAdd to your claude_desktop_config.json or .mcp.json:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "ainative-postgres-mcp"]
}
}
}
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "ainative-postgres-mcp"],
"env": {
"DATABASE_URL": "postgresql://user:pass@host:5432/mydb"
}
}
}
}
Add to .cursor/mcp.json:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "ainative-postgres-mcp"]
}
}
}
Add to ~/.windsurf/mcp.json:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["-y", "ainative-postgres-mcp"]
}
}
}
| Tool | Description |
|---|---|
query | Execute read-only SQL queries (runs in READ ONLY transaction) |
list_tables | List all tables with schema, name, and type |
describe_table | Get full table schema: columns, types, constraints, indexes |
create_table | Create a new table with SQL DDL |
insert | Insert rows into a table (returns inserted rows) |
| Feature | @modelcontextprotocol/server-postgres | ainative-postgres-mcp |
|---|---|---|
| Read queries | Yes | Yes |
| Write queries | No | Yes (create_table, insert) |
| Schema inspection | Via resources | Via describe_table tool |
| Table listing | No | Yes (list_tables) |
| Auto-provisioning | No | Yes |
| pgvector | Manual setup | Auto-enabled |
| Zero config | No (requires DATABASE_URL) | Yes |
| Free tier | N/A | Yes |
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 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;
| Variable | Description | Required |
|---|---|---|
DATABASE_URL | PostgreSQL connection string | No (auto-provisioned if missing) |
ZERODB_API_KEY | ZeroDB API key (for provisioning) | No (auto-created) |
ZERODB_PROJECT_ID | ZeroDB project ID | No (auto-created) |
ZERODB_API_URL | ZeroDB API base URL | No (defaults to https://api.ainative.studio) |
Auto-provisioned instances include:
Sign up at ainative.studio to claim your instance and unlock higher limits.
MIT
This package is part of the AINative ecosystem — the AI-native developer platform.
| Feature | ZeroDB | Others |
|---|---|---|
| Vector search | Built-in, free embeddings | Separate service (Pinecone, Qdrant) |
| Agent memory | Cognitive memory with decay + reflection | DIY or Mem0 ($$$) |
| File storage | S3-compatible, included | Separate S3 bucket |
| NoSQL tables | Instant, schema-free | MongoDB Atlas, DynamoDB |
| PostgreSQL | Managed, pgvector pre-installed | Neon, Supabase ($$$) |
| Serverless functions | DB-event triggered | Firebase/Supabase Edge |
| Pricing | Free tier, no credit card | Pay-per-query from day 1 |
npx zerodb-cli init # Auto-configures your IDE
Or sign up at ainative.studio — free tier, no credit card required.
No account needed to start. On first run, this package automatically:
.env, .mcp.json)Your auto-provisioned instance is free for 72 hours. To keep your data permanently, visit the claim URL printed in your terminal.
If a coding agent (Claude Code, Cursor, Windsurf) installs this package:
.claude/CLAUDE.md instructs agents to surface the claim link to you.env or ~/.ainative/config.json for your project ID if you miss itSource-derived launch command. Check the maintainer’s required arguments and credentials before running:
npx -y ainative-postgres-mcpMerge this template into ~/Library/Application Support/Claude/claude_desktop_config.json. Keep existing servers. Add any arguments, credentials, and permissions required by the maintainer; this template has not been install-tested.
{
"mcpServers": {
"io-github-ainative-studio-ainative-postgres-mcp": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp"
]
}
}
}Restart Claude Desktop completely for changes to take effect. Confirm the server appears connected in the client’s tool list, then try a read-only example from its documentation.
Claude Desktop setup referenceainative-postgres-mcpnpmio.github.AINative-Studio/ainative-postgres-mcp works with any MCP-compatible client. Copy the config snippet from the Configuration section above and add it to the file shown for your client, then restart the application.
~/Library/Application Support/Claude/claude_desktop_config.jsonRestart Claude Desktop completely for changes to take effect.~/.cursor/mcp.jsonRestart Cursor for changes to take effect..vscode/mcp.jsonReload VS Code window for changes to take effect.~/.codeium/windsurf/mcp_config.jsonRestart Windsurf for changes to take effect..mcp.jsonSave at the project root, then start Claude Code in that project and review the MCP server approval prompt. Keep real credentials out of shared files.