db2rest
Instant no code DATA API platform for relational databases. Connect any database, run anywhere. Power your GENAI application function/tools calls in seconds.
File Explorer
Download Latest Version (.zip)- build-verify.yml
- dockerhub-publish.yml
- maven-central-publish.yml
- oracle9i-central-publish.yml
- snapshot.yml
- FUNDING.yml
- RELEASING.md
- maven-wrapper.properties
- application-db.yml
- application-local.yml
- application-mongo.yml
- application-pg15.yml
- application-pg16.yml
- DisabledExpressionTokenScannerSymbols.java
- CorsFilterConfiguration.java
- DbServiceConfiguration.java
- RestApiConfiguration.java
- WebMvcConfiguration.java
- DatabaseContextRequestInterceptor.java
- AdminController.java
- BulkCreateController.java
- BulkCreateRestApi.java
- CreateController.java
- CreateRestApi.java
- DeleteController.java
- DeleteRestApi.java
- DbInfoController.java
- DbInfoObject.java
- DbInfoRestApi.java
- ColumnObject.java
- SchemaController.java
- SchemaRestApi.java
- TableObject.java
- TableWithColumnsObject.java
- CountQueryController.java
- ExistsQueryController.java
- FindOneController.java
- ReadController.java
- FunctionController.java
- ProcedureController.java
- SQLTemplateController.java
- UpdateController.java
- RdbmsRestApi.java
- Db2restApplication.java
- count.jte
- delete-mssql.jte
- delete.jte
- exists-mssql.jte
- exists.jte
- find-one.jte
- insert.jte
- read-mssql.jte
- read-ora-12.jte
- read-ora-9.jte
- read.jte
- update-mssql.jte
- update.jte
- application.yml
- banner.txt
- DbInfoControllerIntegrationTest.java
- DbInfoControllerTest.java
- SchemaControllerIntegrationTest.java
- SchemaControllerTest.java
- CorsTest.java
- Db2BulkCreateControllerTest.java
- Db2CountControllerTest.java
- Db2CreateControllerTest.java
- Db2DeleteAllTest.java
- Db2DeleteControllerTest.java
- Db2JsonFileCreateControllerTest.java
- Db2ProcedureControllerTest.java
- Db2ReadControllerDefaultFetchLimitTest.java
- Db2ReadControllerTest.java
- Db2RSqlOperatorReadControllerTest.java
- Db2TemplateControllerTest.java
- Db2UpdateControllerTest.java
- OpenApiSpecificationNoSecurityTest.java
- OpenApiSpecificationWithSecurityTest.java
- MariaDBBasicJoinControllerTest.java
- MariaDBBulkCreateControllerTest.java
- MariaDBCountControllerTest.java
- MariaDBCreateControllerTest.java
- MariaDBCrossJoinControllerTest.java
- MariadbDateTimeAllTest.java
- MariaDBDeleteAllTest.java
- MariaDBDeleteControllerTest.java
- MariaDBFunctionControllerTest.java
- MariaDBInnerJoinControllerTest.java
- MariaDBInnerJoinMultiTableControllerTest.java
- MariaDBInnerSelfJoinControllerTest.java
- MariaDBJsonFileCreateControllerTest.java
- MariaDBProcedureControllerTest.java
- MariaDBReadControllerDefaultFetchLimitTest.java
- MariaDBReadControllerTest.java
- MariaDBRSqlOperatorReadControllerTest.java
- MariaDBTemplateControllerTest.java
- MariaDBUpdateControllerTest.java
- MsSQLBaseIntegrationTest.java
- MsSQLBasicJoinControllerTest.java
- MsSQLBulkCreateControllerTest.java
- MsSQLCountControllerTest.java
- MsSQLCreateControllerTest.java
- MsSQLCrossJoinControllerTest.java
- MsSQLDateTimeAllTest.java
- MsSQLDeleteControllerTest.java
- MsSQLDeleteWithNotAllowedSafeDeleteControllerTest.java
- MsSQLExistsControllerTest.java
- MsSQLFindOneControllerTest.java
- MsSQLFunctionControllerTest.java
- MsSQLInnerJoinControllerTest.java
- MsSQLInnerJoinMultiTableControllerTest.java
- MsSQLInnerSelfJoinControllerTest.java
- MsSQLJsonFileCreateControllerTest.java
- MsSQLProcedureControllerTest.java
- MsSQLReadControllerDefaultFetchLimitTest.java
- MsSQLReadControllerTest.java
- MsSQLRSqlOperatorReadControllerTest.java
- MsSQLUpdateControllerTest.java
- CountTwoTablesSameNameDiffSchemaTest.java
- CreateTwoTablesSameNameDiffSchemaTest.java
- DeleteTwoTablesSameNameDiffSchemaTest.java
- MySQLBasicJoinControllerTest.java
- MySQLBulkCreateControllerTest.java
- MySQLCountControllerTest.java
- MySQLCreateControllerTest.java
- MySQLCrossJoinControllerTest.java
- MySQLDateTimeAllTest.java
- MySQLDeleteAllTest.java
- MySQLDeleteControllerTest.java
- MySQLFunctionControllerTest.java
- MySQLInnerJoinControllerTest.java
- MySQLInnerJoinMultiTableControllerTest.java
- MySQLInnerSelfJoinControllerTest.java
- MySQLJsonFileCreateControllerTest.java
- MySQLProcedureControllerTest.java
- MySQLReadControllerDefaultFetchLimitTest.java
- MySQLReadControllerTest.java
- MySQLRSqlOperatorReadControllerTest.java
- MySQLTemplateControllerTest.java
- MySQLUpdateControllerTest.java
- ReadTwoTablesSameNameDiffSchemaTest.java
- UpdateTwoTablesSameNameDiffSchemaTest.java
- OracleBasicJoinControllerTest.java
- OracleBulkCreateControllerTest.java
- OracleCountControllerTest.java
- OracleCreateControllerTest.java
- OracleCrossJoinControllerTest.java
- OracleDateTimeAllTest.java
- OracleDeleteAllTest.java
- OracleDeleteControllerTest.java
- OracleInnerJoinControllerTest.java
- OracleInnerJoinMultiTableControllerTest.java
- OracleInnerSelfJoinControllerTest.java
- OracleJsonFileCreateControllerTest.java
- OracleProcedureControllerTest.java
- OracleReadControllerDefaultFetchLimitTest.java
- OracleReadControllerTest.java
- OracleRSqlOperatorReadControllerTest.java
- OracleTemplateControllerTest.java
- OracleUpdateControllerTest.java
- PgBasicJoinControllerTest.java
- PgBulkCreateControllerTest.java
- PgCountControllerTest.java
- PgCreateControllerTest.java
- PgCrossJoinControllerTest.java
- PGDateTimeAllTest.java
- PgDeleteAllTest.java
- PgDeleteControllerTest.java
- PgExtraFunctionControllerTest.java
- PgFunctionControllerTest.java
- PgInnerJoinControllerTest.java
- PgInnerJoinMultiTableControllerTest.java
- PgInnerSelfJoinControllerTest.java
- PgJsonFileCreateControllerTest.java
- PgMultiTenancyTest.java
- PgProcedureControllerTest.java
- PgReadControllerDefaultFetchLimitTest.java
- PgReadControllerPaginationValidationTest.java
- PgReadControllerTest.java
- PgRSqlOperatorReadControllerTest.java
- PgTemplateControllerTest.java
- PgUpdateControllerTest.java
- SQLiteBulkCreateControllerTest.java
- SQLiteCountControllerTest.java
- SQLiteCreateControllerTest.java
- SQLiteCrossJoinControllerTest.java
- SQLiteDateTimeAllTest.java
- SQLiteDeleteControllerTest.java
- SQLiteInnerJoinControllerTest.java
- SQLiteJsonFileCreateControllerTest.java
- SQLiteReadControllerTest.java
- SQLiteRSqlOperatorReadControllerTest.java
- SQLiteTemplateControllerTest.java
- SQLiteUpdateControllerTest.java
- DateTimeUtil.java
- BaseIntegrationTest.java
- DB2BaseIntegrationTest.java
- DB2ContainerConfiguration.java
- MariaDBBaseIntegrationTest.java
- MariaDBContainerConfiguration.java
- MsSQLServerContainerConfiguration.java
- MySQLBaseIntegrationTest.java
- MySQLContainerConfiguration.java
- OracleBaseIntegrationTest.java
- OracleContainerConfiguration.java
- PostgreSQLBaseIntegrationTest.java
- PostgreSQLContainerConfiguration.java
- SQLiteBaseIntegrationTest.java
- SQLiteContainerConfiguration.java
- db2-sakila-data.sql
- db2-sakila.sql
- mariadb-sakila-data.sql
- mariadb-sakila.sql
- mssql-sakila-data.sql
- mssql-sakila.sql
- mysql-sakila-data.sql
- mysql-sakila.sql
- mysql-wakila-all.sql
- oracle-sakila-data.sql
- oracle-sakila.sql
- pg-sakila-functions.sql
- postgres-sakila-data.sql
- postgres-sakila.sql
- sqlite-sakila-data.sql
- sqlite-sakila.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- select_all.sql
- select_by_id.sql
- select_by_id_is_required.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- select_all.sql
- select_by_id.sql
- select_by_id_is_required.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- select_all.sql
- select_by_id.sql
- select_by_id_is_required.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- select_all.sql
- select_by_id.sql
- select_by_id_is_required.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- delete_from_content.sql
- insert_from_content.sql
- select_all.sql
- select_by_id.sql
- select_by_id_from_content.sql
- select_by_id_is_required.sql
- update_by_id_from_content.sql
- conditional_render_and_op.sql
- conditional_render_join.sql
- select_all.sql
- select_by_id.sql
- actor.json
- actor5mb.json
- BULK_CREATE_ACTOR_REQUEST.json
- BULK_CREATE_DIRECTOR_BAD_REQUEST.json
- BULK_CREATE_DIRECTOR_REQUEST.json
- BULK_CREATE_FILM_BAD_REQUEST.json
- BULK_CREATE_FILM_REQUEST.json
- BULK_CREATE_REVIEW_REQUEST.json
- BULK_RESULT_ACTOR_QUERY.json
- CREATE_ACTOR_REQUEST.json
- CREATE_DIRECTOR_REQUEST.json
- CREATE_EMP_REQUEST.json
- CREATE_FILM_BAD_REQUEST_CSV.csv
- CREATE_FILM_REQUEST.json
- CREATE_FILM_REQUEST_CSV.csv
- CREATE_FILM_REQUEST_ERROR.json
- CREATE_FILM_REQUEST_MISSING_PAYLOAD.json
- CREATE_USER_REQUEST.json
- CREATE_VANITY_VAN_REQUEST.json
- CROSS_JOIN_TOPS.json
- CROSS_JOIN_TOPS_MSSQL.json
- CROSS_JOIN_TOPS_ORACLE.json
- CROSS_JOIN_TOPS_PG.json
- CROSS_JOIN_USERS.json
- CROSS_JOIN_USERS_MSSQL.json
- CROSS_JOIN_USERS_ORACLE.json
- CROSS_JOIN_USERS_PG.json
- director.json
- EMPTY_ACTOR_QUERY.json
- INNER_JOIN.json
- INNER_JOIN_MULTI_TABLE.json
- INNER_JOIN_MULTI_TABLE_ORACLE.json
- INNER_JOIN_ORACLE.json
- INNER_SELF_JOIN.json
- INNER_SELF_JOIN_ORACLE.json
- LEFT_JOIN.json
- LEFT_JOIN_ORACLE.json
- RIGHT_JOIN.json
- RIGHT_JOIN_ORACLE.json
- SINGLE_RESULT_ACTOR_QUERY.json
- UPDATE_ACTOR_REQUEST.json
- UPDATE_EMPLOYEE_REQUEST.json
- UPDATE_FILM_REQUEST.json
- UPDATE_FILMS_REQUEST.json
- UPDATE_NON_EXISTING_FILM_REQUEST.json
- UPDATE_NON_EXISTING_TABLE.json
- application-it-db2.yaml
- application-it-mariadb.yaml
- application-it-mssql.yaml
- application-it-mysql.yaml
- application-it-oracle.yaml
- application-it-pg-mutlitenancy.yaml
- application-it-pg.yaml
- application-it-sqlite.yaml
- auth-apiKey-test.yaml
- auth-basic.yaml
- junit-platform.properties
- pom-oracle9i.xml
- pom.xml
- CSVDataProcessor.java
- DataProcessor.java
- FileStreamObserver.java
- FileSubject.java
- JSONDataProcessor.java
- JsonFileDataProcessor.java
- CorsConfigProperties.java
- DateTimeConfigProperties.java
- DateTimeConfiguration.java
- Db2RestConfigProperties.java
- MultiTenancy.java
- OpenAPIConfiguration.java
- BulkContext.java
- GlobalExceptionHandler.java
- DatabaseConnectionDetail.java
- DatabaseProperties.java
- EnvironmentProperties.java
- pom.xml
- pom.xml
- ApiExcludedResource.java
- ApiKey.java
- ApiResource.java
- AuthData.java
- ResourceRole.java
- RoleDataFilter.java
- User.java
- UserDetail.java
- ApiAuthDataLookup.java
- AuthDataLookup.java
- AuthDataProperties.java
- FileAuthDataLookup.java
- NoAuthdataLookup.java
- AuthException.java
- ApiKeyAuthProvider.java
- BasicAuthProvider.java
- JwtAuthProvider.java
- JwtProperties.java
- AbstractAuthProvider.java
- UnKeyAuthService.java
- UnKeyVerifyRequest.java
- UnKeyVerifyResponse.java
- UnKeyAuthConfiguration.java
- UnKeyAuthFilter.java
- AuthConfiguration.java
- AuthFilter.java
- auth-sample-api-key.yml
- auth-sample.json
- auth-sample.yml
- pom.xml
- CountResponse.java
- CreateBulkResponse.java
- CreateResponse.java
- DeleteResponse.java
- ExistsResponse.java
- UpdateResponse.java
- AuthenticationFailedException.java
- DeleteOpNotAllowedException.java
- GenericDataAccessException.java
- InvalidColumnException.java
- InvalidOperatorException.java
- InvalidPaginationParameterException.java
- InvalidTableException.java
- PathVariableNamesMissingException.java
- PathVariableValuesMissingException.java
- PlaceholderConstraintException.java
- RpcException.java
- SqlTemplateNotFoundException.java
- SqlTemplateReadException.java
- UnsupportedConstraintException.java
- PaginationValidator.java
- DatabaseContextHolder.java
- pom.xml
- ArrayTypeValueHolder.java
- Database.java
- DbAlias.java
- DbColumn.java
- DbJoin.java
- DbSort.java
- DbTable.java
- DbWhere.java
- Dialect.java
- pom.xml
- BulkCreateService.java
- CountQueryService.java
- CreateService.java
- DeleteService.java
- ExistsQueryService.java
- FindOneService.java
- FunctionService.java
- JdbcBulkCreateService.java
- JdbcCountQueryService.java
- JdbcCreateService.java
- JdbcDeleteService.java
- JdbcExistsQueryService.java
- JdbcFindOneService.java
- JdbcFunctionService.java
- JdbcProcedureService.java
- JdbcReadService.java
- JdbcUpdateService.java
- JinJavaTemplateExecutorService.java
- ProcedureService.java
- ReadService.java
- SQLTemplateExecutorService.java
- SubRoutine.java
- UpdateService.java
- DbOperationService.java
- SimpleRowMapper.java
- BindVariable.java
- CreateContext.java
- DeleteContext.java
- FnUtil.java
- InsertableColumn.java
- JoinDetail.java
- Placeholder.java
- QueryRequest.java
- ReadContext.java
- UpdateContext.java
- DbDetailHolder.java
- RoutingDataSource.java
- JoinProcessor.java
- OrderByProcessor.java
- PrimaryKeyProcessor.java
- ReadProcessor.java
- RootTableFieldProcessor.java
- RootTableProcessor.java
- RootWhereProcessor.java
- EndWithOperatorHandler.java
- EqualToOperatorHandler.java
- GreaterThanEqualToOperatorHandler.java
- GreaterThanOperatorHandler.java
- InOperatorHandler.java
- IsNotNullOperatorHandler.java
- IsNullOperatorHandler.java
- JsonbContainOperatorHandler.java
- JsonbEqualToOperatorHandler.java
- JsonbKeyExistsOperatorHandler.java
- JsonContainInArrayOperatorHandler.java
- JsonContainOperatorHandler.java
- LessThanEqualToOperatorHandler.java
- LessThanOperatorHandler.java
- LikeOperatorHandler.java
- NotEqualToOperatorHandler.java
- NotInOperatorHandler.java
- NotLikeOperatorHandler.java
- StartWithOperatorHandler.java
- CustomRSQLOperators.java
- OperatorHandler.java
- OperatorMap.java
- RSQLOperatorHandlers.java
- RSQLParserBuilder.java
- CrossTableColumnResolver.java
- BaseRSQLVisitor.java
- ColumnLabel.java
- DB2DataExtraction.java
- DbMeta.java
- JdbcMetaDataProvider.java
- JdbcTypeJavaClassMappings.java
- MariaDBDataExtraction.java
- MetaDataExtraction.java
- MetaDataTable.java
- MsSQLServerMetaDataExtraction.java
- MySQLDataExtraction.java
- OracleMetaDataExtraction.java
- PostgreSQLDataExclusion.java
- SqlCreatorTemplate.java
- SQLiteDataExtraction.java
- SqlTypes.java
- TSIDProcessor.java
- AliasGenerator.java
- IsRequiredValidator.java
- IsUUIDValidator.java
- ConstraintValidator.java
- CustomPlaceholderValidators.java
- JdbcManager.java
- JdbcOperationService.java
- PaginationValidatorTest.java
- JdbcCreateServiceTest.java
- FnUtilTest.java
- PrimaryKeyProcessorTest.java
- AliasGeneratorTest.java
- IsRequiredValidatorTest.java
- IsUUIDValidatorTest.java
- CustomPlaceholderValidatorsTest.java
- pom.xml
- pom.xml
- DB2RestDB2Dialect.java
- DB2RestDB2DialectTest.java
- TestConfiguration.java
- application-test.yml
- pom.xml
- README.md
- MariaDBDialect.java
- pom.xml
- MsSQLServerDialect.java
- pom.xml
- DB2RestMySQLDialect.java
- pom.xml
- OracleDialect.java
- pom.xml
- OracleDialect.java
- pom.xml
- EnvVarSSLSocketFactory.java
- PgSingleCertValidatingFactory.java
- PostGreSQLDialect.java
- pom.xml
- SQLiteDialect.java
- pom.xml
- pom.xml
- insert.md
- 01-create-schema.sql
- docker-compose.yml
- README.md
- 01-init.sql
- api-interaction.sh
- docker-compose.yml
- run.sh
- 01-init.sql
- api-interaction.sh
- docker-compose.yml
- run.sh
- 01-init.sql
- api-interaction.sh
- docker-compose.yml
- run.sh
- 01-init.sql
- api-interaction.sh
- docker-compose.yml
- run.sh
- 01-init.sql
- api-interaction.sh
- docker-compose.yml
- run.sh
- federation.md
- .gitattributes
- .gitignore
- CONTRIBUTING.md
- db2rest-oas3.json
- Dockerfile
- funding.json
- integration-test-guideline.md
- LICENSE
- mvnw
- mvnw.cmd
- pom.xml
- README.md
π Installation Guide
1. Get the code
git clone https://github.com/9tigerio/db2rest
Downloads the entire project code from GitHub to your computer.
cd db2rest
Moves into the project folder you just downloaded.
2. Docker
Easy RecommendedPrerequisites
- Git Needed to download the project code from GitHub.
- Docker Desktop Needed to build and run containers. Install it and keep it running in the background.
docker compose -f docker-compose/db2/docker-compose.yml up -d --build
Runs the command against the services defined in the compose file.
Run docker compose ps to check the containers are Up. If the README mentions a port, open http://localhost:PORT in your browser.
3. Maven (Java)
MediumPrerequisites
- Git Needed to download the project code from GitHub.
- JDK (Java) Required to build and run Java projects.
- Maven The build tool used for the mvn command.
cd db2rest-api/api-rest
This project's files live in a subfolder, so move into it first.
mvn clean install
Installs dependencies and builds the project using Maven.
A BUILD SUCCESS message means it worked. The output is created under target/.
// repository documentation
Was this content helpful?
(0 ratings)
