prest

pREST is a lightweight PostgreSQL REST API server that provides high performance and real-time data access.

MCPDataOpen sourcePostgreSQLREST API低代码高性能

Type: MCP
Transport: http
Open source: Yes
GitHub Stars: ★ 4.6k
Source: mcp-github
Repository: github.com/prest/prest

Overview

pREST is a production-ready API server that enables rapid development of high-performance, real-time RESTful APIs on existing or new PostgreSQL databases. It simplifies the API development process by offering a lightweight server configuration, direct SQL query templates, optimized performance, enhanced developer productivity, and authentication and authorization features. With pREST, AI can easily access and manipulate data in PostgreSQL databases, making it suitable for applications requiring efficient data processing.

Capabilities

▪Lightweight server configuration
▪Direct SQL query templates
▪High-performance optimization
▪Enhanced developer productivity
▪Authentication and authorization features
▪Custom routing and middleware

Use cases

Real-time data queryingDatabase API constructionData-driven application developmentExtending existing PostgreSQL applications

Setup

Requires: PostgreSQL 9.5 或更高版本Node 环境

Install using Homebrew: `brew install prestd`; or download and run from GitHub: `go get -u github.com/prest/prest`

This information was compiled by AI from public sources and may contain inaccuracies — please refer to the source.

FAQ

What PostgreSQL versions does pREST support?

Supports PostgreSQL 9.5 or higher.

Does pREST support multi-database mode?

Yes, it supports multi-database mode.

Does the MCP endpoint in pREST support write operations?

The current version of the MCP endpoint only supports read operations.

Related skills

OpenMetadata

OpenMetadata is an open data context layer that provides trustworthy data context and business semantics for AI.

MCP数据治理元数据管理

XHS-Downloader

A link extraction and content collection tool for Xiaohongshu, supporting multiple download and information extraction features.

MCP

unstract

LLM-based tool for extracting structured data from unstructured documents, supporting API deployment and ETL workflows.

MCP

FinanceToolkit

Transparent and efficient financial analysis tool supporting various financial products and metrics.

MCP金融数据分析

deeplake

Deeplake is a data runtime designed for AI agents, offering a serverless multimodal data lake.

Agent SkillAI 数据库多模态数据

skills

Provides real-time market data and options analytics for AI agents.

Agent Skill