prest/prest

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

What it solves

It eliminates the need to hand-write backend code to expose a PostgreSQL database as an API. It provides an instant REST and Model Context Protocol (MCP) interface for existing or new databases, allowing developers to interact with their data via standard HTTP requests.

How it works

By pointing the tool at a PostgreSQL database (version 9.5 or higher), it automatically generates API endpoints. It supports CRUD operations, custom SQL routes, and a read-only MCP endpoint. It also includes built-in authentication and Access Control Lists (ACL) to manage data access.

Who it’s for

Developers who want to quickly deploy a production-ready API on top of their Postgres database without building a custom backend from scratch.

Highlights

  • Instant API Generation: Automatically creates REST and MCP APIs from database schemas.
  • MCP Support: Provides a read-only MCP endpoint specifically for AI clients like Cursor and Claude.
  • Production Ready: Includes authentication, ACL, and support for multi-database configurations.
  • Flexible Deployment: Can be deployed via Docker, Homebrew, Go, or Heroku.

Related

  • Project
    FreePeak/db-mcp-server

    A multi-database server implementing the Model Context Protocol (MCP) that provides AI assistants with structured and secure access to multiple database engines.

  • Project
    mattt/emcee

    A tool that converts any web application with an OpenAPI specification into a Model Context Protocol (MCP) server, allowing AI models to use the API as a tool.

  • Project
    knowsuchagency/mcp2cli

    mcp2cli is a runtime CLI generator that turns MCP servers, OpenAPI specs, or GraphQL endpoints into instant command‑line tools. It supports OAuth, secret‑safe flags, baked configurations, usage‑aware ranking, and machine‑readable JSON output, enabling LLM agents and developers to call APIs with minimal token overhead.

  • Project
    modelcontextprotocol/registry

    A centralized registry and API for Model Context Protocol (MCP) servers, functioning as an app store for discovery and integration.

  • Project
    SoftInstigate/restheart

    An open-source backend for MongoDB that instantly generates REST, GraphQL, and WebSocket APIs with built-in authentication and no backend code required.