Base
Hardened build
minimal ports, security patches applied at build time
Mathesar on Ubuntu 24.04 LTS
Azure
Analytics
Mathesar, a spreadsheet like web interface for PostgreSQL, lets your team browse, enter and edit real database data with no SQL.
Overview
Mathesar is an open source web application that gives your team a friendly, spreadsheet like way to work with the data in a PostgreSQL database. Users browse, enter and edit records directly in real tables, build explorations (saved queries) to slice and summarise data, and manage schemas, columns, relationships and constraints from the browser, all without writing SQL, while everything stays in standard PostgreSQL underneath. A JSON-RPC API exposes the same operations for automation.
It suits teams who want to give analysts, operations staff and non technical colleagues safe, direct access to a shared database, replacing fragile spreadsheets and one off admin scripts with a governed data workspace they fully own and control.
Why the cloudimg image
cloudimg delivers Mathesar fully installed the native way behind an nginx reverse proxy, so a working data workspace answers the moment the instance boots, with no manual Django, gunicorn or PostgreSQL setup. The image is secure by default and carries no usable credential at all: on the first boot of every instance a one shot service generates a fresh Django secret key, a fresh PostgreSQL password and a random administrator password unique to that instance, writing the admin password to a file only the root user can read. The application binds to loopback so the reverse proxy is the only way in, and the PostgreSQL data directory plus uploaded files live on a dedicated data volume so your data is kept on its own disk. The base OS is fully patched with unattended security upgrades enabled, and every deployment is paired with a step by step deploy guide and backed by 24/7 cloudimg support.
Common uses
- A shared, no SQL data workspace over a PostgreSQL database for analysts and operations teams
- Replacing fragile spreadsheets and ad hoc admin scripts with governed table editing
- Giving non technical staff safe browse, enter and edit access to real database data
See it running
Real screenshots taken while testing this image against its deployment guide.
More in Analytics
Apache Airflow - Workflow Orchestration
Analytics
This image runs Apache Airflow as a single node deployment. Airflow is installed into a dedicated Python virtual environ...
Apache Flink Stream Processing
Analytics
Apache Flink is the open source framework and distributed processing engine for stateful computations over unbounded and...
Apache NiFi Dataflow Automation
Analytics
This image runs Apache NiFi, the open source dataflow automation platform, as a single node deployment.
Apache Spark Single-Node Cluster
Analytics
This image runs Apache Spark 4.1.2 (built for Hadoop 3) as a single node standalone cluster.
Apache Superset BI Platform
Analytics
This image runs Apache Superset, the open source data exploration and business intelligence platform, as a complete sing...
Az
Apache Zeppelin
Analytics
This image runs Apache Zeppelin, the open source web based notebook that brings data ingestion, exploration, visualisati...