Database (EntroSQL)
Your project's database, EntroSQL: what it is for, how to create one, the tables and SQL screens, plan limits and deleting.
EntroSQL is a database created separately for each project. Data such as your site's blog posts (AutoBlog) and product details lives here.
Messages from forms are not stored here; they are on the Forms page: Forms.
Creating a database
- Open Database from the left menu and pick the project.
- Press Create EntroSQL. When it is ready, the screen says "EntroSQL is ready".
- When you install AutoBlog in a project without a database, one is created automatically.
- Each project has at most one database.
- Creating a database requires a paid plan. Reading, querying and deleting an existing one work on every plan.
| Plan | Databases you can create |
|---|---|
| Free | None |
| Starter | 1 |
| Pro | 1 |
| Pro+ | 2 |
| Ultra | 3 |
| Teams | 5 |
| Teams Max | 10 |
At the limit no new database can be created; delete one or upgrade your plan.
Tables and SQL
- The Tables tab shows tables and records page by page. Records are read-only here.
- To change records, use the SQL tab. Blog posts are edited on AutoBlog's own screen.
- Queries on the SQL tab run with restricted permissions for at most 30 seconds. Very large results are cut; the screen says how many rows are shown.
- For safety, commands that delete or empty tables or change permissions do not run from this screen.
- The Usage tab shows this month's usage of the database.
If you downgrade
When you downgrade, your databases are not deleted; your data stays in place and can still be read. You just cannot create new ones. After a move to the free plan a database can become read-only: the Database screen says so, read queries keep working, and writing turns back on when you upgrade.
Deleting a database
- On the Usage tab, press Delete database.
- Type the project name to confirm and delete.
Deleting cannot be undone
All tables and data are permanently deleted. Plugins in the project, such as AutoBlog, stop working.
Mobile apps and project transfer
- Mobile apps use your own Supabase account for sign-in and shared data: Mobile apps and Expo Go.
- Projects with a database cannot be transferred to another account for now: Project transfer.
Was this page helpful?
Still stuck?
If this article did not solve it, email support; the article name is added to the subject line.