DBAPI

Open source

Low-code data service tool that turns SQL written in a web UI into managed HTTP APIs, with API orchestration, many data sources and a Java runtime.

51dbapi.com
DBAPI homepage screenshot
GitHub stars
804
Last 30 days
+2(+0%)
Last commit
5 mo ago
Repository age
5 years
Licence
AGPL-3.0
Self-hosted
Yes

About DBAPI

DBAPI is a low-code data service platform aimed at data warehouse developers. You write SQL and set parameters in a web interface, and it generates HTTP API endpoints automatically, removing repetitive CRUD coding. The README positions it as an enterprise data service management center where data APIs are centrally managed, published, monitored and governed, for uses such as BI reports, dashboards, quick front-end prototypes and AI application data integration.

It needs no external dependencies beyond a Java runtime and runs in standalone or cluster mode on Windows and Linux. Data sources include MySQL, SQL Server, PostgreSQL, Oracle, Hive, Doris, OceanBase, GaussDB, Chinese databases such as DM and Kingbase, and any JDBC database, along with an Elasticsearch executor and an HTTP proxy executor for forwarding third-party REST APIs. SQL supports MyBatis-style dynamic syntax, an editor with run and debug, select, insert, update, delete and stored procedures, and combined multi-SQL execution with transaction control.

API orchestration uses a visual DAG canvas with start, API execution, condition and end nodes, passing earlier results to later steps, plus Groovy scripts for data processing. DBAPI is licensed under AGPL-3.0, has a live demo and documentation, and the interface text is partly Chinese.

Key features

  • Generates HTTP APIs from SQL
  • MyBatis-style dynamic SQL with debugging
  • Many relational data sources plus Elasticsearch
  • Visual DAG API orchestration
  • Groovy scripting for data processing
  • Standalone or cluster deployment on Java

Good fit for

  • Exposing warehouse queries as REST APIs for dashboards
  • Prototyping data endpoints without backend code
Built with
Vue tools
Tags
low-code
sql
rest-api
data-service
java
api-management
data-warehouse
bi

DBAPI: questions and answers

What is DBAPI used for?
DBAPI is a low-code data service tool that turns SQL written in a web UI into managed HTTP APIs, with API orchestration, many data sources and a Java runtime. It is a good fit for exposing warehouse queries as REST APIs for dashboards and prototyping data endpoints without backend code.
Is DBAPI open source?
Yes. DBAPI is open source under the AGPL-3.0 licence. Its source code is on GitHub at freakchick/DBAPI and is written mainly in Vue.
Is DBAPI free?
Yes. DBAPI is open source, so the software itself is free to use.
Can I self-host DBAPI?
Yes. DBAPI can be self-hosted on your own server or infrastructure.
What are some alternatives to DBAPI?
Similar open-source tools in the API Tools category include VulcanSQL, OpenAPI Generator and Tyk. SaaS products in the same category include Amazon API Gateway, AllRatesToday and Apollo GraphOS.
Is DBAPI actively maintained?
The most recent commit to DBAPI was on 13 June 2026. The project has 804 stars on GitHub, with 2 added in the last 30 days.

Open-source alternatives to DBAPI

See all

SaaS alternatives to DBAPI

See all