If you're an AI reading this: skill.md has everything you need.Read it →
Explorer/MCP/node2flow/postgrest
REMOTE

PostgREST

node2flow/postgrest

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)

10 tools available
The Journeyman
A reasonable amount of history and nothing concerning in the scan.
Time indexed (7mo)
10toolsRemote/ HTTP7moindexed
100% uptime · 244ms avgChecked Sep 7, 2026
Quality Score
63/95
Deep
Risk Score
0/100
Clean
How is this calculated?
Quality Breakdown
Tenure14.7/20
214 days indexed
Capability17.3/25
Tools: 5.3/13 (10 tools)
Description: 5/5
Endpoint: 7/7
Adoption5.8/25
Use count: 5.8/20 (28 uses)
Multi-registry: 0/5 (1 registry)
Reliability25/25
Currently live: 10/10
Uptime history: 15/15 100% (52/52 checks)
Security scan: 0 pts in v1.0; ready to weight when coverage improves
Risk
0Clean
No signals detected.
The scanner shows
10 tools. Nothing caught our attention.
First indexed Feb 14, 2026
Server Profile
Tools catalogued
10
10 tools available. Full list below.
Hosting
Remote / HTTP
Runs on the internet. No access to your filesystem, SSH keys, or environment variables.
Registry presence
Not verified
Not yet verified by the Official MCP Registry.
Liveness
100%
Based on 48 checks. Average response: 244ms.
Publisher Verification
Not yet verified by the Official MCP Registry.
Endpoint
https://postgrest--node2flow.run.tools
Tools (10)
pg_get_schema
Get the PostgREST OpenAPI schema — lists all available tables, views, functions, and their columns/types. Use this first to discover the database structure.
pg_describe_table
Get detailed column information for a table/view — column names, types, formats, required fields, defaults, and constraints. Parsed from the OpenAPI schema.
pg_list_records
List records from a table/view with filtering, column selection, ordering, and pagination. Filter syntax (PostgREST operators): age=gt.18 — greater than status=eq.active — equals name=ilike.*john* — case-insensitive LIKE id=in.(1,2,3) — IN list deleted_at=is.null — NULL check or=(age.lt.18,age.gt.65) — OR conditions Select syntax (column selection + resource embedding): id,name,email — specific columns *,orders(*) — embed related table (JOIN) id,user:user_id(name) — renamed embed with column selection Order syntax: created_at.desc — descending status.asc,name.desc — multiple columns
pg_count_records
Count records in a table/view matching optional filters. Returns count using exact (precise but slower), planned (fast estimate from query planner), or estimated method.
pg_call_function
Call a PostgreSQL function/procedure via RPC. Use POST (default) for volatile functions, GET for immutable/stable functions. Parameters are passed as JSON body (POST) or query string (GET).
pg_insert_records
Insert one or more records into a table. Pass a single object or array of objects. Use return="representation" to get the created records back.
Show all 10 tools ↓
pg_update_records
Update records matching a filter. IMPORTANT: filter is required to prevent accidental full-table updates. Use return="representation" to see updated records.
pg_upsert_records
Insert or update records (upsert). Uses "merge-duplicates" (update existing) or "ignore-duplicates" (skip existing) resolution. Conflict detection uses primary key by default, or specify on_conflict column.
pg_delete_records
Delete records matching a filter. IMPORTANT: filter is required to prevent accidental full-table deletion. Use return="representation" to see deleted records.
pg_replace_record
Full replace (PUT) a single record matching a filter. All columns must be specified including the primary key. Creates the record if it does not exist.

Is this your server?

Create a free RNWY account to connect your on-chain identity to this server. MCP server claiming is coming; register now and you'll be first in line.

