MCPs › Data & APIs › PostgREST

PostgREST● live

Q: How do I install PostgREST in Claude Code?

Run: claude mcp add --transport http postgrest https://postgrest--node2flow.run.tools

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)

listed on

Smithery

Not monetized yet

Turn PostgREST’s tool calls into revenue: one disclosed sponsored slot, 70% revenue share, fail-open by design.

Add monetization →

Install PostgREST

For anyone using PostgREST — no Lulu account needed

claude mcp add --transport http postgrest https://postgrest--node2flow.run.tools

The MCP Growth Kit — grow the server you just found

9 field-tested tactics as a designed playbook plus skills your coding agent can run. Free.

Get the Kit →

FAQ

How do I install PostgREST in Claude Code?

Run: claude mcp add --transport http postgrest https://postgrest--node2flow.run.tools

Can I add PostgREST as a connector in ChatGPT or Claude.ai?

Yes — it’s a remote MCP server, so no local install is needed.
ChatGPT: Settings → Connectors → Advanced → Developer mode → Add connector, then paste https://postgrest--node2flow.run.tools.
Claude.ai: Settings → Connectors → Add custom connector, then paste the same URL.

Which registries list PostgREST?

smithery

What is PostgREST's trust score?

Unrated out of 100, computed from cross-registry traction signals (installs, stars, registry presence) — never influenced by sponsorship.

Similar servers

Eemblem-mcp29# EmblemAI MCP EmblemAI is a hosted Model Context Protocol server that gives AI agents a full-featured crypto wallet plus **200+ tools** for trading, DeFi, NFTs, and on-chain analytics across **7 blockchains**: - **Bitcoin** — native BTC, Ordinals inscriptions, Runes, BRC-20, Stamps / SRC-20, Alkanes, rare sats - **Solana** — SOL + SPL tokens, Jupiter-routed swaps, Solana memecoin discovery, RugCheck - **Ethereum** — native ETH, ERC-20, ERC-721 / ERC-1155 NFTs, ETH swaps - **Base** — native ETH on L2, ERC-20, NFTs, Clanker discovery - **BSC** — native BNB, BEP-20, FourMeme bonding-curve discovery and trading - **Polygon** — native MATIC, ERC-20, swaps - **Hedera** — HBAR, HTS tokens, MemeJob discovery and trading Plus prediction markets via **Polymarket**, market research, conditional orders (limit / stop-loss / take-profit) on supported chains, and on-chain analytics. ## Quick start The Smithery deployment connects directly to the hosted EmblemAI MCP at `https://emblemvault.ai/api/mcp`. You only need an API key: 1. Sign in at [emblemvault.ai](https://emblemvault.ai). 2. Open **Settings → Vault Access Key** and copy your key. 3. Paste it as the `apiKey` parameter in the Smithery connection form. Browsing tools (`tools/list`) works anonymously, so you can inspect the catalog before authenticating. ## Auth modes | Mode | When to use | Scope | | --- | --- | --- | | **API key** (`x-api-key`) | Unattended agents, cron jobs, server-to-server, any workflow that mints tokens or sends transactions | Full read + write, no expiry until revoked | | **OAuth 2.0 + PKCE** (RFC 7591 Dynamic Client Registration) | Interactive sessions where a human can click a browser popup | Read-only `vault:read`, short-lived JWT | | **x402 micropayments** | Pay-per-call across the public catalog without an account | Per-tool-call USDC settlement | The Smithery deployment defaults to the API-key path, configured via the `apiKey` parameter (sent to the upstream as the `x-api-key` header). ## Enabling transactional tools State-changing tools (sends, swaps, mints, conditional-trade creates) are hidden by default. Opt in by setting the `enableTransactions` parameter to `enabled` — Smithery's gateway forwards it as the `x-mcp-transactions: enabled` header. Transactional tools then surface in `tools/list` with a `-transaction` suffix, which makes them easy to allow- or block-list with wildcard rules in the host client. Note: transactional tools also require API-key auth — OAuth bearers do not pass the `vault:write` gate. ## Specialized listings (filter) The full 200-tool surface is wide. For Bitcoin-only, Solana-only, or any other curated slice, use the stdio bridge `@emblemvault/mcp` (npm) and set: ``` EMBLEMAI_TOOLS_FILTER="bitcoin*,*Rune*,*Inscription*" ``` The bridge applies the glob filter to both `tools/list` and `tools/call`, exposing only the matching subset to the host LLM. The hosted Smithery deployment always exposes the full catalog; the filter is a stdio-side feature. ## Categories Trading · DeFi · NFTs · Wallet · Bitcoin Ordinals · Polymarket prediction markets · Cross-chain · Market analytics · Research / web search. ## Links - Hosted MCP: `https://emblemvault.ai/api/mcp` - Stdio bridge: `@emblemvault/mcp` ([github](https://github.com/EmblemCompany/Agent-skills/tree/main/mcp-bridge)) - Repo: [EmblemCompany/Agent-skills](https://github.com/EmblemCompany/Agent-skills) - Web app: [emblemvault.ai](https://emblemvault.ai) - Glama listing: [glama.ai/mcp/servers/EmblemCompany/Agent-skills](https://glama.ai/mcp/servers/EmblemCompany/Agent-skills) - Docs: [emblemvault.ai/docs/mcp](https://emblemvault.ai/docs/mcp) ## License MIT (stdio bridge + documentation). Hosted MCP is managed SaaS.