description	pREST — open-source instant REST (Representational State Transfer) and Model Context Protocol (MCP) APIs for SQL databases. PostgreSQL-first, now multi-database.

pREST

pREST is open-source software that gives you instant REST (Representational State Transfer) and Model Context Protocol (MCP) APIs for SQL databases. Point it at a database and get production-ready HTTP APIs — CRUD, custom SQL routes, auth, ACL, and (from v2.1.0) a read-only MCP endpoint — without hand-writing a backend.

PostgreSQL is the first native adapter. Postgres-compatible engines can be certified on that adapter. MySQL, SQLite, and SQL Server are on the roadmap.

Last updated: July 11, 2026

---

What you get

Capability	Detail
Instant REST	Auto CRUD from schema: GET/POST/PUT/PATCH/DELETE /{db}/{schema}/{table}
MCP over HTTP	Read-only /_mcp for AI agents and IDEs (guide)
Auth & ACL	JWT/auth stack and table-level permissions
Multi-database	Alias registry across clusters (guide)
Custom SQL	Templated /_QUERIES scripts
Plugins	Middleware and endpoint extensions

---

Which databases work today?

Status	Engines
Native	PostgreSQL
Hosted PostgreSQL	Aurora PostgreSQL, Neon, Supabase, AlloyDB
Certified / certifying	CockroachDB, YugabyteDB
Compatible with caveats	TimescaleDB, Amazon Redshift
Roadmap	MySQL, SQLite, SQL Server

Full matrix and labels: Databases. Phases: Database roadmap.

---

Latest release

v2.1.0 — native MCP over HTTP (/_mcp), schema-aware read-only tools, auth/ACL inheritance.

• Docker: prest/prest:v2.1.0
• Go: go install github.com/prest/prest/v2/cmd/prestd@v2.1.0

See Releases and Upgrading to v2.

---

Get started

1. Get pREST — Docker, Homebrew, or Go
2. Configuring pREST
3. API Reference
4. Optional: MCP over HTTP for AI clients
5. Optional: AI and MCP — Cursor, Claude Desktop, stdio adapter

---

FAQ

What is pREST?

pREST is open-source software for instant REST and MCP APIs on SQL databases. It turns HTTP requests into safe, parameterized database operations using your existing schema.

Is pREST only for PostgreSQL?

PostgreSQL is the native adapter today. Engines that speak the PostgreSQL wire protocol (for example YugabyteDB, CockroachDB, Aurora PostgreSQL) can use that adapter with documented support levels. Other SQL families are planned — see the roadmap.

Does pREST provide a REST API?

REST (Representational State Transfer) is an architectural style for building APIs over HTTP. pREST exposes your SQL tables as REST resources at /{database}/{schema}/{table}, mapping standard verbs to CRUD on the same server as MCP.

Yes. Full reference: API Reference.

Does pREST support MCP for AI agents?

MCP (Model Context Protocol) is an open standard for connecting AI apps and agents to tools and data. pREST exposes a read-only MCP endpoint at /_mcp so clients can discover schemas and query tables through the same server as the REST API.

Yes, from v2.1.0. Stdio clients use the pREST MCP Adapter (brew install prest/tap/prest-mcp). Full guide: MCP over HTTP · AI and MCP.

How does pREST work with AI?

Artificial intelligence (AI) here means applications and agents that use models to reason and act on tools and data. pREST connects them to your SQL catalog through read-only MCP at /_mcp and the same auth/ACL as the REST API.

Client setup (adapters, IDE config): AI and MCP · docs.prestd.com/ai.

How do I start quickly?

Use Docker or Homebrew from Get pREST, set PREST_PG_URL (or pg.* / DATABASE_URL), and call http://localhost:3000/{database}/{schema}/{table}.

---

Related documentation

• Key features
• Acronyms (REST, MCP, AI)
• Databases
• Database roadmap
• AI and MCP
• Who uses pREST
• Contributing

Questions? GitHub Discussions or Discord.