For the complete documentation index, see llms.txt. This page is also available as Markdown.

Databases

Which SQL databases pREST supports today β€” Native PostgreSQL, certified Postgres-compatible engines, and the multi-database roadmap.

This page lists which SQL databases pREST supports today and what is still on the roadmap β€” the canonical support labels.

PostgreSQL is native. Postgres-compatible engines are certified or documented with caveats on that adapter. MySQL, SQLite, and SQL Server are Roadmap until dedicated adapters ship.

Last updated: July 18, 2026


Support labels

Label
Meaning

Native

First-class dialect adapter

Certified

Runs on the native adapter with a published features matrix

Compatible with caveats

Connects via PostgreSQL wire protocol; known gaps documented

Hosted PostgreSQL

Managed PostgreSQL β€” same native adapter

Roadmap

Planned β€” not available yet

Experimental

Incomplete; use only with explicit expectations


PostgreSQL family (available)

Engine
Label
Page

PostgreSQL

Native

Amazon Aurora PostgreSQL

Hosted PostgreSQL

Neon, Supabase, AlloyDB

Hosted PostgreSQL

Same adapter as PostgreSQL β€” use standard DATABASE_URL / pg.*

CockroachDB

Certified (PG wire)

YugabyteDB (YSQL)

Certified (PG wire)

TimescaleDB

Compatible with caveats

Amazon Redshift

Compatible with caveats

Deep how-tos also live under Integrations.


Roadmap families

Engine
Label
Page

MySQL / MariaDB / TiDB / Aurora MySQL

Roadmap (Phase 2)

SQLite

Roadmap (Phase 3)

SQL Server / Azure SQL

Roadmap (Phase 4)

Oracle

Roadmap (Phase 5)

Analytical (DuckDB, ClickHouse, Snowflake, BigQuery)

Separate read-only track

Full phases and architecture notes: Database roadmap.


FAQ

What databases does pREST support?

Today: PostgreSQL (native) and engines that use the PostgreSQL wire protocol, with per-engine matrices. Other SQL families are planned β€” they are not installable yet.

Is Aurora / Neon / Supabase supported?

Yes, as Hosted PostgreSQL. Use the same connection settings as PostgreSQL. See Aurora PostgreSQL.

When will MySQL or SQLite work?

They are Phase 2 and Phase 3 on the roadmap. Do not expect a MySQL or SQLite connection string to work with current releases.


Last updated