# DBApi

**Repository Path**: longwst/DBApi

## Basic Information

- **Project Name**: DBApi
- **Description**: DBAPI是一个面向数仓开发人员的低代码工具，只需在页面上编写sql，并配置好参数，就可以自动生成http接口。它可以帮助程序员快速的开发后端数据接口，尤其适用于BI报表、数据可视化大屏的后端接口开发。
- **Primary Language**: Unknown
- **License**: AGPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 8
- **Forks**: 9
- **Created**: 2024-11-07
- **Last Updated**: 2025-11-20

## 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)

[![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)

<p align="center">
	👉 <a target="_blank" href="https://www.51dbapi.com">https://www.51dbapi.com</a>  👈
</p>

## 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:  <a target="_blank" href="https://support.51dbapi.com/#/demo">https://support.51dbapi.com/#/demo </a>

## 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/images/dbApi/20230523/create_ds_page.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/ds_page.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/group_more.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/api_basic.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/api_executor.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/api_plugin.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/sql_debug.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/private_api_request.png)

![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/create_client_page.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/client_auth_page.png)

![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/ip_firewall.png)

![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/monitor.png)
![](https://img.51dbapi.com/dbapi/images/dbApi/20230523/api_record_search.png)


## 联系

### 微信公众号

<img src="https://img.51dbapi.com/dbapi/images/dbApi/wechat.jpg" width = "200px" />