Skip to content

App backend

PostgREST

Transform your PostgreSQL database into a high-performance RESTful API with PostgREST. Enjoy rapid response times, enhanced security, and seamless scaling for robust, efficient app development.

Deploy PostgREST on Open Source Cloud

  1. Web console: press Launch above, sign in, name the instance and create it.
  2. Command line: with your personal access token in OSC_ACCESS_TOKEN, run npx -y @osaas/cli@latest create postgrest-postgrest myinstance. Add -o Key=Value for any required settings.
  3. Your AI agent: connect it to the OSC MCP server at https://mcp.osaas.io/mcp and ask: β€œCreate an instance of PostgREST on Open Source Cloud and give me its URL.” How to connect

What it costs

One running PostgREST instance uses 10 tokens a day. The free Basic plan's 100 one-time tokens run it for about 10 days. On Personal (40 tokens a day) one instance runs continuously.

See plans and token allowances

Open source, no lock-in

PostgREST is built from the open source project at github.com/PostgREST/postgrest. You can run the same project on your own infrastructure or another cloud whenever you want, and take your data with you.

Questions about PostgREST

How much does PostgREST cost on Open Source Cloud?

One running PostgREST instance uses 10 tokens a day. The free Basic plan's 100 one-time tokens run it for about 10 days. On Personal (40 tokens a day) one instance runs continuously. Prices and allowances are on https://www.osaas.io/pricing.

How do I deploy PostgREST?

Three ways: press Launch to create it in the web console; run npx -y @osaas/cli@latest create postgrest-postgrest myinstance with OSC_ACCESS_TOKEN set (add -o Key=Value for any required settings); or connect your AI agent to the OSC MCP server at https://mcp.osaas.io/mcp and ask it to "Create an instance of PostgREST on Open Source Cloud and give me its URL."

Can I move PostgREST off Open Source Cloud later?

Yes. PostgREST is open source, built from https://github.com/PostgREST/postgrest, so you can run the same project on your own infrastructure or another cloud and take your data with you.

Where is PostgREST documented?

The Open Source Cloud guide for PostgREST is at https://docs.osaas.io/osaas.wiki/Service%3A-PostgREST.html.