Hubfly spaceDocs
Console

Create a database

This guide creates a managed database, checks its price before anything is billed, and opens a first connection. It takes a few minutes in the Dashboard or a single command with the CLI.

Before you start

  • You need Database admin on the project (organization owners, admins and operators have it). See Team access.
  • Databases are billed hourly from your account balance. Read Pricing and limits for how the price is calculated.
  • Hubfly space chooses where the instance runs. There is no region to pick, and each instance is a single server.

Create a managed project

Databases live in a Managed service project, a project type for services Hubfly space operates. One managed project can hold several databases and Realtime servers.

  1. In the Dashboard, create a new project and choose Managed service.
  2. Open the project and choose New database.

If you already have a managed project, open it and choose New database directly.

Create the database

The Create a database form has one section per decision. The price panel beside it updates as you change the form.

SectionWhat you chooseDefault
Engine & versionPostgreSQL (18, 17 or 16), MySQL (8.4 LTS or 9.7 LTS) or SQLite (libSQL). Version updates within the line are applied later from Settings.PostgreSQL 18
SizeA preset (Nano to X-Large) or a custom CPU and memory. MySQL needs at least 1 GiB of memory, PostgreSQL 512 MiB.The smallest preset the engine allows
StoragePersistent disk for data, indexes and logs: 1 to 500 GiB. It can grow later but never shrink.10 GiB
Network & accessPublic access and an optional IP allowlist. The form can add the IP you are browsing from. See Network access.Public access on, no allowlist
BackupsAutomatic backups are shown as Coming soon. Export your data from the instance's Backups & exports page.—
Instance nameHow the instance appears in the Dashboard and in its hostname: 3–48 lowercase letters, numbers and hyphens, starting with a letter.postgres-1, mysql-1 or sqlite-1
Default database nameUnder Advanced (PostgreSQL and MySQL). Created with the instance and used in the connection string.app

The price panel shows the monthly estimate split into Compute, Storage and Management, with a summary of the name, engine, size and access. Choose Create database. If the price changed since the form loaded, Hubfly space shows the new quote and the button becomes Confirm and create, so you always confirm the price you pay.

Your admin user

PostgreSQL and MySQL instances are created with an admin user named admin and a password generated by Hubfly space. It can create databases and users and read and write all data, but it is not a superuser. libSQL has no users: clients authenticate with access tokens.

Provisioning

After you create it, the instance page shows the provisioning steps as they run: Hubfly space creates the storage volume, starts the server, initializes the engine and publishes the endpoint. This usually takes about a minute. If a step fails, the page shows where it stopped and why.

When the instance is running, its Overview shows the engine, size, storage and status, and the sidebar opens every other page: Connect, SQL editor, Table explorer, Users & roles, Metrics, Settings and more.

Connect for the first time

  1. Open Connect. For PostgreSQL and MySQL it shows the host, port, database and user. Copy the host and port from here: the port is assigned to the instance and is not 5432 or 3306.
  2. Choose Reveal next to the password (Database admin only). The password hides again automatically after a minute, and every reveal is recorded in the access log.
  3. Pick a format under Connection string and snippets, such as URI, psql or Prisma, and copy it. While the password is revealed it is filled in.
  4. Connect from your machine. TLS is required, and the snippets already include it:
bash
psql 'postgresql://admin:<password>@app-db-k3x9.db.hubfly.app:31544/app?sslmode=require'

For libSQL, create a token under Tokens first; the Connect page shows the libsql:// URL to use it with. Connect and verify TLS has snippets for every engine and common clients.

If the connection times out, check that public access is on and that your IP is allowed: see Network access.

No local client needed

You can also run SQL right away in the instance's SQL editor, which works through Hubfly space without an allowlist entry. See SQL, explorer and exports.

Do it with the CLI

The hubfly db commands follow the same steps. Check what you can create and what it costs:

bash
hubfly db engines

Create the database. The CLI checks your input, shows the monthly quote and asks you to confirm, then waits until the database is ready. --project new creates a managed project for it:

bash
hubfly db create app-db --engine postgresql --size nano --project new
# MySQL with an allowlist entry for the network you are on
hubfly db create orders --engine mysql --size small --allow-my-ip --project new

Then inspect it and connect:

bash
hubfly db info app-db          # engine, status, size, host and port, access
hubfly db url app-db --reveal  # connection URL with the password (recorded in the access log)
hubfly db connect app-db       # opens psql or mysql on your machine with TLS required

hubfly db connect needs psql or mysql installed locally and checks that your IP may connect first. Without a terminal, hubfly db create needs --yes to accept the quote.

Next steps

Something unclear or out of date? Emailsupport@hubfly.spaceBack to top