snoopgres

CLI-first managed Postgres. No dashboard, no bloat, just database.

npm i -g snoopgres
snoopgres signup --email [email protected] --password YourPass!
snoopgres create my-db

That's it. You have a Postgres database. Use the connection string anywhere.

Why snoopgres

• CLI-first -- no web dashboard to click through. One command to create, connect, snapshot, destroy.
• Agent-friendly -- built-in MCP server and structured skill interface for AI agents.
• Usage-based billing -- pay for what you use. No surprise bills from idle databases.
• Free tier -- 100 compute hours, 1 GB storage, 10 snapshots/month. No credit card required.

Install

npm i -g snoopgres

Requires Node.js 18+.

Quick Start

# Create an account
snoopgres signup --email [email protected] --password SecurePass123!

# Provision a database (defaults to Chicago)
snoopgres create my-app-db

# Get the connection string
snoopgres connstring my-app-db
# postgres://snoopgres:[email protected]:5432/my_app_db

# Use it
DATABASE_URL=$(snoopgres connstring my-app-db) npx prisma migrate deploy

Commands

Databases

snoopgres create <name>             # Provision a new database
snoopgres create <name> --region ams  # Provision in a specific region
snoopgres list                      # List all databases
snoopgres info <name>               # Show details + connection string
snoopgres connect <name>            # Open psql session
snoopgres connstring <name>         # Print connection string (pipeable)
snoopgres destroy <name> --confirm  # Destroy (takes a safety snapshot first)

Snapshots

snoopgres snapshot <name>           # Take a snapshot (pg_dump, gzip)
snoopgres snapshots <name>          # List snapshots
snoopgres restore <name> <id>       # Restore from a snapshot

Migrations

snoopgres migrate <name> ./migrations  # Apply SQL migrations

Billing

snoopgres billing                   # Usage summary + costs
snoopgres billing portal            # Open Stripe billing portal
snoopgres billing upgrade <name> --tier pro  # Change resource tier

Auth

snoopgres signup --email <email> --password <pass>
snoopgres login --email <email> --password <pass>
snoopgres logout
snoopgres whoami

AI Agents

snoopgres agent                     # Start MCP server (stdio transport)
snoopgres skill                     # Structured skill interface

Regions

| Code | Location | |------|----------| | ord | Chicago (default) | | sea | Seattle | | iad | Washington DC | | lax | Los Angeles | | ams | Amsterdam | | fra | Frankfurt | | sin | Singapore | | syd | Sydney |

Pricing

Usage-based -- you only pay for what you use.

| Dimension | Price | Free Tier | |-----------|-------|-----------| | Compute | $0.02/hr | 100 hrs/mo | | Storage | $0.15/GB-mo | 1 GB | | Snapshots | $0.008/snap-day | 10/mo |

No credit card required to start. Free tier resets monthly.

Resource Tiers

Tiers control VM size, not billing. All tiers are billed on usage.

| Tier | CPU | RAM | Snapshots | |------|-----|-----|-----------| | starter (default) | Shared 1x | 256 MB | Weekly, 7-day retention | | pro | Dedicated 1x | 1 GB | Daily, 30-day retention |

JSON Output

Every command supports --json for scripting:

snoopgres list --json | jq '.[].name'
snoopgres connstring my-db --json | jq -r '.connstring'

Environment Variables

| Variable | Description | |----------|-------------| | SNOOPGRES_API_URL | Override API endpoint (default: https://snoopgres-db-engine.fly.dev) | | SNOOPGRES_API_KEY | API key (alternative to snoopgres login) |

MCP Integration

snoopgres includes a built-in Model Context Protocol server. Add it to your AI agent's MCP config:

{
  "mcpServers": {
    "snoopgres": {
      "command": "snoopgres",
      "args": ["agent"]
    }
  }
}

This gives your agent tools to create, list, connect, snapshot, and destroy databases.

License

MIT