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
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
VulcanSQL
API Tools
Data API Framework for AI Agents and Data Apps
Apache-2.0vs Tinybird★ 793
OpenAPI Generator
API Tools
OpenAPI Generator allows generation of API client libraries (SDK generation), server stubs
Apache-2.0vs Stainless★ 27k
Tyk
API Tools
Open Source API and AI Gateway supporting REST, GraphQL, TCP, gRPC and MCP (Model Context
OSSvs Apigee★ 11k
Unkey
API Tools
The Developer Platform for Modern APIs
OSSvs Zuplo★ 5.5k
CodeChat
API Tools
CodeChat - WhatsApp Api
Apache-2.0vs Twilio★ 1.3k
Orange API Gateway
API Tools
OpenResty/Nginx Gateway for API Monitoring and Management.
MITvs Apigee★ 2.3k
SaaS alternatives to DBAPI
See all
Amazon API Gateway
API Tools
Managed AWS service for creating, publishing and securing REST and WebSocket APIs
SaaS
AllRatesToday
API Tools
REST API for real-time currency exchange rates across 160+ currencies, plus transfer comparison
SaaS
Apollo GraphOS
API Tools
Platform for building, composing and operating federated GraphQL APIs
SaaS
AppForgeNow
API Tools
Converts REST APIs into ChatGPT apps by mapping responses to UI widgets and packaging a deployable bundle
SaaS
AutoContent API
API Tools
API that turns content into explainer videos, podcasts, infographics and quizzes with AI
SaaS
Axway Amplify
API Tools
API management platform for securing, managing and monetizing APIs
SaaS

