Introducing magic-api: A Java Rapid API Development Framework

magic-api is a Java‑based rapid API development framework that enables developers to build HTTP APIs via a built‑in UI, eliminating the need to write Controllers, Services, DAOs, Mappers, XML, or VO classes.

Access the UI at http://localhost:9999/magic/web . Documentation, an online demo, and the open‑source repository are linked for further exploration.

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 with custom pagination support.

Multiple data‑source configuration with online data‑source management.

SQL caching and custom cache strategies.

Custom JSON responses and custom pagination results.

API permission configuration, interceptors, and runtime data‑source switching.

Swagger documentation generation.

Dynamic script compilation via the magic‑script engine without restart.

Linq‑style queries for easier association and transformation.

Full SQL support including concatenation, placeholders, conditional logic, and transaction handling.

File upload/download and image output capabilities.

Script version comparison and rollback.

Intelligent code assistance with hints, parameter tips, hover info, and error warnings.

Import of Spring beans and Java classes.

Online debugging tools.

Extensible custom utilities, modules, types, dialects, and column‑name conversions.

Quick Start

Maven Dependency

<!-- Use as a Spring Boot starter -->
<dependency>
  <groupId>org.ssssssss</groupId>
  <artifactId>magic-api-spring-boot-starter</artifactId>
  <version>1.7.1</version>
</dependency>

application.properties

server.port=9999
# UI entry point
magic-api.web=/magic/web
# Resource location (classpath = read‑only)
magic-api.resource.location=/data/magic-api

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

Finally, readers are invited to share the article, join the architect community group, and explore additional resources such as source code for ERP, workflow, OA, and visual‑screen projects.