A hosted Postgres MCP server for Claude and ChatGPT.

What the assistant gets

Four tools cover schema lookup and queries.

The PostgreSQL connector adds these tools to an MCP server. Turn off any the assistant does not need. A server for analysts might keep all four, and a server for a support team might expose a single saved query instead.

Where it runs

Run one Postgres MCP server for the whole team on qbash.

An open-source server is simplest for one developer on one laptop. For a team, qbash holds a single database connection and grants access person by person.

Your own rules

Wrap a query in a Task when the assistant should follow a fixed path.

A Task is a Python function saved on qbash. This one runs a single approved query for paid orders that have not shipped, and the assistant supplies only the number of days. Add the Task to the same MCP server and the assistant calls it like any other tool.

days = qbash.inputs.get("days")
if days is None:
    days = 2
if not isinstance(days, int) or isinstance(days, bool) or not 1 <= days <= 90:
    raise ValueError("Provide a whole number of days from 1 to 90.")

rows = qbash.integrations.postgres.execute_query(
    query=(
        "SELECT order_id, created_at FROM orders "
        "WHERE status = 'paid' AND shipped_at IS NULL "
        "AND created_at < now() - make_interval(days => $1) "
        "ORDER BY created_at LIMIT 100"
    ),
    query_params=[days],
    read_only=True,
)["result"]

qbash.output({
    "waiting_orders": rows,
    "oldest_order": rows[0]["order_id"] if rows else None,
})

Before you build

Questions