# DBAPI **Repository Path**: freakchicken/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**: 5777 - **Forks**: 703 - **Created**: 2021-01-19 - **Last Updated**: 2025-09-09 ## Categories & Tags **Categories**: database-dev **Tags**: API, 低代码, 数据发布, 接口工具, SQL转API ## 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) [![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://img.51dbapi.com/dbapi/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: https://support.51dbapi.com/#/demo ## Features - No code, not relying on other software(standalone mode) - Supports for stand-alone mode, cluster mode. Supports for `windows` `Linux` `Mac`. - 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. - Support for complex-nested json parameters. - Supports the API access records query, the API access information statistics. ## Download [download](https://www.51dbapi.com/v4.0.0/download/) ## Installation [Installation](https://www.51dbapi.com/v4.0.0/install/) ## Documents [Documents](https://www.51dbapi.com) ## Screenshot ![](https://img.51dbapi.com/dbapi/doc/images/create_ds-20250130-144443.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/ds_list-20250130-144545.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/group_more-20250130-145313.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/create_api_btn-20250130-150436.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/api_basic-20250204-170426.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/api_executor-20250130-150754.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/api_plugin-20250130-151343.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/sql_debug-20250204-182245.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/request-20250130-151734.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/create_btn_page-20250130-152038.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/client_auth_btn-20250130-152143.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/client_auth_page-20250130-152223.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/firewall-20250130-153257.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/monitor-20250130-160347.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/api_record_search-20250130-160458.jpg) ![](https://img.51dbapi.com/dbapi/doc/images/doc_export-20250130-155741.jpg) ## 联系 ### 微信公众号