DB2Rest is an open-source tool to rapidly build data access layer with minimal engineering effort. DB2Rest connects with your database to instantly provide REST API to perform data access operations(create, read, insert, update) and execute stored functions/procedures. It takes care of all data access logic and best practices, so that developers can focus on solving complex business logic or building small user-interface components. Thus, DB2Rest can provide significant boost to your application delivery and save engineering cost.

DB2Rest can also act as a secure gateway for legacy databases. This can replace cumbersome, expensive file based data sharing and shared database based integration. The capability to expose existing data to partners and internal developers securely at scale opens up possibilities of innovation and digital transformation.

⭐ If you find DB2Rest useful, please consider adding a star on GitHub! Your support motivates us to add new exciting features.

- No code, no SQL knowledge required, instead use simple REST Query Language (RQL) to retrieve data.
- Accelerate application development by 30x. 
- Unlock databases - secure REST API access for legacy data.
- Blazing fast - No ORM, Single SQL Statement, 1 Database round-trip, does not use code generation.
- Support for advanced custom queries, bulk data insert, and remote stored procedure calls. 
- Best practices for transaction management, connection pooling, encryption, security - RBAC / data entitlement.
- Deploy and run anywhere - on-premise, VM, Kubernetes, or any cloud. 
- Zero downtime - adjusts to your evolving database schema. 
- Compatible with DevOps processes. 

Refer to installation quickstart documentation.

Refer to running with Docker documentation.

• PostgreSQL
• MySQL

Save Record (Create)

• Single record.
• Bulk records.

Query (Read)

• Row Filtering with rSQL DSL.
• Column Selection
• Rename Columns / Alias
• Join - Inner
• Include Join Columns
• Pagination - Limit & Offset
• Sort / Order by
• Group By
• Count
• Join column filter

Edit

• Patch
• Patch with row filtering

Purge (Delete)

• Delete with row filter.
• Safe delete.

Transactions

• Readonly for Select
• Supported for Save, Edit, Purge

Multi-tenancy

• Tenant Id column
• Schema per tenant
• Database per tenant

Schema Support

• Multiple schema support

Connect on Discord

[email protected]

Refer to open roadmap items.