# DBApi **Repository Path**: starplatinum111/db-api ## Basic Information - **Project Name**: DBApi - **Description**: 🔥🔥🔥零代码开发api服务，只需编写sql，就可以生成http api服务。支持api动态创建，兼容多种数据库。 适用于BI报表、数据可视化大屏的后端接口快速开发。 旨在为企业数据服务的发布提供完整解决方案 - **Primary Language**: Java - **License**: AGPL-3.0 - **Default Branch**: master - **Homepage**: https://www.51dbapi.com - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 703 - **Created**: 2023-07-04 - **Last Updated**: 2023-07-04 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # DBApi ![](https://gitee.com/freakchicken/db-api/badge/star.svg) ![](https://gitee.com/freakchicken/db-api/badge/fork.svg?theme=gvp) ![](https://img.shields.io/github/stars/freakchick/DBApi.svg?logo=GitHub) ![](https://img.shields.io/github/forks/freakchick/DBApi.svg?logo=GitHub) ![](https://img.shields.io/github/watchers/freakchick/DBApi.svg?logo=GitHub) ![](https://img.shields.io/github/v/release/freakchick/DBApi?label=latest&style=flat-square) [![EN doc](https://img.shields.io/badge/document-English-blue.svg)](README.md) [![CN doc](https://img.shields.io/badge/文档-中文版-blue.svg)](README_zh_CN.md) ![](https://freakchicken.gitee.io/images/dbApi//logo.png)

👉 https://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://demo.51dbapi.com:8053/` . ## 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](https://www.bilibili.com/video/BV1pM411k74m) ## Documents [Documents](https://www.51dbapi.com) ## Screenshot ![](https://freakchicken.gitee.io/images/dbApi/20230523/create_ds_page.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/ds_page.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/group_more.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/api_basic.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/api_executor.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/api_plugin.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/sql_debug.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/private_api_request.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/create_client_page.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/client_auth_page.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/ip_firewall.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/monitor.png) ![](https://freakchicken.gitee.io/images/dbApi/20230523/api_record_search.png) ## 联系 ### QQ交流群： - 在群里提问前请先把文档读一遍，并阅读[常见问题汇总](https://www.51dbapi.com/zh/question/) - **提问请高效提问，提供日志、截图、现象、软件版本、部署模式，不要让回答者替你去思考你的问题是什么**
### 微信交流群： - 在群里提问前请先把文档读一遍，并阅读[常见问题汇总](https://www.51dbapi.com/zh/question/) - **提问请高效提问，提供日志、截图、现象、软件版本、部署模式，不要让回答者替你去思考你的问题是什么** > 如果群二维码失效了请加作者微信，拉你入群
### 关于作者 Email: jiangqiang110@126.com