JSPM

snoopgres

0.1.1
  • ESM via JSPM
  • ES Module Entrypoint
  • Export Map
  • Keywords
  • License
  • Repository URL
  • TypeScript Types
  • README
  • Created
  • Published
  • Downloads 4
  • Score
    100M100P100Q31665F
  • License MIT

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

Package Exports

  • snoopgres
  • snoopgres/dist/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (snoopgres) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

snoopgres

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

npm i -g snoopgres
snoopgres signup --email you@example.com --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 you@example.com --password SecurePass123!

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

# Get the connection string
snoopgres connstring my-app-db
# postgres://snoopgres:abc123...@snoopgres-db-engine.fly.dev: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