pREST

Open source

A Go server that turns existing PostgreSQL or MySQL databases into REST and read-only MCP APIs, with custom SQL routes, auth and ACL.

Open-source alternative to

GitHub stars
4.6k
Last 30 days
+10(+0%)
Last commit
yesterday
Repository age
10 years
Version
v2.5.3
Licence
MIT
Self-hosted
Yes

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
Tags
rest-api
postgresql
mysql
mcp
backend
golang
low-code
self-hosted

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

SaaS alternatives to pREST

See all