hub / github.com/9tigerio/db2rest

github.com/9tigerio/db2rest @1.6.8

repository ↗ · DeepWiki ↗ · release 1.6.8 ↗ · + Follow

1,616 symbols 4,020 edges 354 files 45 documented · 3%

What it actually does AI analysis from the code graph — generated when you open this

loading…

README

DB2Rest is a modern low code REST DATA API platform that automatically creates a secure REST API endpoint for your databases making it easy to build intelligent applications 30x faster. No ORM, no code generation = FAST!

It combines existing/new databases and data-sources with language models (LM/LLMs) and vector stores to rapidly deliver context-aware, reasoning applications without any vendor lock-in. :bulb:

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

Number of GitHub contributors Number of GitHub closed issues Number of GitHub pull requests that are open GitHub release; latest by date GitHub commit activity GitHub top language Docker Pulls

Website

https://db2rest.com

Latest Release

Release	Download/Docker Pull
1.6.5	DB2Rest-1.6.5
1.6.5 (Docker Image)	`docker pull kdhrubo/db2rest:v1.6.5` or `docker pull kdhrubo/db2rest:latest`

Previous Release

Release	Download/Docker Pull
1.6.4	DB2Rest-1.6.4
1.6.4 (Docker Image)	`docker pull kdhrubo/db2rest:v1.6.4` or `docker pull kdhrubo/db2rest:latest`
1.6.1	DB2Rest-1.6.1
1.6.1 (Docker Image)	`docker pull kdhrubo/db2rest:v1.6.1` or `docker pull kdhrubo/db2rest:latest`
1.6.0	DB2Rest-1.6.0
1.6.0 (Docker Image)	`docker pull kdhrubo/db2rest:v1.6.0`
1.5.1	DB2Rest-1.5.1
1.5.1 (Docker Image)	`docker pull kdhrubo/db2rest:v1.5.1`

Last Stable Oracle 9i Release

Release	Download/Docker Pull
Oracle9i - 1.2.3 Final	DB2Rest-Oracle9i-1.2.3

Quick start guides

On premise / On Virtual Machines installation guide.

Docker based installation guide.

Use Cases

Accelerate Application Delivery

DB2Rest provides instant REST API(no code generation) to boost development by 30x. No need to write any code and best practices are built-in saving engineering teams months of effort and cost.

Faster innovation with Gen AI

DB2Rest works hand in glove with modern vector databases and LLM implementations to provide consistent Web APIs to deliver smart applications.

Secure Database Gateway

DB2Rest works as a secure database gateway. This helps enterprises to open up data to internal developers and partners in a safe and agile way which was not possible earlier.

Simplify Integration, Secure data exchange

Often enterprises export data from databases and share large files using SFTP, S3 etc. This process is slow, complex, error-prone and often very costly. It requires heavy maintenance cost and it is not possible to share data in realtime.

Using DB2Rest, it is possible to simplify the process and allow secure data exchange with other parts of the organization without writing a single line of code. There is no direct database based point to point integration and data is available to query anytime.

Supported Databases

PostgreSQL
MySQL
SQLLite
MS SQL Server
Oracle (Including 9i, 10g)
IBM DB2 (11.5.8.0+)
DigitalOcean PostgreSQL
DigitalOcean MySQL
AWS RDS Postgres
AWS RDS MySQL
MariaDB
CockroachDB
Neon
Amazon Lightsail PostgreSQL
Amazon Lightsail MySQL

Planned Database Support

TursoDB
Yugabyte
PlanetScale
CrunchyData
Singlestore
Nile
MindsDB
DuckDB

Contributing

Feel like contributing? That's awesome! We have a contributing guide to help guide you.

Our docsite lives in a separate repo. If you're interested in contributing to the documentation, check out the docsite contribution guide.

Building

Use mvn verify or mvn clean package , etc. from repo root folder, and pass in a value for revision to override the current default version in POMs: mvn -Drevision="1.5.4-SNAPSHOT" clean package -DskipTests

Testing

