PostgREST
Rank #86,210smithery/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)
PostgREST is a Model Context Protocol (MCP) server published by node2flow-th. It ranks #86,210 of 115,460 servers tracked on MCP Toplist, and its repository has 1 GitHub stars. PostgREST is listed across 2 registries — Smithery and Glama, and ships as a single rolling release with no explicit version metadata. It was first listed on Feb 14, 2026.
Ranks ahead of 29,250 of 115,460 servers on MCP Toplist.
Use PostgREST
Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.
claude mcp add --transport http postgrest https://server.smithery.ai/node2flow/postgrest/mcpThis endpoint requires authentication — see the server’s docs for credentials.
[mcp_servers.postgrest]
url = "https://server.smithery.ai/node2flow/postgrest/mcp"Add to ~/.codex/config.toml. This endpoint requires authentication — see the server’s docs for credentials.
https://server.smithery.ai/node2flow/postgrest/mcpSettings → Connectors → “Add custom connector”, then paste this URL. This endpoint requires authentication — see the server’s docs for credentials.
{
"mcpServers": {
"postgrest": {
"url": "https://server.smithery.ai/node2flow/postgrest/mcp"
}
}
}Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). This endpoint requires authentication — see the server’s docs for credentials.
{
"servers": {
"postgrest": {
"type": "http",
"url": "https://server.smithery.ai/node2flow/postgrest/mcp"
}
}
}Save as .vscode/mcp.json in your workspace. This endpoint requires authentication — see the server’s docs for credentials.
{
"mcpServers": {
"postgrest": {
"serverUrl": "https://server.smithery.ai/node2flow/postgrest/mcp"
}
}
}Add to ~/.codeium/windsurf/mcp_config.json. This endpoint requires authentication — see the server’s docs for credentials.
{
"mcpServers": {
"postgrest": {
"url": "https://server.smithery.ai/node2flow/postgrest/mcp"
}
}
}This endpoint requires authentication — see the server’s docs for credentials.
Show your rank
Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.
[](https://mcptoplist.com/server/smithery%2Fnode2flow%2Fpostgrest)<a href="https://mcptoplist.com/server/smithery%2Fnode2flow%2Fpostgrest"><img src="https://mcptoplist.com/badge/smithery%2Fnode2flow%2Fpostgrest.svg" alt="MCP Toplist: #86,210 of 115,460" /></a>Variants: append ?metric=score or ?metric=stars to the image URL.
Listed on 2 registries
node2flow-th
Other servers by node2flow-th
- Notion#52,444
- Airtable#86,197
- Binance#86,198
- Binance TH#86,199
- Bitkub#86,200
- Gemini File Search#86,201
- Gmail#86,202
- Google Calendar#86,203
- Google Docs#86,204
- Google Drive#86,205
- Google Sheets#86,206
- Line-bot#86,208
Not versioned
This server is published through registries that do not expose explicit version metadata, and no GitHub release tags were found on the linked repository. The listing tracks a single rolling release.
Frequently asked questions
- Who maintains PostgREST?
- PostgREST is maintained by node2flow-th, which publishes 21 MCP servers (0 total versions) tracked on MCP Toplist.
- Is PostgREST listed on the Official MCP Registry?
- PostgREST is not on the Official MCP Registry. It is listed on Smithery and Glama.
- How many versions does PostgREST have?
- PostgREST ships as a single rolling release with no explicit version metadata.
- Where can I find the source code for PostgREST?
- The source code for PostgREST is hosted at github.com/node2flow-th/postgrest-mcp-community.