PostgreSQL on your VPS, managed from the panel

You install PostgreSQL with a strong password generated on the spot, then create databases, users and grants with forms, no psql involved. To work with the data you get a web manager with an editable grid, a SQL console and Excel export. And if another server needs this database, it connects over an encrypted SSH tunnel: port 5432 is never opened to the internet.

  • One-click install
  • Per-database permissions
  • Port 5432 never exposed

See plans · Create a free account

Here's what it looks like in the panel

PostgreSQL: PostgreSQL in the panel
PostgreSQL in the panel. Service status, port, databases and users.
PostgreSQL: Table structure
Table structure. Columns, types, nullability and foreign keys.

Your day-to-day, without psql

And psql is still there over SSH whenever you need it.

  • Install with a strong password: If you don't set a password for the postgres user, a secure random one is generated.
  • Status at a glance: Running or not, version, port 5432, and how many databases and users there are.
  • Databases: List them (system ones left out), create one choosing the owner, see size and creation date, and delete.
  • Users: Create with or without superuser, see whether they can create databases or roles, change the password and delete.
  • Per-database permissions: Grant and revoke ALL, SELECT, INSERT, UPDATE, DELETE, CREATE, USAGE and more, per user and per database. Ideal for a read-only user.
  • Tables and rows: List each database's tables and see the latest rows (up to 1000) without opening a SQL client.
  • Full web manager: Editable grid, read-only SQL console, EXPLAIN, and CSV and Excel import and export, over a private SSH tunnel.
  • Never exposed to the internet: The database listens on localhost. To reach it from another VPS you use an encrypted SSH tunnel, so there's no open 5432 waiting for someone to try passwords.
  • Backups included: It's covered by the VPS backup, and you can set up your own dump as a scheduled task from the panel.
  • Real root if you want it: psql, pg_dump, extensions, postgresql.conf: the whole server is yours over SSH. The panel is a shortcut, not a cage.

A database ready for your app

  1. Install PostgreSQL: One click, with a strong generated password.
  2. Create a database and a user: Named after your app, with a user of its own.
  3. Give it permissions: Only the ones the app needs.
  4. Connect your app: On localhost:5432 from the same VPS, or over an SSH tunnel from another VPS.
  5. Connect from another server: With an SSH tunnel between your VPSs, the database shows up on the other one's localhost without opening a single port.

How it works underneath, and what to keep in mind

  • PostgreSQL listens on port 5432 on the VPS's localhost. It isn't published to the internet, and that's the decision that avoids most database incidents.
  • For another VPS to use it, you set up an SSH tunnel between the two: the database shows up on the second server's localhost and the traffic is encrypted. No opening 5432 and no IP allowlists to maintain.
  • The web manager also comes in over that private tunnel, not over a direct connection from the browser.
  • If you don't set the postgres user's password at install time, a secure random one is generated and shown to you at the end. No default password left lying around.
  • Permissions are granted per user and per database: ALL, SELECT, INSERT, UPDATE, DELETE, CREATE, USAGE and more. A read-only user for a dashboard is two clicks.
  • Usernames accept lowercase letters, numbers and underscores; database names are normalized to lowercase, which is how Postgres will treat them anyway.
  • It needs systemd and a Debian or Ubuntu base. It's verified in production on Ubuntu 22.04 and compatible with 18.04, 20.04, 24.04 and 26.04. Not on 16.04, because systemd 229 won't start on a host running cgroup v2.
  • The web manager asks for a bit more: it uses a tunnel built on sshd_config.d, so it needs Ubuntu 22.04 or later. On 20.04 and earlier the configuration doesn't apply and it stays disabled.
  • The database is covered by the VPS backup. If you want your own dump with your own retention, you set it up as a scheduled task from the panel.
  • Over SSH you have the whole server: psql, pg_dump, extensions and postgresql.conf. The panel covers the day-to-day; it doesn't take the rest away.
  • Real root over SSH: the panel is a shortcut, not a cage. Anything it does with a button, you can also do by hand.

Or just ask Claude, ChatGPT or Cursor

Everything you see in the panel, your AI agent can do through the ArduMaker MCP server: with your authorization, within the scope you grant, and with every action audited. See what the MCP does

Frequently asked questions

How do I connect to PostgreSQL from another server without exposing it?

With an SSH tunnel between your VPSs. The database becomes available on the other server's localhost and the traffic is encrypted, without opening 5432 to the internet or maintaining IP allowlists. Your app connects to localhost:5432 as if the database were local.

Is it safe to expose Postgres to the internet?

It's the most common way a database gets compromised, so here it simply isn't done: 5432 listens on localhost only. What's exposed is the SSH tunnel, not the port, and it serves a shell-less user that can only do port forwarding.

What password do I get if I don't set one?

A secure random one is generated and shown to you when the install finishes. There's no default password and no user without one.

Can I view and edit the data without a SQL client?

Yes. From the panel you see the tables and the latest rows, and the web manager gives you an editable grid, a SQL console, EXPLAIN, and CSV and Excel import and export.

Can I create a read-only user?

Yes, by granting only SELECT on the database you want. It's the typical case for a dashboard or a report that has no business writing.

Can I still use psql and pg_dump?

Yes, you have root over SSH and the full PostgreSQL: extensions, postgresql.conf, whatever you need. The panel covers the day-to-day without taking the rest away.

Are there backups of the database?

It's covered by the VPS backup. If you want your own dump with your own retention and schedule, you set it up as a scheduled task from the panel.

Which Ubuntu versions are supported?

PostgreSQL works from 18.04 onward and is verified in production on 22.04. The web manager needs 22.04 or later, because it uses a tunnel built on sshd_config.d that earlier versions don't apply.

How much does it cost?

Nothing beyond the VPS. It isn't a managed database billed by the hour: it runs on your server, at the plan's fixed price.

Services that go well together

  • Database manager: A web grid for PostgreSQL and MySQL: edit rows, run SQL and EXPLAIN, and import/export CSV and Excel over a private tunnel.
  • MySQL: Install MySQL and manage databases, per-host users and permissions without touching the console.
  • Automatic backups: A full live backup every week, the last 4 kept, and a final copy when you delete the VPS.

Your PostgreSQL, on your server and with no open ports Install it in one click from the panel of any VPS. See plans