GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • 🐘pREST

This view

  • Original page
  • New address

GeezerVison is showing docs.prestd.com — API Reference | pREST

For the complete documentation index, see llms.txt. This page is also available as Markdown.

pREST generates HTTP APIs from your database catalog. Today the native dialect is PostgreSQL (and Postgres-compatible engines documented under Databases). This reference covers endpoints, parameters, auth, and advanced query patterns.

What is REST?

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.

Application backends, mobile and web clients, and any HTTP client that needs CRUD on SQL tables use that surface. This reference documents the endpoints below; see also Parameters and Auth.

prestd implements HTTP verbs that map to SQL data operations on the connected engine.

GET

SQL SELECT (PostgreSQL dialect mapping)

Endpoints
Description

/_health

Liveness probe — pings default database

/_ready

Readiness probe — pings default database and all registered aliases

/_mcp

MCP discovery — server metadata and available read-only tools (guide, stdio adapter)

/databases

List served databases (registry aliases, or pg.database + pg.allowed_databases)

/schemas

List all schemas

/tables

List all tables

/show/{DATABASE}/{SCHEMA}/{TABLE}

Lists table structure - all fields contained in the table

/{DATABASE}/{SCHEMA}

Lists table tables - find by schema

/{DATABASE}/{SCHEMA}/{TABLE}

List all rows, find by database, schema and table

/{DATABASE}/{SCHEMA}/{VIEW}

List all rows, find by database, schema and view

With auth.enabled = true, the catalog routes (/databases, /schemas, /tables, /{DATABASE}/{SCHEMA}) and /show/... require a bearer token and follow table ACL, like CRUD (v2.5.2). pREST's own prest_users and prest_queries tables are never served. See Auth — Routes that require auth and Permissions — Reserved tables.

POST

Endpoints
Description

/_mcp

MCP JSON-RPC — initialize, tools/list, tools/call (guide, stdio adapter)

SQL INSERT (PostgreSQL dialect mapping)

JSON DATA:

PATCH and PUT

SQL UPDATE (PostgreSQL dialect mapping)

Using query string to make filter (WHERE), example:

JSON DATA:

unconditional update can update unwanted record

DELETE

SQL DELETE (PostgreSQL dialect mapping)

Using query string to make filter (WHERE), example:

unconditional delete can delete unwanted record

Related

  • Databases

  • Acronyms (REST, MCP)

  • Parameters

  • MCP over HTTP

  • Auth

PreviousInstall adapter with Homebrew
NextCustom Queries

Last updated 24 days ago

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.