Introducing magic-api: A Java Rapid Development Framework for Backend Interfaces

magic-api is a Java‑based rapid development framework that enables developers to build HTTP API interfaces through a visual UI, eliminating the need to write traditional Controller, Service, DAO, Mapper, XML, or VO classes.

Access the UI at http://localhost:9999/magic/web . Documentation is available at https://ssssssss.org and an online demo at https://magic-api.ssssssss.org .

Features

Supports MySQL, MariaDB, Oracle, DB2, PostgreSQL, SQLServer and other JDBC‑compliant databases

Supports NoSQL databases such as Redis and MongoDB

Cluster deployment and automatic API synchronization

Pagination queries and custom pagination

Multiple data source configuration with online data source management

SQL caching and custom SQL cache

Custom JSON results and pagination results

API permission configuration and interceptor support

Runtime dynamic data source switching

Swagger API documentation generation

Dynamic script compilation via magic‑script engine without restart

Linq‑style queries for simpler joins and transformations

Database transaction support and advanced SQL syntax (concatenation, placeholders, conditional logic)

File upload, download, and image output

Script version comparison and recovery

Intelligent code hints, parameter hints, hover tips, and error detection

Import of Spring beans and Java classes

Online debugging

Custom tool classes, modules, type extensions, dialects, and column name conversion

Quick Start

Add the Maven dependency to your project:

<dependency>
    <groupId>org.ssssssss</groupId>
    <artifactId>magic-api-spring-boot-starter</artifactId>
    <version>1.7.1</version>
</dependency>

Configure application.properties as follows:

server.port=9999
# Configure web UI entry
magic-api.web=/magic/web
# Configure resource location (classpath prefix means read‑only mode)
magic-api.resource.location=/data/magic-api

The article also includes several screenshots demonstrating the UI, code hints, debugging, parameter tips, remote push, history records, data source management, and global search.

The open‑source repository is hosted on Gitee: https://gitee.com/ssssssss-team/magic-api .