> For the complete documentation index, see [llms.txt](https://docs.prestd.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.prestd.com/databases.md).

# Databases

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                  | [postgresql.md](/databases/postgresql.md)                         |
| Amazon Aurora PostgreSQL | Hosted PostgreSQL       | [aurora-postgresql.md](/databases/aurora-postgresql.md)           |
| Neon, Supabase, AlloyDB  | Hosted PostgreSQL       | Same adapter as PostgreSQL — use standard `DATABASE_URL` / `pg.*` |
| CockroachDB              | Certified (PG wire)     | [cockroachdb.md](/databases/cockroachdb.md)                       |
| YugabyteDB (YSQL)        | Certified (PG wire)     | [yugabytedb.md](/databases/yugabytedb.md)                         |
| TimescaleDB              | Compatible with caveats | [timescaledb.md](/databases/timescaledb.md)                       |
| Amazon Redshift          | Compatible with caveats | [amazon-redshift.md](/databases/amazon-redshift.md)               |

Deep how-tos also live under [Integrations](/integrations.md).

***

## Roadmap families

| Engine                                               | Label                    | Page                                      |
| ---------------------------------------------------- | ------------------------ | ----------------------------------------- |
| MySQL / MariaDB / TiDB / Aurora MySQL                | Roadmap (Phase 2)        | [mysql.md](/databases/mysql.md)           |
| SQLite                                               | Roadmap (Phase 3)        | [sqlite.md](/databases/sqlite.md)         |
| SQL Server / Azure SQL                               | Roadmap (Phase 4)        | [sql-server.md](/databases/sql-server.md) |
| Oracle                                               | Roadmap (Phase 5)        | See [roadmap.md](/databases/roadmap.md)   |
| Analytical (DuckDB, ClickHouse, Snowflake, BigQuery) | Separate read-only track | See [roadmap.md](/databases/roadmap.md)   |

Full phases and architecture notes: [Database roadmap](/databases/roadmap.md).

***

## 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](/databases/aurora-postgresql.md).

### When will MySQL or SQLite work?

They are Phase 2 and Phase 3 on the [roadmap](/databases/roadmap.md). Do not expect a MySQL or SQLite connection string to work with current releases.

***

## Related

* [Homepage](/readme.md)
* [MCP over HTTP](/get-started/mcp-over-http.md)
* [Configuring pREST](/get-started/configuring-prest.md)
* [Integrations](/integrations.md)
