/DBApi

零代码开发API,只需要写sql,自动生成http API。A no-code tool to build http API from sql. Only need to write sql , then http API generated automatically. Especially suitable for developing backend service for report.

Primary LanguageJavaApache License 2.0Apache-2.0

DBApi

EN doc CN doc

👉 http://www.51dbapi.com 👈

Summary

  • DBAPI is a low-code tool for developers, it can automatically generate the http API just by writing the sql on the page and configuring the parameters.It can help programmers to quickly develop the back-end data service, especially suitable for the BI reports back-end service development

  • DBAPI is the management center of the entire enterprise data service, is the platform for enterprises to provide external data services.It provides the dynamic creation and release function of data API, the unified management of APIs, and the ability to manage clients.It can monitor the client's request records to the API service and control the client's permission to the API.

  • Experience address: http://www.51dbapi.com:8520/ . Default account: admin/admin (please do not change password)

Features

  • No code, not relying on other software(standalone mode)
  • Supports for stand-alone mode, cluster mode.Support for cloud-native container deployment
  • Dynamic creation and modification for the API or datasource, deployment is fully insensitive for users.
  • Supports the API-level access rights control,Support IP whitelist, blacklist control.
  • Supports all jdbc databases, including mysql/sqlserver/postgreSql/hive/oracle, etc.
  • Supports dynamic sql like mybatis. Supports sql execution and debugging on page.
  • Supports rich plugins, like data transformation plugin,cache plugin, alarm plugin.
  • Supporting API configuration import and export to facilitate API migration from test environment to production environment
  • Supports multiple SQL execution within one API (such as pagination function), and supports transaction.
  • Supports application/json and application/x-www-form-urlencoded
  • Supports the API access records query, the API access information statistics.

Video Tutorial

Video Tutorial

Screenshot