# ainative-postgres-mcp MCP server

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.

## Install

### How to install ainative-postgres-mcp in Claude Code

1. Add the server

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

2. Verify it's connected

```bash
claude mcp list
```

3. 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).

4. 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 Desktop

1. Open your MCP config

   macOS: ~/Library/Application Support/Claude/claude_desktop_config.json · Windows: %APPDATA%\Claude\claude_desktop_config.json

2. Add this server

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

3. Restart Claude Desktop

   The tools appear under the 🔌 menu once the app reloads.

### How to install ainative-postgres-mcp in Cursor

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

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

2. Enable it

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

### How to install ainative-postgres-mcp in Codex CLI

1. Add to ~/.codex/config.toml

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

2. 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 Windsurf

1. Edit ~/.codeium/windsurf/mcp_config.json

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

2. Reload

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

### How to install ainative-postgres-mcp in Cline

1. Open Cline → MCP Servers → Configure

   Adds to cline_mcp_settings.json.

2. Add the server

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

### How to install ainative-postgres-mcp in VS Code

1. Create .vscode/mcp.json

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

2. Start it

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

## Tools

- `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)

Source repository: https://github.com/AINative-Studio/ainative-postgres-mcp

---

Source: https://mcp-skills-hub.vercel.app/mcps/io-github-ainative-studio-ainative-postgres-mcp · MCP Skills Hub · data as of 2026-10-28T12:31:05Z