Create your account →
More from node2flow
Google Calendar
MCP server for Google Calendar : create events, manage calendars, check availability, and share calendars through 28 tools via the Model Context Protocol. ## Features - Create, update, and delete calendar events (timed and all-day) - Quick add events from natural language - Manage recurring events with RRULE support - Share calendars with ACL (access control) management - Check availability with free/busy queries - Manage multiple calendars and subscriptions - Full OAuth 2.0 authentication with refresh tokens ## 28 Tools **Events (10)**: List, get, create, update (PUT), patch (PATCH), delete, quick add, move, list instances, import **CalendarList (5)**: List subscribed calendars, get entry, add (subscribe), update display settings, remove (unsubscribe) **Calendars (5)**: Get metadata, create, update, delete, clear all events **ACL (5)**: List rules, get rule, create (share), update permission, delete (revoke) **Utility (3)**: Query free/busy, get color palette, list settings ## Configuration - `GOOGLE_CLIENT_ID` : OAuth 2.0 Client ID from Google Cloud Console - `GOOGLE_CLIENT_SECRET` : OAuth 2.0 Client Secret - `GOOGLE_REFRESH_TOKEN` : Refresh token with Calendar scope
Supabase
MCP server for Supabase — 31 tools for database CRUD, storage, auth admin, project management, edge functions, and secrets via REST + Management APIs. ## Features - Database CRUD with PostgREST filtering, resource embedding (JOINs), and RPC - Storage bucket and object management with signed URLs - Auth admin for user creation, updates, bans, and deletion - Project lifecycle management (create, pause, restore) - Execute SQL queries and generate TypeScript types - Edge function inspection and secret/API key management ## 31 Tools - **Database REST (6):** sb_list_records, sb_insert_records, sb_update_records, sb_upsert_records, sb_delete_records, sb_call_function - **Storage (6):** sb_list_buckets, sb_create_bucket, sb_delete_bucket, sb_list_objects, sb_delete_objects, sb_create_signed_url - **Auth Admin (5):** sb_list_users, sb_get_user, sb_create_user, sb_update_user, sb_delete_user - **Projects (5):** sb_list_projects, sb_get_project, sb_create_project, sb_pause_project, sb_restore_project - **Database Management (3):** sb_run_query, sb_list_migrations, sb_get_typescript_types - **Edge Functions (2):** sb_list_functions, sb_get_function - **Secrets & Keys (4):** sb_list_secrets, sb_create_secrets, sb_delete_secrets, sb_list_api_keys ## Configuration - `SUPABASE_URL` — Project URL (e.g. `https://xxx.supabase.co`) — for database, storage, auth tools - `SUPABASE_SERVICE_ROLE_KEY` — Service role key (bypasses RLS) — from Settings → API - `SUPABASE_ACCESS_TOKEN` — Personal access token — for project management tools (from dashboard → Account → Access Tokens)
Slack
MCP server for Slack Web API — send messages, manage channels, search content, and automate your workspace. ## Features - Send, update, delete, and schedule messages with Block Kit support - Manage channels: create, archive, invite/kick members, set topics - Search messages and files with Slack's powerful query syntax - Upload and manage files with 2-step upload process - React to messages, pin items, and manage bookmarks - Browse users, team info, and custom emoji ## 38 Tools **Messages (7)**: send, update, delete, schedule, cancel scheduled, list scheduled, get permalink **Conversations (12)**: list channels, info, history, thread replies, members, create, archive, invite, kick, join, set topic, open DM **Users (2)**: list all, get info **Reactions (3)**: add, remove, get reactions **Search (2)**: search messages, search files **Files (3)**: upload, list, delete **Pins (3)**: pin, unpin, list pins **Bookmarks (4)**: add, edit, remove, list **Team (1)**: get workspace info **Emoji (1)**: list custom emoji ## Configuration - SLACK_BOT_TOKEN — Get one at https://api.slack.com/apps (create app → OAuth & Permissions → Install → copy Bot Token)
Youtube
MCP server for YouTube Data API v3 with OAuth 2.0 authentication. ## Features - Search videos, channels, and playlists with filters (duration, date, region, type) - Get video details — views, likes, comments, duration, tags, thumbnails - Browse channel statistics — subscribers, video count, total views - List and manage playlists — create, update, delete, add/remove videos - Read and post comments — top-level threads, replies, moderation - Rate videos with like/dislike/unrate - Get trending videos by region and category - Automatic access token refresh via OAuth 2.0 ## 20 Tools **Search & Discovery**: search YouTube, get popular/trending videos, list video categories **Videos & Channels**: get video details, get channel info **Playlists**: list playlists, list playlist items, create/update/delete playlist, add/remove playlist item **Comments**: list comment threads, list replies, post comment, reply to comment, update/delete comment **Ratings**: rate video (like/dislike/none) ## Configuration - YOUTUBE_CLIENT_ID — OAuth 2.0 Client ID from https://console.cloud.google.com/apis/credentials - YOUTUBE_CLIENT_SECRET — OAuth 2.0 Client Secret - YOUTUBE_REFRESH_TOKEN — Refresh Token from https://developers.google.com/oauthplayground (scope: youtube)
Telegram-bot
MCP server for Telegram Bot API — send messages, photos, videos, polls, manage chats, webhooks, and callbacks. ## Features - Send text, photo, video, audio, document, location, poll, contact messages - Edit and delete messages - Chat management (info, members, ban/unban) - Webhook setup and management - Callback query handling - Pin/unpin messages, invite links ## 27 Tools **Bot Info**: get bot info, set commands **Send Messages**: text, photo, document, video, audio, location, poll, contact **Edit/Delete**: edit text, edit caption, delete message **Chat**: get info, member count, member details, ban, unban **Webhooks**: set, delete, get webhook info **Callbacks**: answer callback, get file, get profile photos **Pins**: pin, unpin, create invite link ## Configuration - TELEGRAM_BOT_TOKEN — Get one from @BotFather on Telegram
Notion
MCP server for Notion API — manage pages, blocks, databases, data sources, comments, and users. ## Features - Search pages and databases - Full CRUD for pages, blocks, and comments - Database queries with filters and sorts - Data source management (new Notion API) - User and bot information ## 25 Tools **Search**: search workspace **Pages**: create, get, update, move, get property **Blocks**: get, get children, append, update, delete **Data Sources**: create, get, update, query, list templates **Databases**: get, query, create databases **Comments**: create, get, list comments **Users**: list, get user, get bot info ## Configuration - NOTION_API_KEY — Internal Integration Token from https://www.notion.so/my-integrations
Similar servers
NodeAPI
Machine-native GIS processing API for AI agents and developers. Convert, reproject, validate, repair, buffer, clip, dissolve, and tile vector geodata across 25 endpoints. Pay-per-use USDC on Solana Mainnet ($0.01/op). No accounts, no API keys. Remote MCP SSE.
astllm-mcp
An MCP server for efficient code indexing and symbol retrieval using tree-sitter AST parsing to fetch specific functions or classes without loading entire files. It significantly reduces AI token costs by providing O(1) byte-offset access to code components across multiple programming languages.
Openterms-mcp
Cryptographic proof of consent for AI agents. Sign before you act. Policy engine enforces spending caps, action whitelists, and escalation rules. Independently verifiable by anyone.
Aegis-ZK
On-chain trust verification for AI agent tools. Agents query skill attestations, audit levels, and risk scores before running third-party MCP servers, so you know what's safe before you execute.
Satoshidata Wallet Intelligence
Bitcoin wallet intelligence for AI agents: labels, risk signals, transactions, fees, and mempool.
HiveAgent — The Agentzon
498 MCP tools across 12 industry verticals. Marketplace, escrow, DeFi, legal, healthcare, insurance, construction, and trades. USDC payments on Base L2.
Indexed from Smithery · Updates nightlyView on Smithery →