DBAPI

Build Rest API with SQL for all types of databases

Visit website

Free228 impressions#766 of its week

>log in to comment

A no-code development platform that allows you to write SQL and configure parameters on the page to automatically generate rest APIs. It helps programmers quickly develop backend data services. It supports for all types of databases

DBAPI turns SQL queries into production-grade REST APIs without writing backend code.

for: Developers and data teams needing quick, secure API layers over databases.

works withJDBCMySQLPostgreSQLSQL ServerOracleHiveRedisKafkaClickHouseLangChainSpring AIClaude DesktopCursor

Key features

8 features of DBAPI

Universal DB Support — Connect to any JDBC-compatible relational database, including MySQL, PostgreSQL, Oracle, SQL Server, Hive and domestic DBs.
Dynamic SQL to Instant API — Write MyBatis-style dynamic SQL and instantly generate CRUD, stored-procedure and multi-statement APIs.
Online Config & Real-Time Updates — Create, modify or deactivate APIs on-the-fly; changes take effect instantly without restarts.
Access Control & Observability — Client-ID/secret auth, IP firewall, rate limiting, full call tracing and logging to ClickHouse, MySQL or Kafka.
API Visual Orchestration — Chain multiple APIs on a DAG canvas with conditional logic, parameter chaining and Groovy scripts.
Multi-Engine Execution — SQL executor, ES DSL executor and HTTP proxy executor for unified data gateway capabilities.
AI-Powered Development — Generate dynamic SQL from natural language using 17+ LLMs and register APIs as MCP tools for AI agents.
Plugin Ecosystem — Cache, data transform, alert, parameter processing and global transform plugins extend functionality.

Use cases

Expose a legacy MySQL database as a secure REST API for a new frontend app
Create dashboard APIs that combine results from multiple SQL statements in one call
Integrate Elasticsearch log data via ES DSL executor and serve it through HTTP APIs
Orchestrate a multi-step data workflow that calls several APIs with conditional branching
Provide AI agents (e.g., LangChain, Spring AI) direct access to enterprise data via MCP endpoints

DBAPI FAQ

Do I need to write any backend code to create APIs?+

No, DBAPI generates production-grade HTTP APIs solely from SQL statements via its low-code engine.

Which databases are supported?+

All JDBC-compatible relational databases are supported, including MySQL, PostgreSQL, SQL Server, Oracle, Hive and domestic databases.

How are security and access control handled?+

DBAPI provides clientId/secret token authentication, IP firewall, rate limiting, RSA encryption for responses and detailed logging.

Can I modify an API without redeploying?+

Yes, APIs and data sources can be created, updated or deactivated online with changes taking effect instantly.

Is there AI assistance for writing SQL?+

Yes, an AI module can generate MyBatis-style dynamic SQL from natural-language descriptions using multiple LLMs.

What extensibility options are available?+

A plugin ecosystem offers cache, data transformation, alerting, parameter processing and global response formatting plugins, plus a Java SPI for custom extensions.

Summarized by DevHunt from 51dbapi.com · Oct 7, 2026. Details may change; check the official site.