publicDatabaseJan 1, 20260 calls

Postgres MCP Template

Curated MCP template for SQL querying, schema inspection, and database operations.

Hosted MCP endpoint

/api/mcp/preset-postgres

Private servers require an Astrail API key in the Authorization header.

MCP client snippets

Claude Desktop config

{
  "mcpServers": {
    "postgres-mcp-template": {
      "url": "/api/mcp/preset-postgres"
    }
  }
}

cURL initialize

curl -sS -X POST "/api/mcp/preset-postgres" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'

cURL tools/list

curl -sS -X POST "/api/mcp/preset-postgres" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":2,"method":"tools/list","params":{}}'

cURL tools/call

curl -sS -X POST "/api/mcp/preset-postgres" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":3,"method":"tools/call","params":{"name":"postgres_describe_schema","arguments":{"schema":"example"}}}'

Runtime behavior

Runtime healthneeds_mapping

Endpoint healthnot_checked

Execution modemapping_required

Deterministic executionNot yet executable

Generated sourceExport only

Endpoint mapRequired

Endpoint mappedNo

Auth-required endpointsNone detected

Browser runtime endpointsNone detected

Last statusnot recorded

Last execution modenot recorded

Last toolnot recorded

Last latencynot recorded

Upstream statusnot recorded

Trace IDnot recorded

Error codenone

Observabilitystructured fallback

Rate limit modestandard

Missing authauth_required

Missing mappingmapping_required

Astrail does not evaluate generated TypeScript inside Next.js. Hosted calls are routed through stored tool metadata and endpoint maps.

Tools

postgres_describe_schema

Inspect tables, columns, indexes, and relationships.

postgres_run_select

Run a reviewed read-only SQL query.

postgres_explain_query

Explain query plan and estimated cost.

server.ts

import { McpServer } from "@modelcontextprotocol/sdk/server/mcp.js";
import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js";
import { z } from "zod";

const server = new McpServer({ name: "Postgres MCP Template", version: "1.0.0" });

// Curated Astrail template. Add the provider API token and replace the
// placeholder handlers with real fetch calls for: postgres_describe_schema, postgres_run_select, postgres_explain_query.

server.tool("template_status", "Confirm this curated MCP template is installed.", z.object({}), async () => ({
  content: [{ type: "text", text: "Template installed. Add provider credentials to enable live API calls." }],
}));

const transport = new StdioServerTransport();
await server.connect(transport);