run402-mcp

MCP server for Run402 — provision and manage AI-native Postgres databases from any MCP-compatible client.

Quick Start

npx run402-mcp

Tools

| Tool | Description | |------|-------------| | provision_postgres_project | Provision a new Postgres database (prototype/hobby/team tier) | | run_sql | Execute SQL (DDL or queries) against a project | | rest_query | Query/mutate data via PostgREST REST API | | upload_file | Upload text content to project storage | | renew_project | Renew a project's database lease |

Client Configuration

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

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

Cursor

Add to .cursor/mcp.json in your project:

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

Cline

Add to Cline MCP settings:

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

Claude Code

claude mcp add run402 -- npx -y run402-mcp

How It Works

1. Provision — Call provision_postgres_project to create a database. The server handles x402 payment negotiation and stores credentials locally.
2. Build — Use run_sql to create tables, rest_query to insert/query data, and upload_file for storage.
3. Renew — Call renew_project before your lease expires.

Payment Flow

Provisioning and renewing require x402 micropayments. When payment is needed, tools return payment details (not errors) so the LLM can reason about them and guide the user through payment.

Key Storage

Project credentials are saved to ~/.config/run402/projects.json with 0600 permissions. Each project stores:

• anon_key — for public-facing queries (respects RLS)
• service_key — for admin operations (bypasses RLS)
• tier — prototype, hobby, or team
• expires_at — lease expiration timestamp

Environment Variables

| Variable | Default | Description | |----------|---------|-------------| | RUN402_API_BASE | https://api.run402.com | API base URL | | RUN402_CONFIG_DIR | ~/.config/run402 | Config directory for key storage |

Development

npm run build
npm run test:skill

License

MIT