Fetch data from multiple tables using relationships, without duplicating data.
Reduce multiple network calls with powerful syntax & bulk operations.
Go from simple to complex incrementally. Store structured and unstructured data (JSON).
Use constraints and relationships to capture complex requirements.
Specificy authorization rules based on any property in your table or through relationships.
Add custom roles to enforce different types of authorization rules.
Use a query-builder to grok the data API syntax easily.
Test APIs easily and then generate client side code for your app.
Use a UI to create tables manage your schema and data.
Migrations are automatically generated when you use the UI to create/modify tables.
Use migrations to work in a team and manage multiple environments easily.
Add database features without worrying about connection strings, usernames, passwords and creating model files. Use JSON APIs to work with the database from your backend code.
Directly connect to postgres, whenever you need to!
Use postgres directly for advanced use-cases. E.g:
- Run transactions
- Bulk data import/export
- Create powerful views (temporary tables), aggregations and get instant JSON APIs
Build on a rock-solid scalable database with decades of community knowledge.
Leverage tools from the Postgres ecosystem to accelerate your work as your app grows:
- Language bindings & data connectors