#44th of 12 in Backends and databases
prest
REST and read-only MCP API generated from a PostgreSQL or MySQL database
Documentation ↗
(opens in a new tab)Website ↗
(opens in a new tab)Repository on GitHub ↗
(opens in a new tab)
- Stars
- 4.6k
- License
- MIT
- Last commit
- Oct 2026
- Last release
- Oct 2026
- Language
- Go
4,504 on 25 Mar 20264,623 on 14 Oct 2026
From GitHub's daily star counts.
Checked on GitHub.
Overview
pREST is a Go service that exposes tables in an existing PostgreSQL (9.5+) or MySQL (8.0.19+) database as REST endpoints at /{database}/{schema}/{table}, with auth, ACL and custom SQL routes. It also serves a read-only MCP endpoint so AI clients can query the same data. It can serve several databases from a registry or an allow-list.
Who it is for: Developers who want an instant REST or MCP API over an existing SQL database
Strengths
- Generates CRUD REST routes straight from an existing Postgres or MySQL schema
- Custom SQL query scripts support bound parameters via sqlVal, sqlList and ident helpers
- Serves multiple databases via a [[databases]] registry or pg.allowed_databases
- Built-in read-only MCP endpoint, plus auth and ACL configuration
Weaknesses
- Only PostgreSQL and MySQL; MariaDB, TiDB and Aurora MySQL are roadmap items
- Interpolated query-script values are screened and rejected if they contain quotes or SQL keywords
- MySQL support is newer (v2.5.0) and with prepare = false interpolates placeholders
- MCP endpoint is read-only, so AI clients cannot write through it
What it needs
- no GPU
- Docker + Compose
- Needs PostgreSQL 9.5+ or MySQL 8.0.19+
Head to head
Also in Backends and databases
See all 12| Rank | Project | Score |
|---|---|---|
| 1 | appwriteSelf-hostable backend with auth, databases, storage, functions, messaging and hosting | 94 out of 100 |
| 2 | supabasePostgres backend with auth, storage, realtime and edge functions | 73 out of 100 |
| 3 | spacetimedbRelational database that runs your app logic as modules and syncs clients live | 73 out of 100 |
| #5 | parse-serverNode.js backend with REST and GraphQL APIs on MongoDB or PostgreSQL | 70 out of 100 |
| #6 | insforgePostgres-based backend platform that coding agents operate through an MCP server | 69 out of 100 |