prest/prest

Instant REST and MCP APIs for PostgreSQL and MySQL, on existing or new databases. CRUD, custom SQL routes, auth and ACL without writing a backend. Low-code, ⚡ realtime, high-performance. Native MySQL support since v2.5.

What it solves

It eliminates the need to manually write backend code to expose a database as an API. It provides an instant, production-ready REST and Model Context Protocol (MCP) API layer on top of existing or new SQL databases.

How it works

By pointing pRESTd to a PostgreSQL or MySQL database, it automatically generates API endpoints based on the database schema. It supports CRUD operations, custom SQL routes, authentication, and Access Control Lists (ACL). It also provides a read-only MCP endpoint specifically for AI clients like Cursor and Claude.

Who it’s for

Developers who want to quickly turn their SQL database into a functional API without building a custom backend, and those looking to integrate their database with AI agents via the Model Context Protocol.

Highlights

  • Multi-Database Support: Works with PostgreSQL 9.5+ (default) and MySQL 8.0.19+.
  • AI Integration: Includes a read-only MCP endpoint for compatibility with AI clients.
  • Customization: Supports custom SQL routes with secure value binding to prevent SQL injection.
  • Production Ready: Features built-in authentication and ACL for secure data access.

Related

  • Project
    harsha-iiiv/openapi-mcp-generator

    A CLI tool that converts OpenAPI specifications into ready-to-use Model Context Protocol (MCP) servers, enabling AI agents to interact with REST APIs through automated proxying and schema validation.

  • Project
    HelpCode-ai/anythingmcp

    AnythingMCP is an open‑source, self‑hosted gateway that converts REST, SOAP, GraphQL, OData, or SQL services into MCP “tools” usable by Claude, ChatGPT, Copilot and other LLM clients. It ships with 352 pre‑built connectors (SAP, Etsy, Amazon Seller, etc.), a visual editor for field‑level privacy, RBAC/SSO, audit logging, and can be run via a one‑line Docker‑compose command or deployed as a managed cloud service.

  • 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 databases.

  • Project
    mattt/emcee

    emcee is a Model Context Protocol (MCP) server that enables AI applications to interact with any web service by using its OpenAPI specification as a set of tools.

  • Project
    modelcontextprotocol/registry

    MCP Registry is an API‑driven “app store” for Model Context Protocol servers, letting clients discover validated model‑hosting endpoints. It offers a stable v0.1 API, Docker‑based dev setup, a publishing CLI with GitHub/DNS auth, and community‑driven governance.