PostGraphile on Ubuntu 24.04

Azure Developer Tools

Instantly turns a PostgreSQL schema into a powerful, secure GraphQL API, with a browser based Ruru GraphiQL IDE for exploring and running queries.

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

PostGraphile builds a GraphQL API from a PostgreSQL schema in seconds. It introspects your tables, views, foreign key relationships and functions and generates a complete GraphQL API with no resolvers to write, plus a Ruru GraphiQL IDE for exploring and running queries in the browser. Point it at your own schema whenever you are ready.

Why the cloudimg image

cloudimg ships PostGraphile behind an nginx reverse proxy with a unique HTTP Basic Auth password generated on first boot and no default login, and the GraphQL API connects to PostgreSQL as a dedicated least privilege role that is granted only the demo schema and never a superuser. A seeded demo schema of related tables, a view and a function is included so the API and the IDE are populated on first boot, backed by a paired deploy guide and 24/7 support.

Common uses

  • Instant GraphQL APIs over PostgreSQL
  • Rapid backend and API prototyping
  • Exploring a database schema as GraphQL

See it running

Real screenshots taken while testing this image against its deployment guide.

PostGraphile on Ubuntu 24.04 screenshot 1 PostGraphile on Ubuntu 24.04 screenshot 2 PostGraphile on Ubuntu 24.04 screenshot 3 PostGraphile on Ubuntu 24.04 screenshot 4