Ainative Postgres MCP server
{
"mcpServers": {
"ainative-studio-ainative-postgres": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp@latest"
],
"env": {
"DATABASE_URL": "postgresql://user:password@host:5432/db",
"ZERODB_API_KEY": "<zerodb_api_key>",
"ZERODB_PROJECT_ID": "<zerodb_project_id>",
"ZERODB_API_URL": "https://..."
}
}
}
}{
"mcpServers": {
"ainative-studio-ainative-postgres": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp@latest"
],
"env": {
"DATABASE_URL": "postgresql://user:password@host:5432/db",
"ZERODB_API_KEY": "<zerodb_api_key>",
"ZERODB_PROJECT_ID": "<zerodb_project_id>",
"ZERODB_API_URL": "https://..."
}
}
}
}{
"mcpServers": {
"ainative-studio-ainative-postgres": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp@latest"
],
"env": {
"DATABASE_URL": "postgresql://user:password@host:5432/db",
"ZERODB_API_KEY": "<zerodb_api_key>",
"ZERODB_PROJECT_ID": "<zerodb_project_id>",
"ZERODB_API_URL": "https://..."
}
}
}
}{
"servers": {
"ainative-studio-ainative-postgres": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp@latest"
],
"env": {
"DATABASE_URL": "${input:database_url}",
"ZERODB_API_KEY": "${input:zerodb_api_key}",
"ZERODB_PROJECT_ID": "${input:zerodb_project_id}",
"ZERODB_API_URL": "${input:zerodb_api_url}"
}
}
},
"inputs": [
{
"id": "database_url",
"type": "promptString",
"description": "Database url",
"password": true
},
{
"id": "zerodb_api_key",
"type": "promptString",
"description": "Zerodb api key",
"password": true
},
{
"id": "zerodb_project_id",
"type": "promptString",
"description": "Zerodb project id",
"password": true
},
{
"id": "zerodb_api_url",
"type": "promptString",
"description": "Zerodb api url",
"password": true
}
]
}{
"mcpServers": {
"ainative-studio-ainative-postgres": {
"command": "npx",
"args": [
"-y",
"ainative-postgres-mcp@latest"
],
"env": {
"DATABASE_URL": "postgresql://user:password@host:5432/db",
"ZERODB_API_KEY": "<zerodb_api_key>",
"ZERODB_PROJECT_ID": "<zerodb_project_id>",
"ZERODB_API_URL": "https://..."
}
}
}
}file .mcp.json (in your project root)file claude_desktop_config.jsonfile ~/.cursor/mcp.jsonfile .vscode/mcp.jsonfile ~/.codeium/windsurf/mcp_config.jsoninstall npx -y ainative-postgres-mcpversion 1.0.1
What it does
A PostgreSQL MCP server that auto-provisions a managed Postgres instance with pgvector on first run, requiring no configuration or existing database. It replaces the standard server-postgres with zero-config setup and includes write operations like table creation and row insertion.
- Start using PostgreSQL with an AI agent instantly without setting up your own database or connection string.
- Run SQL queries and manage table schemas through MCP tools in Claude, Cursor, or Windsurf.
- Store and search vector embeddings in PostgreSQL using the auto-enabled pgvector extension.
Tools this server exposes
| Tool | Does |
|---|---|
| query | Execute read-only SQL queries within a READ ONLY transaction. |
| list_tables | List all tables with schema, name, and type information. |
| describe_table | Get full table schema including columns, types, constraints, and indexes. |
| create_table | Create a new table using SQL DDL. |
| insert | Insert rows into a table and return the inserted rows. |
Before you enable it
An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.