Selfhost×
←→⟳
https://console.selfhost.dev/databases☆
Selfhost.dev navigation
O

Databases

Instances, alerts, backups & cloud accounts in one place.

PRODUCTION READY

Deploy your database
in minutes

Managed PostgreSQL, MySQL, Redis, and ClickHouse on AWS, with automated backups, replicas, and monitoring run for you. Need MongoDB? Run it inside a Project.
SKD
Built for teams that ship to production

Seamless Workflow

Step 1
Define
Choose your database and set region closer to your users
Step 2
Connect
Bring your own cloud account securely or use ours. We will handle the handshake
Step 3
Configure
Select instance size, storage size and type along with much more
Step 4
Launch
And deploy in one click. Your database spins up in less than 2 minutes

Premium Performance

Up to 67% Less
vs AWS RDS, ap-south-1, matched config
Instant Provisioning
Automated setup just in a few minutes
High Availability
Multi AZ replicas and auto-failover
Automated Ops
Backup, updates and scaling, all built-in

Create New Database

Deploy a managed database on AWS.

✕ Exit
1Basic Info
2Cloud Provider
3Configure
4Backup Policy
5Review & Deploy
Database Name *
Description
Brief description of your database usage
Database Type *
PostgreSQL⌄
Database Version *
# PostgreSQL 18⌄
PostgreSQL 16-18 are supported. New apps should pick 18 (the latest); choose an older version only if a dependency requires it.
Database Username *
postgres
These credentials will be used to connect the database to your app.
Database Password *Generate  |  Copy
set a password for this database
Note: The password must be at least 6 characters long, contain one uppercase letter, one digit, & one special character.
Cloud Provider *
aws Amazon Web Services
More cloud providers coming soon.
Region *
Select region⌄
Region affects latency and price. Pick the one nearest your users. We preselect the closest region to you.
Account *
Where should this database run? Use your own AWS account (you keep full ownership of the data and infrastructure, and pay AWS directly) or run it on Selfhost.dev's account (nothing to set up).
Recommended
Choose / Link Your Cloud Account
Run in your own AWS account. You keep ownership of the data and infrastructure, and you can take it with you.
Use Selfhost.dev's cloud account
No setup required. We'll provision and manage the cloud infrastructure for you.
Multi AZ Recommended
This means your data or service is stored across multiple separate data centers within the same region. So even if one data center goes down, your app keeps running smoothly without interruptions.
Replication Setup:
Replicas are standby copies in other availability zones. Basic (1) covers most needs; Enhanced (2) adds another standby for higher availability.
Basic (1 replica)
Enhanced (2 replicas)
Delete Protection Recommended
This prevents important data or resources from being accidentally deleted. Even if someone tries to remove it, the system will block the action or ask for extra confirmation, keeping your critical information safe.
Instance Size *
Choose instance size⌄
Not sure what to pick? Start small: t4g/t3 sizes handle most apps under moderate load, and you can scale up later.
Network access
Controls the database port on this instance. Hover the info icon for what each mode does.
VPC only
Nothing outside the VPC can reach the database port. Safest default.
Specific IP ranges
Only the IP ranges you list can reach the database port.
Open to the internet
Any address on the internet can reach the database port.
Storage Type *
gp3 (General Purpose SSD)⌄
Latest generation SSD with customizable IOPS and throughput. Best default choice for most workloads.
Storage Size *
GB
IOPS *
3000
Throughput *
125
Automated Backups Recommended
Protect your data with scheduled snapshots. Turns on point-in-time recovery (PITR): restore your database to any moment within your retention window, so a bad deploy or an accidental DROP is recoverable.
Backup Schedule
How often we snapshot your database. More frequent snapshots mean less data lost if something goes wrong.
Every *
24▲
▼
Unit *
Hours▲
▼
Time *
13:00▲
▼
Timezone *
UTC▲
▼
This instance will be backed up every 24 hours at 13:00 (UTC)
Retention Policy
Keep Last *
2snapshots
Older backups auto-deleted
More retained snapshots use a little more storage.
Encryption Recommended
Encrypt your backup snapshots for enhanced security. Protects your data at rest using industry-standard encryption.

Basic Information

