PostgreSQL_
Run a dedicated, native PostgreSQL database provisioned for your project and connect to it directly with standard PostgreSQL clients.
5 min read
Appwrite native PostgreSQL databases give you a managed PostgreSQL instance provisioned for your project. You pick the compute specification, and Appwrite provisions the engine in your project's region with its own storage, networking, and credentials, exposed through a per-database public hostname secured with TLS.
Native databases are different from Appwrite databases like TablesDB, DocumentsDB, and VectorsDB, which are accessed through Appwrite SDKs and platform APIs. A native PostgreSQL database gives you the raw engine. You connect with psql or any PostgreSQL driver and use the full feature set of PostgreSQL, with no Appwrite abstraction layer in between.
If you want Appwrite SDKs, platform permissions, and serverless scaling for app data, start with Appwrite Databases. Native PostgreSQL is for teams who want a managed PostgreSQL engine they can talk to directly with their own ORM, migrations, and drivers.
Supported versions
Appwrite manages the database container, storage, backups, and networking. You bring the application.
| Engine | Default version | Other supported versions | Default port |
|---|---|---|---|
| PostgreSQL | 18 | 17 | 5432 |
The version is selected on create and can be upgraded later. Upgrades run online: a second instance is provisioned on the new version, data is streamed over with logical replication, and traffic cuts over once replication is caught up, with no read or write outages and no manual dump-and-restore.
A new database starts in a provisioning state and becomes ready within a few minutes. Large specifications or high-availability configurations take longer to schedule; poll the database status or watch the Console until it reports ready.
Regions
A native database lives in the same region as the project that owns it. There is no per-database region selector. Each database gets a unique hostname in the form db-<hash>.<region>.appwrite.center, and data does not leave the region.
Feature overview
Connections
Connect with psql or any driver. Credentials are rotatable from the Console and API.
Connection pooling
Per-database connection pooler with automatic read/write split when high availability is enabled.
Extensions
Install PostgreSQL extensions like PostGIS, pgvector, and pg_trgm.
Backups
Scheduled backups, manual backups, restores, and point-in-time recovery.
Branches
Spin up an ephemeral copy of your database in seconds from a storage snapshot.
High availability
Up to five synchronous, semi-synchronous, or asynchronous replicas with automatic failover.
Scaling
Resize compute online and grow storage automatically as your data grows.
Network security
TLS by default, optional IP allowlists, and a dedicated hostname per database.
Monitoring
Live compute, connection, storage, and workload metrics, with an active-connections inspector.
Maintenance
Maintenance windows, online version upgrades, and pause and resume.
Specifications and pricing
Each database runs against one of the following compute specifications, billed monthly:
| Tier | Specification | CPU | Memory | Storage | Bandwidth | Connections | Price |
|---|---|---|---|---|---|---|---|
| Starter | s-1vcpu-1gb | 1 core | 1 GB | 10 GB | 50 GB | 100 | $10/mo |
| Standard | s-2vcpu-2gb | 2 cores | 2 GB | 25 GB | 200 GB | 200 | $20/mo |
| Standard Plus | s-2vcpu-4gb | 2 cores | 4 GB | 50 GB | 400 GB | 500 | $49/mo |
| Professional | s-4vcpu-8gb | 4 cores | 8 GB | 200 GB | 1 TB | 1,000 | $85/mo |
| Business | s-4vcpu-16gb | 4 cores | 16 GB | 500 GB | 2 TB | 2,000 | $160/mo |
| Business Plus | s-4vcpu-32gb | 4 cores | 32 GB | 1 TB | 5 TB | 4,000 | $299/mo |
| Enterprise | s-8vcpu-32gb | 8 cores | 32 GB | 2 TB | 7.5 TB | 5,000 | $425/mo |
| Enterprise Plus | s-8vcpu-64gb | 8 cores | 64 GB | 3 TB | 10 TB | 10,000 | $699/mo |
The Storage and Bandwidth columns are the monthly allowances included with each tier. Usage beyond them is billed as overage, and optional features are billed as add-ons on top of the tier price:
| Add-on | Price |
|---|---|
| Storage overage | $0.125 per GB per month |
| Bandwidth overage | $0.08 per GB per month |
| High availability replica | 50% of the tier price, per replica |
| Point-in-time recovery | 20% of the tier price |
You can resize between tiers at any time with zero downtime.
Limits
The following limits apply per database:
| Limit | Value |
|---|---|
| Databases per project | 10 |
| High availability replicas | 0 - 5 |
| IP allowlist entries | 100 |
| Backup retention | 1 - 365 days |
| Point-in-time recovery window | 1 - 35 days |
| Extensions installed | 50 |
| Max simultaneous connections | 10,000 platform cap, lower on smaller specifications |
Billing and plan requirements
Native databases are available on paid plans, and a payment method must be attached to your organization. Each database is billed by the hour against its compute specification, with separate line items for overages and add-ons. See pricing for details.
Was this page helpful?
Share what worked or what we should fix. Once approved, our agents automatically apply suggested updates to the docs.