Lampion CLI

Command-line interface for Lampion — sovereign serverless PostgreSQL hosted in France.

Install

pip install lampion-cli

Setup

export LAMPION_TOKEN=lmp_live_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# Optional: export LAMPION_API_URL=https://api.lampion.cloud

Generate an API key at https://app.lampion.cloud/settings

Usage

# Projects
lampion projects list
lampion projects create my-app --region fr-par-1
lampion projects delete <project-id>

# Branches
lampion branches list <project-id>
lampion branches create <project-id> dev --parent <project-id>
lampion branches reset <project-id> <branch-id>
lampion branches merge <project-id> <branch-id> --dry-run
lampion branches promote <project-id> <branch-id>

# Endpoints (computes)
lampion endpoints list <project-id>
lampion endpoints suspend <project-id> <endpoint-id>
lampion endpoints resume <project-id> <endpoint-id>

# SQL
lampion sql <project-id> <endpoint-id> "SELECT * FROM users LIMIT 10"

# Schema introspection
lampion schema <project-id> --database postgres --schema public

# Databases & Roles
lampion databases list <project-id> <endpoint-id>
lampion databases create <project-id> <endpoint-id> mydb
lampion roles list <project-id> <endpoint-id>
lampion roles create <project-id> <endpoint-id> app_user

# Extensions
lampion extensions list <project-id> <endpoint-id>
lampion extensions install <project-id> <endpoint-id> pgvector

# Monitoring
lampion metrics <project-id>
lampion slow-queries <project-id> <endpoint-id>
lampion logs <project-id> <endpoint-id> --lines 50
lampion usage <project-id>

# Backups (PITR)
lampion backups list <project-id>
lampion backups create <project-id> <branch-id> "before-migration"
lampion backups restore <project-id> <backup-id>

# Dump
lampion dump <project-id> <endpoint-id> --database postgres -o dump.sql

# PII Masking
lampion anon status <project-id> <branch-id>
lampion anon enable <project-id> <branch-id>
lampion anon add-rule <project-id> <branch-id> --table users --column email --function "anon.fake_email()"
lampion anon disable <project-id> <branch-id>

# IP Allowlist
lampion allowlist get <project-id> <endpoint-id>
lampion allowlist set <project-id> <endpoint-id> 1.2.3.4/32 5.6.7.8/32

# Permissions
lampion permissions list <project-id> <endpoint-id>
lampion permissions grant <project-id> <endpoint-id> --role app_user --table users --privilege SELECT
lampion permissions revoke <project-id> <endpoint-id> --role app_user --table users --privilege ALL

# Data residency
lampion residency <project-id>

JSON output

Most list commands support --json for machine-readable output:

lampion projects list --json
lampion branches list <project-id> --json

Regions