✎ Edit
Database Name
my-prod-database
Database Type
Postgres
Database Version
PostgreSQL 18
Cloud Provider
AWS
Password
••••••••

Instance Configuration

✎ Edit
Instance Type
t4g.nano2 vCPU, 0.5 GB RAM
Storage Size
10 GB
Storage Type
gp3 (General Purpose SSD)
IOPS
3000
Throughput
125 MB/s
Network access
VPC onlyNothing outside the VPC can reach the database port.

Cloud Provider

✎ Edit
Provider
AWS
Region
ap-south-1 (Mumbai)
Multi-AZ
ENABLED
Delete Protection
DISABLED
Replication
Basic1 standby replica

Backup Configuration

✎ Edit
Automated Backup
ENABLED
Schedule
Every 24 hours
Time
13:00 (UTC)
Retention
2 snapshots
Encryption
ENABLED

Estimated Monthly Cost

Estimated monthly cost for this configuration. Prices are all-in and include platform management.
Instance Cost$2.76
Storage Cost$1.23
Public IPv4$4.93
Cost per month$8.92
Wallet Balance $1.00Topup
*These prices are an estimate and may vary depending on usage, data transfer & AWS pricing changes.
✓Password generated successfully!×

my-prod-database

PostgreSQL • aws • ap-south-1
Stop
Reboot
Pending
⋮
Metrics
Activity
Alerts
Backups
Connection
Logs
Queries
Configuration

No metrics yet

Metrics will be loaded once the database is provisioned. We start sampling CPU, memory, disk and connections the moment your instance is live.

Waiting for the instance to come up
Instance awsinst_1b124c269f04454f8a50 is now running
◷ 1 minute ago◐ emailnehathakkar
SUCCESS
Created master t4g.nano in ap-south-1 (awsinst_1b124c269f04454f8a50)
◷ 2 minutes ago◐ emailnehathakkar
SUCCESS
Enabled auto-backup: every 24 hours, retain 2 snapshots
◷ 2 minutes ago◐ emailnehathakkar
INFO
Backup policy created from instance
◷ 2 minutes ago◐ emailnehathakkar
SUCCESS
Instance creation initiated
◷ 4 minutes ago◐ emailnehathakkar
SUCCESS
Active AlertsAcknowledgedResolved
Metric Type: All metrics⌄
!
High CPU Usage - Production Cluster
CPU utilisation raised up till 89%
NODE : AP-SOUTH-01
2m agoACKNOWLEDGE
⚠
Latency Spike - prod-app-cluster
P99 latency increased from 45ms to 120ms across European region node
NODE : AP-SOUTH-01
31m agoACKNOWLEDGE
⚠
Connection Timeout - API Gateway
Multiple connection timeouts detected on endpoint
NODE : AP-SOUTH-01AClaimed by Alex
1d agoRESOLVE
!
Storage Expansion - UAT-ENV-APP
Cluster's storage volume increased by 10GB (90% threshold)
NODE : AP-SOUTH-01
1d agoACKNOWLEDGE
i
CPU Usage Drop - Production Cluster
CPU utilisation has dropped by 2%
NODE : AP-SOUTH-01
1d agoACKNOWLEDGE
!
High CPU Usage - Production Cluster
CPU utilisation raised up till 89%
NODE : AP-SOUTH-01
2m agoACKNOWLEDGE
Showing 6 of 40 active incidents ‹123›

Alert Rules

Create Alert
CPU Threshold
Condition
> 90% for 5m
Target
All Clusters
⋮
Disk Capacity
Condition
>= 85%
Target
UAT-ENV-APP
⋮
Replica Lag
Condition
Lag > 10s
⋮
Failed Logins
Condition
> 50 / 1m
⋮
Network Burst
Condition
> 1Gbps / 2m
⋮
Snapshots 0
Policies 1
Point-in-time recovery 0
Take Snapshot

Capture The Moment

Create point-in-time backups you can trust. Take manual snapshots before migrations, updates, deletion or experiments, and restore or reuse them instantly whenever needed.

On-Demand Capture
Capture a database state on demand, with just one click.
Instant Restore
Restore instantly or create a new one with minimal changes.
Safety Checks
Ideal for testing, rollbacks and one-off safety checks.

