API Reference

REST API for the Astapa proxy.

Endpoints

REST API
localhost:8080
Postgres Proxy
localhost:5433

Sessions

POST /sessionsCreate session
GET /sessions/:idGet session
DELETE /sessions/:idDestroy session
POST /sessions/:id/proposeSubmit for review
POST /sessions/:id/approveApply to production
POST /sessions/:id/rejectDiscard changes
GET /sessions/:id/diffChanges by table
GET /sessions/:id/mutationsMutation log

Operations

GET /healthHealth check
GET /metricsPrometheus metrics

Example

terminal
# Create session
curl -X POST http://localhost:8080/sessions \
  -H "Content-Type: application/json" \
  -d '{"project_id": "demo"}'

# Connect via psql
psql "host=localhost port=5433 dbname=mydb options='-c astapa_session=sess_abc123'"