Skip to main content

​
Database

Mythex can give a project an isolated Postgres database so your app can save real data. The data is yours: you can download it or connect to it from other tools at any time.

​
Availability

A database is available on every plan. Free can use a database in Preview and on LIVE apps; published DB usage spends from monthly Cloud credits (Free 10/mo; Pro, Business and Enterprise a fifth of their monthly credits, and they fall through to monthly credits or top-ups once those run out). Abandoned Free Preview infra may be cleaned up after long inactivity if the project is not LIVE.

​
What you get

  • A dedicated database for that project
  • Connection details injected into the workspace and published apps
  • Ask Mythex to create tables, save form submissions, or load data for you
  • It sleeps when idle — after about a minute on Free, 5 minutes on Pro — and wakes on the next request; published usage is charged for the time it was actually awake, at the size it ran at (Database size)
  • On Free a database grows up to half a compute unit; on Pro up to 2

​
Sleep when idle, or always on (Pro)

In Settings → Usage, a Pro project’s database can be set to:
  • Sleep when idle (the default) — it sleeps after a few idle minutes and wakes in a moment on the next visit. You pay only while it’s awake.
  • Always on — it never sleeps, so there is no wake-up pause on the first visit. It costs every hour of the month; the setting shows the monthly floor in credits before you turn it on (busy apps grow past the smallest size and cost more).
Only the project owner can change it. If the owner leaves Pro, the database goes back to sleeping when idle.

​
How to enable

You usually do not click a separate “attach” button. Either:
  1. Ask in chat: “save waitlist emails to a database”
  2. Or use the /database Command in the workspace
Mythex adds it when the app needs it. Until then, Project settings → Database says No database yet.

​
Your data

Open the project name → Settings → Database (on a phone, tap the project name and choose Database). Project settings → Database

​
Download a backup

Download backup gives you a full copy of your app’s data as one .sql.gz file: every table, row and index. It restores into any Postgres database, so you can keep it as a backup or move your data somewhere else:
  • Available on Free and Pro, and it works even when your Cloud credits are empty.
  • It takes a few seconds for a small app and longer for a large one; the download starts by itself when it’s ready. You can leave the page open while it works.
  • A backup reads the whole database once, which counts as database time like any other use.

​
Connect from another tool

On Pro, Show connection string gives you the database’s full address. Paste it into TablePlus, DBeaver, psql, pg_dump or another host’s import screen to look at your data, edit it, export it or move it.
The connection string is a full read-and-write login. Anyone who has it can read and change your app’s data — including your live app’s, because the preview and the published app share one database. Keep it out of chats, screenshots and public code.

​
Reset password

If a connection string was shared somewhere it shouldn’t be, choose Reset password under it. The database gets a new password and the old connection string stops working right away. Mythex hands the new one to your preview and your live app for you; the live app restarts to pick it up, which takes a few seconds. Anything else you connected with the old string (a desktop tool, another server) needs the new one.

​
Tips

  • Be explicit: “create a waitlist table and save emails from the form”
  • Keep secrets out of chat when possible — prefer project secrets / /secrets
  • After enabling, republish if you already published and need the live app to use the database