Connecting to SQLite on Layerbase Cloud

Layerbase Cloud exposes SQLite through a PostgreSQL-compatible endpoint so apps can connect over the network while keeping SQLite storage semantics.

Best for: Small apps, prototypes, embedded-data workflows, and services that want a lightweight SQL database with a network endpoint.

1

Open your database in the dashboard

Go to /cloud, click the database you just created, and the connection panel shows the host, port, username, password, and a ready-to-paste connection string for the engine.

Use the generated Postgres-style URL from the dashboard.

2

TLS is required, on by default

Append ?sslmode=require to the connection string.

PostgreSQL-compatible proxy on port 5432

3

Use any standard client

SQLite works with the normal client family for that engine. Start with the dashboard snippet, then move the same URL and credentials into your app environment.

If your client has separate direct, pooled, TLS, or HTTP options, prefer the exact variant shown in Quick Connect.

bashSQLite
psql "postgresql://layerbase:password@your-host.cloud.layerbase.dev:5432/sqlite1?sslmode=require"

SQLite notes

  • Use PostgreSQL client libraries even though the underlying engine is SQLite.
  • SQLite is file-based, so it is best for compact workloads and simple operational shapes.