MCP server for PostgREST — 10 tools for CRUD operations, filtering, resource embedding, and RPC on PostgreSQL databases via REST API
Setup
Choose your client, copy the config, then fill in any required environment variables.
Local
claude mcp add postgrest --env POSTGREST_URL='<POSTGREST_URL>' -- npx -y @node2flow/postgrest-mcp~/.codex/config.toml
[mcp_servers.postgrest]
command = "npx"
args = ["-y", "@node2flow/postgrest-mcp"]
env = { POSTGREST_URL = "<POSTGREST_URL>" }
# codex mcp add postgrest --env POSTGREST_URL='<POSTGREST_URL>' -- npx -y @node2flow/postgrest-mcp~/.cursor/mcp.json
{
"mcpServers": {
"postgrest": {
"command": "npx",
"args": [
"-y",
"@node2flow/postgrest-mcp"
],
"env": {
"POSTGREST_URL": "<POSTGREST_URL>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"postgrest": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@node2flow/postgrest-mcp"
],
"env": {
"POSTGREST_URL": "<POSTGREST_URL>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"postgrest": {
"command": "npx",
"args": [
"-y",
"@node2flow/postgrest-mcp"
],
"env": {
"POSTGREST_URL": "<POSTGREST_URL>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"postgrest": {
"command": "npx",
"args": [
"-y",
"@node2flow/postgrest-mcp"
],
"env": {
"POSTGREST_URL": "<POSTGREST_URL>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"postgrest": {
"command": "npx",
"args": [
"-y",
"@node2flow/postgrest-mcp"
],
"env": {
"POSTGREST_URL": "<POSTGREST_URL>"
}
}
}
}Remote
claude mcp add --transport http postgrest https://postgrest-mcp-community.node2flow.net/mcp~/.codex/config.toml
[mcp_servers.postgrest]
url = "https://postgrest-mcp-community.node2flow.net/mcp"
# codex mcp add postgrest --url https://postgrest-mcp-community.node2flow.net/mcp~/.cursor/mcp.json
{
"mcpServers": {
"postgrest": {
"url": "https://postgrest-mcp-community.node2flow.net/mcp"
}
}
}.vscode/mcp.json
{
"servers": {
"postgrest": {
"type": "http",
"url": "https://postgrest-mcp-community.node2flow.net/mcp"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"postgrest": {
"httpUrl": "https://postgrest-mcp-community.node2flow.net/mcp"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"postgrest": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://postgrest-mcp-community.node2flow.net/mcp"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"postgrest": {
"url": "https://postgrest-mcp-community.node2flow.net/mcp"
}
}
}Environment variables
POSTGREST_URL
Replace the placeholders with your own credentials and keep them out of version control.