Endpoint

Connect from your app or a client like psql, mysql, mongosh.

Host65.0.177.158
Port5432
Usernamepostgres
Databasemy-prod-database
EnginePostgreSQL
SSLRequired
Endpoint URL postgresql://postgres:••••••••@65.0.177.158:5432/my-prod-database

Connection Pooling (PgBouncer)

A transactional pool in front of Postgres for higher concurrency.

Set Configuration
Enable PgBouncer to multiplex many app-side connections onto a small Postgres backend
Configure Pooling

Database Users

DBMS-level credentials, separate from your platform login. Provision read-only/read-write/admin credentials.

+ Add user
postgres⋮
◇ Admin▤ postgresActive

Engine and operation logs

Read the database engine log, or the backup, restore and replication logs, without SSH access.

Database Engine ⌄
Lines   100
Fetch Follow live
Snapshot 19 lines Search
2026-08-12 21:14:34.537 UTC [4445] LOG: starting PostgreSQL 18.6 (Ubuntu 18.6-1.pgdg24.04+2) on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit 2026-08-12 21:14:34.538 UTC [4445] LOG: listening on IPv4 address "0.0.0.0", port 5432 2026-08-12 21:14:34.538 UTC [4445] LOG: listening on IPv6 address "::", port 5432 2026-08-12 21:14:34.541 UTC [4445] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2026-08-12 21:14:34.551 UTC [4451] LOG: database system was shut down at 2026-08-12 21:14:31 UTC 2026-08-12 21:14:34.557 UTC [4445] LOG: database system is ready to accept connections 2026-08-12 21:14:38.159 UTC [4445] LOG: received fast shutdown request 2026-08-12 21:14:38.162 UTC [4445] LOG: aborting any active transactions 2026-08-12 21:14:38.166 UTC [4445] LOG: background worker "logical replication launcher" (PID 4454) exited with exit code 1 2026-08-12 21:14:38.167 UTC [4449] LOG: shutting down 2026-08-12 21:14:38.170 UTC [4449] LOG: checkpoint starting: shutdown immediate 2026-08-12 21:14:38.194 UTC [4449] LOG: checkpoint complete: wrote 20 buffers (0.1%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s 2026-08-12 21:14:38.209 UTC [4445] LOG: database system is shut down 2026-08-12 21:14:38.641 UTC [4602] LOG: starting PostgreSQL 18.6 (Ubuntu 18.6-1.pgdg24.04+2) on aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 13.3.0-6ubuntu2~24.04) 13.3.0, 64-bit 2026-08-12 21:14:38.642 UTC [4602] LOG: listening on IPv4 address "0.0.0.0", port 5432 2026-08-12 21:14:38.642 UTC [4602] LOG: listening on IPv6 address "::", port 5432 2026-08-12 21:14:38.645 UTC [4602] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2026-08-12 21:14:38.655 UTC [4608] LOG: database system was shut down at 2026-08-12 21:14:38 UTC 2026-08-12 21:14:38.668 UTC [4602] LOG: database system is ready to accept connections

Query stats

Measure request rate, reliability, connections and the heaviest queries over a window you choose.

10 second window ⌄ ▶ Measure in 2s
Measured at 23:46:51 over a 10 second window.
QUERIES / SEC
0.80
SUCCESS RATE
87.50%
ERROR RATE
12.50%
CONNECTIONS
1
P50 LATENCY
1.50 ms
P95 LATENCY
2.00 ms
P99 LATENCY
2.00 ms

Most called

The queries this database ran most often in the window.

QueryCallsTotalMeanP95P99
SELECT 111.00 ms1.00 ms1.00 ms-
SELECT count(*) AS value FROM pg_stat_replication WHERE state = 'streaming'10.00 ms0.00 ms0.00 ms-
SELECT pg_database_size(current_database()) AS value12.00 ms2.00 ms2.00 ms-
SELECT name, setting FROM pg_settings WHERE name IN ('max_connections','shared_buffers','work_mem','effective_cache_size','maintenance_work_mem')11.00 ms1.00 ms1.00 ms-

General

Display name, port, and delete protection.

