Website Database Builder

EntroSQL is a database set up separately for each project. AutoBlog keeps its posts there, and you can browse the tables in your panel or query them with SQL when you need to. Setup asks for no server settings or connection details.

I want a database for my café's website. My blog posts should be stored there, I'd like to browse the records from my panel, and I want to run SQL to list posts published in the last 30 days. Tell me which steps to follow.

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.

This tool runs on Entro Database.

Example results

Create the database, browse it, query it

One-click setup

On the Database page, pick your project and press Create EntroSQL. A separate server is set aside, security settings are applied and the connection details are encrypted, usually within a few seconds.

Preschool Website: Preschool & Daycare

Tables tab

Browse tables and records page by page, newest first. Records are read-only here. Any table downloads as a CSV you can open in Excel, and opening a record lets you copy its fields one by one.

Musician and Band Website: Musician & Band

SQL tab

Write a query and run it with ⌘ + Enter or Ctrl + Enter. Results come back as a table and download as CSV, and the screen shows how many rows came back or changed and how many milliseconds it took. Queries run with restricted permissions for up to 30 seconds.

Bakery Cafe Website: Coffee Shop

Plugins create the tables

Install AutoBlog in a project with no database and one is created for you; posts and categories go into their own tables, so you don't design anything. To add a table of your own, write a CREATE TABLE statement on the SQL tab; write commands such as INSERT and UPDATE run there too. For safety, commands that drop or empty tables don't run from this screen. When you remove AutoBlog, you decide whether its posts table goes too.

Conference Website: Conference & Event

Separate, encrypted, sleeps when idle

Each project gets its own server and shares no data with others. Connection details are stored encrypted with AES-256 and never sent to the browser. The database sleeps when idle and wakes on the first query; the Usage tab shows this month's compute, storage and data transfer.

Creative Agency Website: Design Agency

Who it's for

  • AutoBlog posts and categories live here. Use the Tables tab to see when each post was added and export the list as CSV.

Wedding Photographer Website: Photographer

Browse templates you can add a database to

How to add a database to your website

  1. 1

    Tell Entro what you need

    Type which site needs a database and what it should hold, then send it. Your request goes to Entro, which takes you to the Database page.

  2. 2

    Create EntroSQL

    Pick your project at the top and press Create EntroSQL. When the screen says "EntroSQL is ready", your database is open. If you have no project yet, the screen asks you to build a site first.

  3. 3

    Use the data

    Plugins such as AutoBlog create their own tables. Browse records on the Tables tab and run queries on the SQL tab. Publish the site again so new content shows up.

Fine Dining Restaurant Website: Restaurant

Frequently asked questions

Can I create a database on the Free plan?

No, creating a database needs a paid plan. On the Free plan you can still read, query and delete a database you already have. How many you can create depends on your plan, and the pricing page lists the numbers.

Does typing in the box create the database?

No. The box sends your request to Entro, the Entrobase assistant, which takes you to the Database page. There you pick your project and press Create EntroSQL, which usually takes a few seconds.

Where is my data stored?

The Usage tab lists the region as Europe (Frankfurt). Every project has its own server, and the connection details are stored encrypted with AES-256 and never sent to the browser.

Does a new record show on my site right away?

Publish the site again to put it live. Pages are prepared when you publish instead of on every visit, which keeps your site fast. If you're making several changes, finish them all and publish once.

Can visitors write to the database from my site?

No. Your site reads the database when you publish; no page on the live site writes to it, and member logins or admin pages aren't built on the site. To collect information from visitors, use a form: submissions go to the Forms page in your panel and you get an e-mail for each one.

Will my data be deleted if I downgrade?

No. Your databases stay in place when you downgrade; you just can't create new ones. Unpublishing a site leaves its database alone too, but deleting the project deletes the database with it.

Which SQL commands are blocked?

Dropping tables (DROP TABLE), emptying them (TRUNCATE), and role or extension commands don't run from this screen. Queries stop after 30 seconds, and very large results are cut, with the screen telling you how many rows are shown.

What happens if I delete the database?

Every table and all data are removed for good, and plugins such as AutoBlog stop working. To delete, press Delete database on the Usage tab and type the project name to confirm. Projects with a database can't be transferred to another account for now.

Does AI build the database?

For websites, you create the database in one click and plugins such as AutoBlog create its tables, so there's nothing to design. For mobile apps, AI sets up the tables and security rules in the database account you connect, based on what you ask for in the chat.

More AI tools

  • 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.

You describe it, Entrobase builds it.

Create with Entrobase