Running tests simply requires a Docker daemon running, where the build will automatically pull and run testcontainers for the database tests.

Support

Connect on Discord

https://discord.gg/kqeDatPGwU

Contact

help@db2rest.com

Roadmap

Refer to open roadmap items.

IDE Sponsor

Extension points exported contracts — how you extend this code

AuthDataProvider (Interface)

(no doc) [6 implementers]

db2rest-auth/src/main/java/com/homihq/db2rest/auth/common/AuthDataProvider.java

MetaDataExtraction (Interface)

(no doc) [7 implementers]

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/sql/MetaDataExtraction.java

CreateRestApi (Interface)

(no doc) [5 implementers]

db2rest-api/api-rest/src/main/java/com/homihq/db2rest/rest/create/CreateRestApi.java

DataProcessor (Interface)

(no doc) [4 implementers]

db2rest-api/rest-common/src/main/java/com/homihq/db2rest/bulk/DataProcessor.java

SQLTemplateExecutorService (Interface)

(no doc) [17 implementers]

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/service/SQLTemplateExecutorService.java

DeleteRestApi (Interface)

(no doc) [4 implementers]

db2rest-api/api-rest/src/main/java/com/homihq/db2rest/rest/delete/DeleteRestApi.java

FileStreamObserver (Interface)

(no doc) [3 implementers]

db2rest-api/rest-common/src/main/java/com/homihq/db2rest/bulk/FileStreamObserver.java

ProcedureService (Interface)

(no doc) [17 implementers]

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/service/ProcedureService.java

Core symbols most depended-on inside this repo

exists

called by 50

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/DbOperationService.java

delete

called by 43

db2rest-api/api-rest/src/main/java/com/homihq/db2rest/rest/delete/DeleteRestApi.java

patch

called by 39

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/service/UpdateService.java

isDelete

called by 34

db2rest-core/rdbms-common/src/main/java/com/db2rest/jdbc/dialect/model/DbWhere.java

reviewAndSetParam

called by 30

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/rsql/operator/OperatorHandler.java

create

called by 25

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/DbOperationService.java

read

called by 22

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/core/DbOperationService.java

supportAlias

called by 20

db2rest-core/rdbms-common/src/main/java/com/db2rest/jdbc/dialect/Dialect.java

Shape

Method 1,257

Class 329

Interface 27

Enum 3

Languages

Java100%

Modules by API surface

db2rest-api/api-rest/src/main/java/com/homihq/db2rest/config/DbServiceConfiguration.java27 symbols

db2rest-core/rdbms-common/src/main/java/com/db2rest/jdbc/dialect/Dialect.java25 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/pg/PgRSqlOperatorReadControllerTest.java24 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/oracle/OracleRSqlOperatorReadControllerTest.java24 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/mysql/MySQLRSqlOperatorReadControllerTest.java24 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/mssql/MsSQLRSqlOperatorReadControllerTest.java24 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/mariadb/MariaDBRSqlOperatorReadControllerTest.java24 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/db2/Db2RSqlOperatorReadControllerTest.java24 symbols

db2rest-core/rdbms-support/src/main/java/com/homihq/db2rest/jdbc/sql/SqlTypes.java20 symbols

db2rest-api/api-rest/src/test/java/com/homihq/db2rest/rest/sqlite/SQLiteRSqlOperatorReadControllerTest.java18 symbols

db2rest-dialects/db2-dialect/src/main/java/com/db2rest/jdbc/dialect/DB2RestDB2Dialect.java17 symbols

db2rest-api/api-rest/src/main/java/com/homihq/db2rest/config/RestApiConfiguration.java15 symbols

Datastores touched

(mysql)Database · 1 repos

homidbDatabase · 1 repos

postgresDatabase · 1 repos

empdbDatabase · 1 repos

mydatabaseDatabase · 1 repos

sakilaDatabase · 1 repos

your_mysql_databaseDatabase · 1 repos

your_mysql_dbDatabase · 1 repos

For agents

$ claude mcp add db2rest \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact