PostgreSQL

PostgreSQL Hosting with a daily snapshot included

The open source relational database with full SQL, JSONB and extensions such as pgcrypto and pg_trgm, on an isolated instance about 1 ms from your applications.

From R$44.99/mo

~1 ms

Latency to your apps

<10 s

For the database to be ready

v17

PostgreSQL version

TLS

Encrypted connection

The PostgreSQL you already know

Native features work as in the official documentation, with no custom dialect and no special driver.

  • JSONB with GIN indexes

    Store JSON documents in a column and query them with GIN indexes, keeping SQL and joins.

  • MVCC

    Reads don't block writes and writes don't block reads, so long queries don't stall the application.

  • Integrity in the database

    Foreign keys, UNIQUE, CHECK and exclusion constraints keep invalid data out.

  • CTEs and window functions

    Recursive queries, rankings and window aggregations right in SQL.

  • Native full-text search

    tsvector, stemming in several languages and relevance ranking, without running a separate search service.

  • GiST indexes

    Index ranges, geometry and proximity searches with generalized search trees.

  • Row-Level Security

    Per-row policies for multi-tenant applications, enforced by the database itself.

  • Common extensions

    pgcrypto, uuid-ossp, hstore, pg_trgm and citext through CREATE EXTENSION.

Connect with the driver you already use

The dashboard shows the instance's connection URL. Store it in your application's environment variables and use any PostgreSQL driver or ORM.

square-cloud-db-<id>.squareweb.app
postgresql://squarecloud:<password>@square-cloud-db-<id>.squareweb.app:<port>
Works withPrismaDrizzlenode-postgrespsycopgSQLAlchemyHibernate
  • Coming from another provider? Run pg_dump on the source and pg_restore pointed at the new URL.
  • Instance certificates (.pem, .crt and .key) available to download in the dashboard.

What comes with every database

Every instance runs in the same datacenter as your applications, with TLS, a daily snapshot and metrics in the dashboard. You create, size and restore it yourself.

  • Close to your applications

    Your applications connect through the instance address, with TLS, in the same New York datacenter. Average latency stays around 1 ms.

    • About 1 ms average latency from your applications
    • Enterprise NVMe disks
    • Access from outside Square Cloud with host, port and password
    • RAM adjustable in the dashboard
  • Daily snapshot included

    Every database gets an automatic snapshot every 24 hours, on any plan with databases. Before a risky change, take a manual one and restore it in the dashboard if something goes wrong.

    • Automatic daily: the latest kept up to 30 days, older ones 7
    • Manual snapshots kept up to 30 days
    • Restore and download in the dashboard
  • Isolated and encrypted

    Each database runs in its own container, with dedicated vCPU calculated from the allocated RAM and the plan. The connection uses TLS with the instance's own certificate, which you download and renew whenever you want.

    • TLS certificate per instance (.pem, .crt and .key)
    • Password and certificate renewable in the dashboard
    • CPU, memory and network metrics
    • Tier 3 partner datacenter with ISO 27001 and SOC 2 Type II

Combine with other services

Everything in the same dashboard, on the same infrastructure and the same invoice.

A plan for every stage of your project

Start small and scale when you need to, with no loyalty contracts.

Databases are available from the Standard plan.

Compare all plans

4.9 out of 5 · 402 reviews on Google + TrustpilotTrustpilot

Hosted in a partner datacenter with certifications
Tier 3ISO 27001SOC 2 Type IIAlways-On DDoS Protection
Explore our infrastructure

Frequently asked questions about PostgreSQL Hosting

Extensions, JSONB, read scaling and migrating existing PostgreSQL databases.

Ready to scale your project?

Join the 500,000+ developers who have used Square Cloud to host their projects.

  • Predictable pricing
  • No billing surprises
  • Deploy in seconds
  • High availability
  • Scale with stability
  • Automatic restart
  • SSL and security included
  • Isolated containers