# PostgREST

> Use this tool when you need to interact with PostgreSQL databases via a REST API, solving problems such as data querying, manipulation, and schema discovery. It accepts inputs like filter syntax, select parameters, and JWT tokens, and outputs data in JSON format, supporting full CRUD operations and stored function calls. Use PostgREST in contexts where a flexible, programmable interface to PostgreSQL data is required, such as web or mobile application development.

Canonical page: https://skillsregistry.net/skills/node2flow-postgrest  
JSON: https://api.skillsregistry.net/v1/skills/node2flow-postgrest

## Description

MCP server for PostgREST — REST API layer for PostgreSQL
   databases.

  ## Features
  - Discover database schema (tables, views, functions,
  columns)
  - Query records with PostgREST filter syntax (eq, gt,
  like, in, fts, or)
  - Resource embedding — JOIN related tables via select
  parameter
  - Full CRUD operations (insert, update, upsert, delete,
  replace)
  - Call stored PostgreSQL functions via RPC
  - Count records with exact, planned, or estimated
  methods

  ## 10 Tools

  **Schema**: get OpenAPI schema, describe table
  columns/types
  **Read**: list records with
  filters/select/order/pagination, count records, call
  functions (RPC)
  **Write**: insert, update, upsert (merge/ignore
  duplicates), delete, replace (PUT)

  ## Configuration
  - POSTGREST_URL — Your PostgREST server URL (e.g.
  http://localhost:3000)
  - POSTGREST_TOKEN — JWT token for authenticated requests
   (optional)

## Trust

- **Trust score (0–1):** 0.89
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [Smithery](https://smithery.ai/server/node2flow/postgrest)
- **Repository:** <https://github.com/node2flow-th/postgrest-mcp-community>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "node2flow-postgrest"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/node2flow-postgrest` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/node2flow-postgrest/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt