Prest

Name: Prest
Author: prest

by prest

PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new, MCP server

4.6k GitHub

No known CVEs

MIT license

Actively maintained

Last commit 1d ago

Works with most clients

Transport: http

0 tools

Grade F

MCPpedia last refreshed this data 1d ago

Edit this pageView history

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktophttp · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "prest": {
      "command": "<see-readme>",
      "args": []
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/prest)](https://mcppedia.org/s/prest)

Read me

What Prest does

p_REST (P_ostgreSQL REST) is a production-ready API that delivers instant REST and Model Context Protocol (MCP) APIs on top of your existing or new Postgres database—CRUD, custom SQL routes, auth, ACL, and a read-only MCP endpoint—without hand-writing a backend.

Test This Server

This server supports HTTP transport. Be the first to test it — help the community know if it works.

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

42/100across 5 weighted dimensions

How we score →

0255075100

−58

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Prest safe to use?: Prest has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.
How do I install Prest?: Prest can be installed by cloning its GitHub repository and following the setup instructions in the README.
What AI clients work with Prest?: Prest is compatible with claude-desktop, cursor, claude-code. It uses http transport.
Is Prest actively maintained?: Prest is actively maintained — last commit was 1 day ago. It has 4,599 GitHub stars.

Similar servers

Others in data

View all →

Supabase MCP Server97

Manage Supabase projects — databases, auth, storage, and edge functions

2.8k 4

Dbhub96

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.2k 2

PostgreSQL MCP Server96

Query and manage PostgreSQL databases directly from AI assistants

88.9k 1

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

7.0k 4

MCP Security Weekly

Get CVE alerts and security updates for Prest and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

pRESTd

pREST (PostgreSQL REST) is a production-ready API that delivers instant REST and Model Context Protocol (MCP) APIs on top of your existing or new Postgres database—CRUD, custom SQL routes, auth, ACL, and a read-only MCP endpoint—without hand-writing a backend.

PostgreSQL version 9.5 or higher

Contributor License Agreement —

Topic

Link

Get pREST (Docker, Homebrew, Go)

Get pREST

Configuration

Configuring pREST

API reference

API Reference

MCP over HTTP

Multi-database

Databases & roadmap

Databases · Roadmap

AI clients (Cursor, Claude, …)

AI and MCP

Testing

Run unit tests locally:

make test-unit

Run integration suites inside Docker (no local Postgres required):

# Postgres (full stack: default, auth, multicluster, queries) — also: make test-integration make test-integration-postgres # TimescaleDB (Timescale-specific E2E only) make test-integration-timescaledb

Or with Docker Compose:

docker compose -f integration/postgres/docker-compose.yml up -d - ... [View full README on GitHub](https://github.com/prest/prest#readme)

Frequently Asked Questions

Is Prest safe to use?

Prest has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.

How do I install Prest?

Prest can be installed by cloning its GitHub repository and following the setup instructions in the README.

What AI clients work with Prest?

Prest is compatible with claude-desktop, cursor, claude-code. It uses http transport.

Is Prest actively maintained?

Prest is actively maintained — last commit was 1 day ago. It has 4,599 GitHub stars.

pRESTd

PostgreSQL version 9.5 or higher

Contributor License Agreement —

Documentation

Full documentation lives at docs.prestd.com.

Topic	Link
Get pREST (Docker, Homebrew, Go)	Get pREST
Configuration	Configuring pREST
API reference	API Reference
MCP over HTTP	MCP over HTTP
Multi-database	Multi-database
Databases & roadmap	Databases · Roadmap
AI clients (Cursor, Claude, …)	AI and MCP

Quick start

Install and run options (Docker, Homebrew, or Go) are documented in Get pREST. Point pREST at Postgres (PREST_PG_URL or pg.* / DATABASE_URL), then call:

GET /{database}/{schema}/{table}

See Configuring pREST for auth, ACL, custom queries, and MCP.

1-Click Deploy

Heroku

Deploy to Heroku and get a realtime RESTful API backed by Heroku Postgres:

More: Deploy in Heroku.

Contributing

Contributions are welcome. See the Development Guide and Contributing to pREST. Please sign the CLA.

Questions? GitHub Discussions or Discord.

Testing

Run unit tests locally:

make test-unit

Run integration suites inside Docker (no local Postgres required):

# Postgres (full stack: default, auth, multicluster, queries) — also: make test-integration
make test-integration-postgres

# TimescaleDB (Timescale-specific E2E only)
make test-integration-timescaledb

Or with Docker Compose:

docker compose -f integration/postgres/docker-compose.yml up -d -

... [View full README on GitHub](https://github.com/prest/prest#readme)