prest
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new, MCP server
Safety scan
A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.
Check it deeper on your machine
It has changed since its scan on 11 Nov 2026.
As a Claude Code plugin, install it and then ask Claude Code:
/plugin marketplace add keithmackay/mackayi/plugin install scanskillsafety@mackayiDo a deep scan of https://github.com/prest/prest with scanskillsafety
Or from a terminal, clone it and run it:
git clone https://github.com/keithmackay/scanskillsafety-skill ~/.claude/skills/scanskillsafetynode ~/.claude/skills/scanskillsafety/cli.cjs --deep 'https://github.com/prest/prest'
It checks the exact commit: every file, its packages against OSV (api.osv.dev), how it compares with this page's scan (findsafeskills.com receives the repository's address), and, if you agree, Claude reading every file with your own Claude subscription. It never runs the code.
Badge for your README
Markdown
[](/listings/prest--prest)HTML
<a href="/listings/prest--prest"><img src="/api/listings/prest--prest/badge.svg" alt="findsafeskills safety rating" /></a>Install
Install instructions from the README
As written by the repo's author. findsafeskills has not verified these steps.
Install and run options (Docker, Homebrew, or Go) are documented in [Get pREST](https://docs.prestd.com/get-prest). Point pREST at Postgres (`PREST_PG_URL` or `pg.*` / `DATABASE_URL`), then call:
GET /{database}/{schema}/{table}See [Configuring pREST](https://docs.prestd.com/get-started/configuring-prest) for auth, ACL, custom queries, and MCP.
What was scanned
The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.
README.md · README · 257 lines
View this file on GitHub (read at the repository's current version: the scan did not record which commit it read)
This file has changed since it was scanned, so this is not exactly the text that was scanned, and no line is marked. The findings are listed with the safety scan above.
- # pRESTd
- [](https://github.com/prest/prest/actions/workflows/test-unit.yml)
- [](https://pkg.go.dev/github.com/prest/prest/v2)
- [](https://goreportcard.com/report/github.com/prest/prest)
- [](https://codecov.io/gh/prest/prest)
- [](https://formulae.brew.sh/formula/prestd)
- [](https://discord.gg/JnRjvu39w8)
- _p_**REST** (**P**_ostgreSQL_ **REST**) is a production-ready API that delivers instant REST and Model Context Protocol (MCP) APIs on your existing or new SQL database — CRUD, custom SQL routes, auth, ACL, and a read-only MCP endpoint — without hand-writing a backend.
- PostgreSQL 9.5+ is the default engine. **MySQL 8.0.19+** is a separate native dialect from [v2.5.0](https://docs.prestd.com/releases/v2.5.0). Read-only MCP on MySQL is [v2.5.1](https://docs.prestd.com/releases/v2.5.1). Set `engine = "mysql"` to select it. An unset `engine` stays PostgreSQL. MariaDB, TiDB, and Aurora MySQL stay on the [roadmap](https://docs.prestd.com/databases/roadmap).
- > PostgreSQL 9.5+ (default). MySQL 8.0.19+ with `engine = "mysql"`.
- Contributor License Agreement — [](https://cla-assistant.io/prest/prest)
- <a href="https://www.producthunt.com/posts/prest?utm_source=badge-featured&utm_medium=badge&utm_souce=badge-prest" target="_blank"><img src="https://api.producthunt.com/widgets/embed-image/v1/featured.svg?post_id=303506&theme=light" alt="pREST - instant, realtime, high-performance on PostgreSQL | Product Hunt" style="width: 250px; height: 54px;" width="250" height="54" /></a>
- ## Documentation
- **Full documentation lives at [docs.prestd.com](https://docs.prestd.com/).**
- | Topic | Link |
- |-------|------|
- | Get pREST (Docker, Homebrew, Go) | [Get pREST](https://docs.prestd.com/get-prest) |
- | Configuration | [Configuring pREST](https://docs.prestd.com/get-started/configuring-prest) |
- | API reference | [API Reference](https://docs.prestd.com/api-reference) |
- | MCP over HTTP | [MCP over HTTP](https://docs.prestd.com/get-started/mcp-over-http) |
- | Multi-database | [Multi-database](https://docs.prestd.com/get-started/multi-database) |
- | Databases & roadmap | [Databases](https://docs.prestd.com/databases) · [Roadmap](https://docs.prestd.com/databases/roadmap) |
- | MySQL 8 | [MySQL](https://docs.prestd.com/databases/mysql) · [v2.5.1](https://docs.prestd.com/releases/v2.5.1) |
- | AI clients (Cursor, Claude, …) | [AI and MCP](https://docs.prestd.com/ai) |
- ## Quick start
- Install and run options (Docker, Homebrew, or Go) are documented in [Get pREST](https://docs.prestd.com/get-prest). Point pREST at Postgres (`PREST_PG_URL` or `pg.*` / `DATABASE_URL`), then call:
- ```http
- GET /{database}/{schema}/{table}
- ```
- MySQL 8.0.19+ uses the same path. `{schema}` is the MySQL database. Set the engine and a `mysql://` URL. The port defaults to 3306 when unset. `PREST_DB_*` is read first, then the legacy `PREST_PG_*` names:
- ```toml
- engine = "mysql"
- [pg]
- url = "mysql://user:pass@localhost:3306/mydb"
- ```
- ```sh
- export PREST_ENGINE=mysql
- export PREST_DB_URL='mysql://user:pass@localhost:3306/mydb'
- ```
- A missing user or database fails startup. Postgres defaults (user `postgres`, database `prest`, port 5432) are not copied onto a MySQL engine. Guide: [MySQL](https://docs.prestd.com/databases/mysql).
- Set `PREST_PG_TIMEZONE` (IANA name, e.g. `America/Sao_Paulo`) to choose the PostgreSQL session TimeZone; see [`samples/prest.sample.toml`](samples/prest.sample.toml). Postgres and TimescaleDB only; MySQL ignores it.
- Set `PREST_HTTP_ALLOWED_HOSTS` (or `http.allowed_hosts`) to the host names pREST serves, e.g. `api.example.com,.example.org`, to answer any other `Host` header with 400 Bad Request; see [`samples/prest.sample.toml`](samples/prest.sample.toml). Unset, every host is served.
- Set `PREST_HTTP_REQUEST_ID_HEADER` (or `http.request_id_header`) to a header name such as `X-Request-Id` to give every request a correlation ID: the ID a client or proxy sent in that header is kept, otherwise one is generated, and it is returned in the same response header and logged at the end of each access log line; see [`samples/prest.sample.toml`](samples/prest.sample.toml). Unset, no request ID is added.
- See [Configuring pREST](https://docs.prestd.com/get-started/configuring-prest) for auth, ACL, custom queries, and MCP.
- ### Configuration as JSON
- Containers can run without a mounted `prest.toml`. Put the application config (auth, JWT, ACL, queries, cache, CORS, …) in one JSON document in `PREST_CONFIG_JSON`, and keep the listener and database settings in their usual env vars:
- ```sh
- prestd config export-json -f prest.toml > app-config.json
- kubectl create secret generic prest-app-config --from-file=config.json=app-config.json
- ```
- ```sh
- export PREST_PG_URL='postgres://user:pass@db:5432/prest'
- export PREST_CONFIG_JSON="$(cat app-config.json)"
- # or, where multi-line values get mangled:
- export PREST_CONFIG_JSON_B64="$(base64 < app-config.json | tr -d '\n')"
- ```
- - The document is merged over `prest.toml` when there is one. An array replaces the file's array whole, and a `null` is skipped. `PREST_*` env vars still override the document.
- - `[http]`, `[https]`, `engine`, `[pg]`, `[mysql]`, `[[databases]]` and `queries.location` are never read from it: they are ignored with a warning, so a stale export cannot move the port or switch the database.
- - A document that is not a valid JSON object, is over 1 MiB, or puts a value where a table belongs (or the reverse) fails startup instead of falling back to defaults.
- - The export can hold secrets such as `jwt.key`. Store it as a secret.
- ## Serving several databases
- pREST can serve multiple databases in two modes:
- ### Registry mode
- Define a `[[databases]]` registry in `prest.toml` or use environment variables (`DATABASE_ALIAS_<n>` / `DATABASE_URL_<n>`). Aliases may differ from database names, and entries can be on the same host or different hosts:
- ```toml
- [[databases]]
- alias = "main"
- url = "postgres://user:pass@localhost:5432/prest_main?sslmode=disable"
- [[databases]]
- alias = "tenant-1"
- url = "postgres://user:pass@localhost:5432/tenant_1?sslmode=disable"
- [[databases]]
- alias = "reporting"
- url = "mysql://user:pass@127.0.0.1:3306/reports?tls=false"
- ```
- Or via environment:
- ```sh
- DATABASE_ALIAS_1=main
- DATABASE_URL_1="postgres://user:pass@localhost:5432/prest_main?sslmode=disable"
- DATABASE_ALIAS_2=tenant-1
- DATABASE_URL_2="postgres://user:pass@localhost:5432/tenant_1?sslmode=disable"
- ```
- An entry that is unreachable at start-up is logged and answers 503 ("database unavailable") until it comes up; start-up fails only when every entry is unreachable or the configuration is invalid.
- ### No-registry mode
- Use `pg.database` plus `pg.allowed_databases` on the `[pg]` host with the `[pg]` credentials. Both Postgres and MySQL are supported. On MySQL, `{schema}` must equal `{database}`:
- ```toml
- [pg]
- database = "prest"
- allowed_databases = ["secondary-db"]
- ```
- Or via environment (comma-separated for allowed databases):
- ```sh
- PREST_PG_DATABASE=prest
- PREST_PG_ALLOWED_DATABASES=secondary-db,another-db
- # or for MySQL:
- PREST_DB_DATABASE=mydb
- PREST_DB_ALLOWED_DATABASES=other-db
- ```
- ### Catalog and MCP
- The `/databases` endpoint and MCP `prest.list_databases` show only the served databases. In registry mode, that is the configured aliases. Without a registry, that is `pg.database` plus `pg.allowed_databases`.
- Postgres supports up to 64 open pools. MySQL creates one pool per served database.
- ### Migrating from `pg.single`
- The `pg.single` configuration key has been removed and is ignored with a warning. Behavior changes:
- - **Allow-listed names are always served.** Previously, `pg.single = true` (the default) required requests to be for the main `pg.database`; allow-listed names were ignored. Now they are served whether the deprecated key is set or not.
- - **A registry is no longer limited to `pg.database`.** Previously, with both a registry and `pg.single = true`, every request was restricted to the main database. Now a registry serves its configured aliases freely.
- - **`/databases` and MCP list only served databases.** Requests for unlisted databases return 400 "database not registered".
- - **On MySQL without a registry, `/{database}/{other-schema}/…` returns 404.** On MySQL a schema is a database, so `{schema}` must equal `{database}`. Previously any database the MySQL user had grants on was reachable through `pg.database`.
- ## Passing values to query scripts
- Values a `_QUERIES` script template interpolates become part of the SQL text, so
- pREST screens them: anything carrying quotes, `--`, `::`, or — for multi-word
- values — a SQL keyword is refused, and a refused value that is interpolated fails
- the request with `400`.
- Bind free-form values instead, and the screen does not apply at all. On PostgreSQL,
- a bound value travels to the database out of band, where it can never be parsed as SQL:
- ```sql
- -- interpolated: screened, and rejected for values like 'compra do mes'
- SELECT * FROM articles WHERE slug = '{{.slug}}'
- -- bound: the caller's value arrives verbatim, whatever it contains
- SELECT * FROM articles WHERE slug = {{sqlVal "slug"}}
- ```
- | Helper | Use for | Renders |
- |--------|---------|---------|
- | `{{sqlVal "key"}}` | a single value | `$1` |
- | `{{sqlList "key"}}` | a repeated query parameter (`?tag=a&tag=b`) | `($1,$2)` |
- | `{{ident "key"}}` | a table/column name, which cannot be bound | `"public"."users"` |
- That table is the PostgreSQL rendering. On MySQL, `{{sqlVal "key"}}` renders `?`, `{{sqlList "key"}}` renders `(?,?)`, and `{{ident "key"}}` renders backtick names such as `` `shop`.`users` ``. With the default `prepare = false`, MySQL interpolates those `?` placeholders into the statement. `prepare = true` uses binary prepared statements, and then the values travel out of band.
- `sqlVal` and `sqlList` also reach headers as `{{sqlVal "header.X-Application"}}`.
- Credential headers (`Authorization`, `Cookie`, …) are always withheld.
- Prefer binding for anything user-supplied — search phrases especially, since a
- phrase containing a common word such as `do`, `as` or `or` is exactly what the
- interpolation screen refuses.
- ## 1-Click Deploy
- ### Heroku
- Deploy to Heroku and get a realtime RESTful API backed by Heroku Postgres:
- [](https://heroku.com/deploy?template=https://github.com/prest/prest-heroku)
- More: [Deploy in Heroku](https://docs.prestd.com/deployment/deploy-in-heroku).
- ## Contributing
- Contributions are welcome. See the [Development Guide](https://docs.prestd.com/get-prest/development-guide) and [Contributing to pREST](https://docs.prestd.com/readme/contributing-to-prestd). Please sign the [CLA](https://cla-assistant.io/prest/prest).
- Questions? [GitHub Discussions](https://github.com/prest/prest/discussions) or [Discord](https://discord.gg/JnRjvu39w8).
- ## Testing
- Run unit tests locally:
- ```bash
- make test-unit
- ```
- Run integration suites inside Docker (no local database required):
- ```bash
- # Postgres (full stack: default, auth, multicluster, queries) — also: make test-integration
- make test-integration-postgres
- # TimescaleDB (Timescale-specific E2E only)
- make test-integration-timescaledb
- # MySQL 8 (./integration/mysql/... only). Default image mysql:8.4.
- # Override: MYSQL_IMAGE=mysql:8.0 make test-integration-mysql
- make test-integration-mysql
- ```
- Or with Docker Compose:
- ```bash
- docker compose -f integration/postgres/docker-compose.yml up -d --wait \
- postgres postgres-b db-init prestd prestd-multicluster prestd-auth prestd-queries
- docker compose -f integration/postgres/docker-compose.yml run --rm --no-deps tests
- docker compose -f integration/postgres/docker-compose.yml down -v --remove-orphans
- ```
- Postgres compose runs `./integration/suites/...` and `./integration/postgres/...`.
- TimescaleDB compose runs `./integration/timescaledb/...` only (see `.github/workflows/test-integration-timescaledb.yml`).
- MySQL compose runs `./integration/mysql/...` only (see `.github/workflows/test-integration-mysql.yml`). CI runs `mysql:8.0`, `mysql:8.4`, and `mysql:latest`.
- Network tests require `PREST_TEST_URL` (and flavor-specific URLs for the Postgres job); outside Compose those tests skip when the URLs are unset.
- ## Example: Docker Build
- Build the Docker image locally for development (compiles from source):
- ```bash
- docker build -t prest/prest:latest .
- ```
- For release builds, GoReleaser uses the same `Dockerfile` / `Dockerfile.noplugins` with a pre-built `prestd` binary. Local source builds can pass version metadata via build arguments:
- ```bash
- docker build \
- --build-arg VERSION=v1.0.0 \
- --build-arg COMMIT=hash \
- --build-arg DATE=2026-02-11 \
- -t prest/prest:latest .
- ```
Ratings and comments
Sign in to rate this skill.
Sign inFree to use. If it’s helped, pass it on.