1. Project Overview

Viewer - Zero-code API development platform

Viewer is a SpringBoot-based API agile development platform that breaks through traditional coding paradigms and provides one-stop data service capabilities from SQL to API. Through the visual SQL workspace, developers can publish standard RESTful interfaces without writing Java code, providing a rapid iteration solution for query and big screen scenarios, and helping enterprises quickly build high-performance data decision systems.

2. Open Source License

Licensed under Apache-2.0

3. Screenshots

Example Display

Custom Driver

Create Data Source

Query Statement

Setting Method

Method Parameters

Execution Details

Setting Interface

Basic Information

MCP

mcp server endpoint

mcp server verification

AI Related

AI endpoint

Model Settings

Function Call Logic Block

Running Results

4. Feature Overview

Core Features

• Zero-Code Development
  Saying Goodbye to Controller/Service/Dao Writing
• MyBatis SQL Support
  Directly Using Familiar SQL Syntax to Develop Interfaces
• Visual Operations
  Completing API Development Full Process through Web Interface
• Any Database
  Default Supporting MySQL, Can Be Extended through Custom Driver, and Can Be Extended through Interface, Supporting All JDBC Connected Databases
• Multiple Query Methods
  Implementing Integration with Third-Party Systems through Custom HTTP Requests and Custom Connectors
• Multiple Data Sources
  Supporting Cross-Data-Source, Cross-System Queries in One Request
• AI Assistance
  Implementing AI and Business Data Combination through FunctionCall
• High Performance
  Based on SpringBoot's Lightweight Architecture
• Real-Time Effectiveness
  Supporting Dynamic Creation, Modification of APIs; Dynamic Creation, Modification of Data Sources. Hot Deployment Throughout No Sense.

5. Tech Stack

5-Minute Rapid Experience

1. Download and run

# Download the latest JAR package (approximately 15MB)
# Windows startup command:
java -jar viewer-apis-service.jar
# Linux background process startup command:
nohup java -jar viewer-apis-service.jar >catalina.out 2>&1 &
# Shut down the project:
ps -ef|grep java
kill process number

User Guide

Create the First API

1, Access http://localhost:11791 to log in to the management interface

2, Add a data source in "Data Source Management" (supports all JDBC connections, custom connectors, etc.)

3, Create a new method in "Query Statement", select the data source created earlier

4, Write a SQL query statement that conforms to MyBatis, such as:

<select>
     SELECT * FROM users
     <where>
         <if test="username != null">
             AND username = #{username}
         </if>
         <if test="status != null">
             AND status = #{status}
         </if>
     </where>
</select>

or HTTP requests, if it is a POST request, add the <payload> tag:

<http>
     /department/list?access_token=${ACCESS_TOKEN}
     <if test="id != null and id != '' ">
         &id=${id}
     </if>
</http>
<payload>
     {
     <if test="get_party_path != null and get_party_path != '' ">
         get_party_path:${get_party_path}
     </if>
     }
</payload>

5, Add the required parameters in "Set Method"

6, Configure the execution details, use Spel expressions for parameter mapping

7, Create a new API in "Set Interface", select the method created earlier, and set the API path (such as /api/v1/users)

8, Save and return to the query interface, click the "Start" button to access the API gateway

Create MCP Service

1. Access http://localhost:11791 to log in to the management interface
2. Create a new McpServer endpoint in "McpServer"
3. Select the methods to be exposed externally, and set the service name, SSE path (such as /sse), message endpoint (such as //mcp/messages), etc.
4. Save and return to the query interface, click the "Start" button to access the MCP service