Data API

Transform your PostgreSQL database into a RESTful API instantly with SerenDB's Data API. Build applications faster without writing backend code.

What is the Data API?

The SerenDB Data API automatically generates REST endpoints for your database tables and views, enabling you to:

• Query data using simple HTTP requests

• Insert, update, and delete records via REST

• Secure access with Row-Level Security (RLS)

• Filter and sort data with URL parameters

• Join tables and create complex queries

Key Features

Instant REST API

Every table in your database automatically becomes a REST endpoint. No configuration required.

SQL to REST Conversion

Use our SQL to PostgREST converter tool to translate your SQL queries into REST API calls.

Built-in Security

Leverage PostgreSQL's Row-Level Security (RLS) to control data access at the API level.

PostgREST Compatible

Built on the popular PostgREST specification, ensuring compatibility with existing tools and libraries.

Quick Links

• Get Started - Set up your first Data API endpoint

• Demo Application - Build a complete note-taking app using the Data API

• SQL to REST Converter - Convert SQL queries to REST calls

Use Cases

• Frontend-only applications: Build full-stack apps without a traditional backend

• Mobile applications: Directly connect mobile apps to your database

• Rapid prototyping: Quickly expose data without writing API code

• Microservices: Create data services with minimal overhead

Security Best Practices

Always implement Row-Level Security (RLS) policies when exposing your database through the Data API. See our RLS Tutorial for detailed guidance.

Learn More

Explore the guides to see how the Data API can accelerate your development workflow and simplify your application architecture.