About pREST
pREST, short for PostgreSQL REST, delivers REST and Model Context Protocol (MCP) APIs on top of an existing or new SQL database without hand-writing a backend. It covers CRUD, custom SQL routes, authentication, access control and a read-only MCP endpoint. A table is read with a request of the form GET /{database}/{schema}/{table}.
PostgreSQL 9.5 and newer is the default engine. MySQL 8.0.19 and newer is supported as a separate native dialect from v2.5.0, selected by setting the engine to mysql, and read-only MCP on MySQL arrived in v2.5.1. MariaDB, TiDB and Aurora MySQL are listed as roadmap items rather than supported engines.
One instance can serve several databases, either through a registry of aliased connection URLs in prest.toml or environment variables, or through a no-registry mode that lists allowed databases. In registry mode an unreachable entry answers 503 until it comes up. It is installed with Docker, Homebrew or Go, written in Go and MIT licensed, with full documentation at docs.prestd.com.
Key features
- REST APIs generated from existing SQL databases
- CRUD, custom SQL routes, auth and ACL
- PostgreSQL 9.5+ by default, MySQL 8.0.19+ optional
- Read-only MCP endpoint for AI clients
- Serves several databases through a registry or allowed list
- Installs via Docker, Homebrew or Go
- Configured with prest.toml or environment variables
Good fit for
- Instant REST API over a database
- Read-only MCP access for AI clients
- Serving several tenant databases from one instance
pREST: questions and answers
- What is pREST used for?
- pREST is a Go server that turns existing PostgreSQL or MySQL databases into REST and read-only MCP APIs, with custom SQL routes, auth and ACL. It is a good fit for instant REST API over a database, read-only MCP access for AI clients and serving several tenant databases from one instance.
- Is pREST open source?
- Yes. pREST is open source under the MIT licence. Its source code is on GitHub at prest/prest and is written mainly in Go.
- Is pREST free?
- Yes. pREST is open source, so the software itself is free to use.
- Can I self-host pREST?
- Yes. pREST can be self-hosted on your own server or infrastructure.
- What is pREST an alternative to?
- pREST is an open-source alternative to Firebase and Xano. Other open-source alternatives to Firebase include PocketBase, Nhost and FastSchema.
- Is pREST actively maintained?
- Yes. The most recent commit to pREST was on 12 November 2026, and the latest release is v2.5.3, published on 30 October 2026. The project has 4.6k stars on GitHub, with 10 added in the last 30 days.
Open-source alternatives to pREST
See all
PocketBase
Backend as a Service
Open Source realtime backend in 1 file
MITvs Firebase★ 62k
Nhost
Backend as a Service
The Open Source Firebase Alternative with GraphQL.
MITvs Firebase★ 9.4k
FastSchema
Backend as a Service
All-in-One Backend as a Service with Headless CMS Power
MITvs Firebase★ 576
Appwrite
Backend as a Service
Appwrite is an open-source developer platform with Auth, Databases, Storage, Functions, Me
BSD-3-Clausevs Firebase★ 58k
Supabase
Backend as a Service
The Postgres development platform. Supabase gives you a dedicated Postgres database to bui
Apache-2.0vs Firebase★ 115k
PostgREST
Backend as a Service
REST API for any Postgres database
MITvs Xano★ 28k
SaaS alternatives to pREST
See all
Firebase
Backend as a Service
Firebase is Google's mobile and web app development platform, bundling authentication, databases, hosting, messaging and analytics as a managed backend.
SaaS
Xano
Backend as a Service
No-code backend builder with a database, API editor and business logic
SaaS
Backendless
Backend as a Service
Visual backend platform with a database, user management and API services
SaaS
Back4App
Backend as a Service
Hosted backend built on Parse Server with a database, auth and cloud functions
SaaS
PocketBase Cloud
Backend as a Service
Hosting for PocketBase apps with database, auth, API, frontends and backends on one platform and CLI
SaaS
SheetSandbox
Backend as a Service
Turns Google Sheets into a production database for MVPs with simple GET and POST APIs
SaaS
