AgentIndex icon
AgentIndex
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Submit Tool
ToolsMCP ServersHOTCategoriesTrendingNewBest ListsCompareGuides
Home/
API Integration/
prest
prest logo

prest

Active·★ 4.6k·MIT·Updated 2026-11-20

pREST (pRESTd) is an open-source, production-ready backend daemon written in Go (MIT license) that instantly exposes existing or new SQL databases as high-performance RESTful and Model Context Protocol (MCP) endpoints. Supporting PostgreSQL 9.5+ as its primary engine and native MySQL 8.0.19+, it eliminates the need to hand-write redundant boilerplate backend CRUD services.

Out of the box, pREST automatically serves parameterized CRUD routes, custom SQL script endpoints, JWT-based authentication, and granular table-level Access Control Lists (ACL). Crucially for modern AI engineering, pREST includes a native read-only MCP server over HTTP, allowing AI coding assistants like Cursor, Claude, and Codex to securely inspect schemas, query tables, and understand live relational datasets without granting raw arbitrary SQL execution privileges.

Because pREST compiles into a single lightweight static binary, deployment via Docker or Homebrew takes seconds with near-zero memory footprint. However, because it maps database tables directly to endpoints, teams must carefully design their schema permissions and ACL rules, and complex multi-table transactional workflows must be expressed through custom SQL files rather than procedural backend code.

This write-up is based on the project's README and public repository data. We have not hand-tested the tool. Data as of 2026-11-12.

License
MIT
Latest release
v2.5.3 · 2026-10-30
Last commit
2026-11-11
Contributors
80
Forks
324
Open issues and PRs
150
First published
2016-11-22

Source: GitHub, npm and PyPI public APIs.

#api#baas#backend#crud#database#docker#golang#instant-api
↗ Visit site★ GitHub
01

Features

01REST CRUD and custom SQL routes.
02Read-only MCP discovery and database access.
03Multi-database registry with database aliases.
02

Why choose it

+Instantly generates complete RESTful CRUD APIs from existing PostgreSQL and MySQL schemas with zero backend code.
+Built-in read-only Model Context Protocol (MCP) endpoint allows AI agents (Cursor, Claude) to safely inspect database schemas.
+Single lightweight Go binary with low memory overhead, ready for instant Docker or Homebrew deployment.
+Robust security layer featuring JWT authentication, table-level ACL rules, and parameterized custom SQL routes.
03

Trade-offs

!Exposing raw database tables requires diligent schema design and strict ACL configuration to prevent data leaks.
!Complex transactional business logic cannot be written imperatively; requires custom SQL files or stored procedures.
!The built-in MCP server endpoint currently supports read-only operations and does not support write mutations.
!Support for MariaDB, TiDB, and Aurora-specific optimizations remains on the future development roadmap.
04

Maintenance check

ActiveChecked: 2026-11-12
Last commit
2026-11-11
Commits, last 90 days
23
Releases, last 90 days
4
Latest release
v2.5.3 (2026-10-30)
Open issues
150
Recent issues with at least one comment
4/7
Commits per week, last 12 weeks
Commits per week, last 12 weeks: 0, 0, 0, 3, 0, 0, 4, 2, 7, 1, 0, 6

Oldest week on the left; the latest four weeks are orange. Source: GitHub commit activity.

Status rule: archived on GitHub = Archived; last commit within 90 days = Active; 91 to 365 days = Slowing; older = Stale. All figures come from the GitHub API on the date shown.

Most discussed open issues

  • #439 Endpoint to execute custom query10 comments · 2020-09-18
  • #353 [Feature Request]Any plan for graphql?10 comments · 2019-04-24
  • #289 Consistent Documentations for Deployment9 comments · 2018-03-20
  • #339 Update database8 comments · 2018-10-22
  • #435 Proposal for API Redesign7 comments · 2020-09-15

Issue titles are quoted from GitHub. Open the link to check whether a problem still applies to the version you use.

05

Compatibility

postgresql
PostgreSQL 9.5+; default engine
Verified via docs
mysql
MySQL 8.0.19+; select the MySQL engine
Verified via docs
docker
Docker deployment documented
Verified via docs
06

Use cases

↳Expose an existing SQL database through an API.
↳Give an AI client read-only database tools.
↳Serve several registered databases through one service.
07

Alternatives

⚡Top VS:
VSnotion-mcp-server★4.7k→VSfusio★2.1k→VSdata-api-builder★1.5k→VSmongodb-mcp-server★1.2k→
notion-mcp-server logo
notion-mcp-server★ 4.7k
Official Notion MCP Server
VSCompare→
fusio logo
fusio★ 2.1k
Self-Hosted API Management for Builders
VSCompare→
data-api-builder logo
data-api-builder★ 1.5k
Data API builder provides modern REST, GraphQL endpoints and MCP tools to your Azure Databases and on-prem stores.
VSCompare→
mongodb-mcp-server logo
mongodb-mcp-server★ 1.2k
A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
VSCompare→
restheart logo
restheart★ 892
The Agent-Ready Backend for MongoDB.
torrent-search-mcp logo
torrent-search-mcp★ 47
MCP/API/WebUI to find torrents programmatically
VSCompare→
tyk logo
tyk★ 10.9k
Open Source API and AI Gateway supporting REST, GraphQL, TCP, gRPC and MCP (Model Context Protocol)
VSCompare→
textbee logo
textbee★ 3.4k
Open-source SMS gateway. Turn your Android phone into an SMS API: send and receive SMS from your apps over REST and webhooks. Self-hostable, with a free hosted plan.
VSCompare→
See all alternatives →

Comments

Log in to leave a comment

No comments yet. Be the first!

On this page
01Features02Why choose it03Trade-offs04Maintenance check05Compatibility06Use cases07Alternatives
prest /
prest
↗

Production-ready Go daemon providing instant RESTful and read-only MCP APIs over PostgreSQL and MySQL databases

4.6k324MIT
Last commit2d ago
StatusActive
CategoryAPI Integration
Contributors80
Latest releasev2.5.3
Links
Documentation↗Discussion↗Issues↗Releases↗
Cloud Infrastructure
Ad

Deploy on DigitalOcean

Host your MCP servers, Docker containers, and AI agents with $200 free credit over 60 days.

Claim $200 Free Credit
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
Best by use caseAboutContactAdvertisePrivacy PolicyTerms of UseQYSGitHubBuy me a coffee ☕

Browse by Category

MCP ServersCode AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.