Database: Add a Dedicated SQL Database to Your Website

Entro Database is the project database that appears in your panel as EntroSQL. It is created in one click, separately for each project. Browse its tables, query it with SQL and download results as CSV.

Draft a database plan for my yoga studio's website. Which tables and columns do I need for the class schedule and the instructors, and which column links to which table? Write a CREATE TABLE statement for each table that I can run on the SQL tab, plus INSERT statements that add three sample rows each. Then take me to the Database screen.

Blue parts are the places to fill in with your own details. Tab selects the next one, Enter sends, Shift and Enter starts a new line.

Example results

What's inside Entro Database

The page for your website database has three tabs: Tables, SQL and Usage. Creating a database needs a paid plan; reading, querying and deleting an existing one work on every plan.

In short

  • Each project has at most one database, and it shares no data with other projects.
  • Tables come from plugins or from you. The website Builder does not create tables or change records.
  • Connection details are stored encrypted with AES-256 and never sent to the browser.
  • Form submissions are not written to the database. They stay on the Forms page.

One-click setup

The Create EntroSQL button does the whole job. You enter no server settings or connection details.

  • Three steps, a few seconds

    The screen lists each step: a dedicated server is set aside, security settings are applied and the connection details are encrypted. It usually takes a few seconds.

  • Created along with AutoBlog

    Install AutoBlog in a project with no database and one is created during setup. Posts and categories go into their own tables.

  • Made for websites

    Databases are created for website projects. Mobile apps do not use this one; for app data you connect your own database account in the Builder.

Preschool Website: Preschool & Daycare

Tables tab

Look at your data without writing SQL. Pick a table from the list and its records open beside it.

  • Browse page by page

    Records are paged with the newest first. Search the table list and see how many records each table holds.

  • Open a record, copy a field

    Click a record to see its fields, each with a copy button. Records are read-only here; to change them, use the SQL tab.

  • Download as CSV

    Save the table you are viewing as a CSV file and open it in any spreadsheet.

Musician and Band Website: Musician & Band

SQL tab

Write and run queries in the browser, with no client to install.

  • Write and run

    Run a query with ⌘ + Enter or Ctrl + Enter. Results come back as a table and download as CSV, with the row count and the time in milliseconds.

  • Create your own tables

    Use CREATE TABLE to add a table, then INSERT and UPDATE to add and change records. The "Create a table with SQL" link on an empty Tables tab brings you here.

  • Restricted permissions

    Queries run with restricted permissions for up to 30 seconds. DROP TABLE, TRUNCATE and role or extension commands are rejected, and very large results are cut short.

Bakery Cafe Website: Coffee Shop

Security and usage

Your database is kept apart from every other project, and the Usage tab shows how much of it you use.

  • Own server, sleeps when idle

    Each project gets its own server and shares no data with others. The database sleeps when idle and wakes on the next query.

  • Usage tab

    See this month's compute, storage and data transfer. The tab also lists the region as Europe (Frankfurt), the query timeout and the creation date.

Conference Website: Conference & Event

How many databases each plan includes

PlanDatabases you can create
FreeNone
Starter1
Pro1
Pro+2
Ultra3
Teams5
Teams Max10
  • Each project has at most one database, so the number shows how many of your projects can have one.
  • At the limit, delete a database or move to a higher plan to create another.
  • Downgrading does not delete your databases. After a move to the Free plan a database can become read-only: the screen says so, read queries keep working and writing returns when you upgrade.

Publishing, deleting and transfers

  • Publish the site again for new content to show up.
  • Blog posts are edited on AutoBlog's own screen, and the table record changes with them. More on the AutoBlog page.
  • Unpublishing a site leaves its database in place. Deleting the project deletes the database too.
  • Projects with a database cannot be transferred to another account for now.
  • Form submissions are kept on the Forms page instead.

Deleting cannot be undone

Delete a database from the Usage tab with Delete database, typing the project name to confirm. Every table and all data are removed for good, and plugins such as AutoBlog stop working. The Database guide has the full steps.

Who Entro Database is for

  • Sites with a blog

    With AutoBlog, posts and categories live in the project's database, and the Tables tab shows when each was added.

  • People who know SQL

    Filter, count and join tables on the SQL tab, then take the result as CSV.

  • Agencies and freelancers

    Each client's data sits in that client's own project database, apart from the others.

How to add a database to your website

  1. 1

    Pick your project

    Open Database from the left menu and choose your website at the top. With no project yet, the screen asks you to create a site first.

  2. 2

    Create EntroSQL

    Press Create EntroSQL and stay on the page until setup finishes. The screen then says "EntroSQL is ready".

  3. 3

    Browse and query

    Browse records on the Tables tab and run queries on the SQL tab. Plugins such as AutoBlog create their own tables.

Creative Agency Website: Design Agency

Frequently asked questions

Can I create a database on the Free plan?

No, creating a database needs a paid plan. On Starter the number you can create is 1, and the table above lists the other plans. On the Free plan you can still read, query and delete a database you already have.

Does the Builder chat create tables in the database?

No. The website Builder does not create tables or change records. Plugins such as AutoBlog create their own tables, and you add yours with CREATE TABLE on the SQL tab. Entro, the assistant on the home screen, can help you plan tables and columns.

Which SQL dialect do I write, and where is the data kept?

The Engine row on the Usage tab reads PostgreSQL, so that is the syntax to use. The same tab lists the region as Europe (Frankfurt).

Are form submissions saved in the database?

No. On every plan, form submissions are kept on the Forms page in your panel, with email alerts and a CSV download. You do not need a database to collect form messages.

Does a change in the database show on my site right away?

Publish the site again to put it live. Pages are prepared when you publish, which keeps the site fast. If you have several changes, finish them all and publish once.

Will my data be deleted if I downgrade?

No. Your databases stay in place and readable; you just cannot create new ones. On the Free plan a database can become read-only, and writing turns back on when you upgrade.

What happens if I delete the database?

Every table and all data are removed for good, and plugins such as AutoBlog stop working. Download any tables you still need as CSV first, then confirm by typing the project name.

What is the quickest way to add a database to my website?

Pick your project on the Database page and press Create EntroSQL; setup usually takes a few seconds. For a sample request to start from, see the website database builder page.

What people make with Entro Database

Tool pages that run on this module, each focused on a single job with a ready-made request you can edit and send.

All AI tools
  • Preschool Website: Preschool & Daycare

    Website Database Builder

    Add a database to your site in one click. Blog posts are written to its tables for you; browse records in your panel, run SQL and download CSV files.

  • Magazine and Blog Website: Magazine & Blog

    AI Blog Writer

    Turn a keyword into a full blog post with a cover and in-post images. AutoBlog drafts it on your own site, and you edit it and publish when it's ready.

  • Veterinary Clinic Website: Veterinary Clinic

    AI Form Builder

    Add a contact, booking or quote form to your site by chatting. Submissions collect on your Forms page, and you get an e-mail for each new one.

  • Digital Wallet App: Digital wallet

    AI App Builder

    Describe your app and Entrobase builds a first version for iPhone and Android. Try it on your phone, change it by chatting, then build the Android file.

  • Fintech SaaS Website: SaaS Product

    AI Website Builder

    An AI website builder that builds what you describe. Write a few sentences, preview the site next to the chat, fix it by asking and publish it for free.

  • App Landing Page: Mobile App Launch

    Domain Name Generator

    Describe your business and Entro suggests domain name ideas. Check the one you like in a click and see free extensions with first-year and renewal prices.

Other features

Start planning your database