Delete protection
Namemy-prod-database
EnginePostgreSQL
Regionap-south-1
Cloudaws
Delete protectionEnabled

Scaling

Instance type, storage, and auto-scaling rules.

Configure scaling
Instance typet4g.nano
Storage typegp3
Storage size10 GB
IOPS3000
Throughput125 MB/s
Auto-scalingDisabled

PostgreSQL parameters

All parameters using their calculated defaults.

No overrides
Open the editor to view current values and override individual parameters.
View parameters
✓Snapshot captured successfully!×
my-prod-database Provisioning
PostgreSQL 18 · t4g.nano · ap-south-1 · 10 GB gp3
0:00
elapsed
✓
Instance requested
PostgreSQL 18 in ap-south-1
+0:00
✓
Machine allocated
t4g.nano in ap-south-1
+0:04
✓
Encrypted storage attached
10 GB gp3, encrypted at rest with an AWS-managed key
+0:08
✓
Automated backups enabled
Scheduled EBS snapshots of the data volume
+0:12
✓
PostgreSQL installed
Agent ran the install on the box
+0:16
✓
Readiness check passed
pg_isready answered on port 5432
+0:20
✓
Connection open
Endpoint reachable at 65.0.177.158:5432
+0:24
✓
Multi AZ standby ready
Basic · 1 standby replica streaming in ap-south-1b
+0:28
Provisioning runs on our side, so closing this tab would not stop it. Stay and the connection details appear here the moment it is done.

my-prod-database is live

PostgreSQL is accepting connections after 0:32. Point your app at it.

×
Connection string
postgresql://postgres:••••••••@65.0.177.158:5432/my-prod-database
psql
psql -h 65.0.177.158 -p 5432 -U postgres -d my-prod-database -W
Password
••••••••
The connection string copies in full, password included. The terminal line asks for the password instead, so a paste never lands in your shell history. Both stay available under Connection.

Databases

Instances, alerts, backups & cloud accounts in one place.

+ Create Database
Still running databases somewhere else?

Our engineers plan and run the move with you, at no extra cost. Tell us what you are on today and we will map it out.

Start a migration ×
Overview
TOTAL DATABASES
1
ACTIVE
1
NOT RUNNING
0
STORAGE USED
1.4 GB
TOTAL CONNECTIONS
11
SYSTEM HEALTH
55%
All Databases
my-prod-databaseRunning⋮
PostgreSQL 18 · t4g.nano · ap-south-1 · 10 GB
CPU
0%
MEM
56%
DISK
14%
HOST65.0.177.158
USERpostgres
2 nodes VPC only Created Aug 12, 2026 Details →
‹ Back

Choose Instance Size

Select a size that fits your performance and cost needs. You can scale up later.
512 MB works for a POC, but production needs at least 1 GB RAM for stability. Sizes below that are marked POC.
Search
Current gen.Graviton poweredGeneral purposeCompute opt.Memory opt.Storage opt.GPUMachine Learning ASIC
t4g.nano General purposeGravitonPOC
2 vCPU, 0.5GB RAM
$2.76 / month
t3a.nano General purposePOC
2 vCPU, 0.5GB RAM
$3.06 / month
t3.nano General purposePOC
2 vCPU, 0.5GB RAM
$5.52 / month
t4g.micro General purposeGraviton
2 vCPU, 1GB RAM
$5.52 / month
t2.nano General purposePOC
1 vCPU, 0.5GB RAM
$6.11 / month
t3a.micro General purpose
2 vCPU, 1GB RAM
$6.11 / month
t3.micro General purpose
2 vCPU, 1GB RAM
$11 / month
× Close
my-prod-database
2 instances in this group
Masterrunning
my-prod-database⋮
PostgreSQL 18 · t4g.nano · ap-south-1
· 10 GB
CPU
1%
MEM
56%
DISK
14%
HOST65.0.177.158
USERpostgres
Created Aug 12, 2026Details →
Replicaprovisioned
my-prod-database-repli…⋮
PostgreSQL 18 · t4g.nano · ap-south-1
· 10 GB
CPU
36%
MEM
61%
DISK
14%
HOSTec2-13-234-88-21.ap-so…
USERpostgres
Created Aug 12, 2026Details →
Create
Provision
Manage