explaingit

tencent/apijson

📈 Trending★ 18,406JavaAudience · developerComplexity · 3/5ActiveSetup · easy

TLDR

A Java library that lets frontend clients query and modify databases directly via JSON requests, eliminating the need for custom backend API endpoints.

Mindmap

mindmap
  root((repo))
    What it does
      JSON-based queries
      Auto API docs
      No custom endpoints
    Key features
      Access control
      Multi-database support
      Security rules built-in
    Use cases
      Rapid frontend development
      Reduce backend workload
      Mobile app data access
    Tech stack
      Java ORM
      Relational databases
      Search engines
    Audience
      Frontend developers
      Backend teams
      Mobile developers

Things people build with this

USE CASE 1

Build mobile or web apps that fetch exactly the data they need without waiting for backend developers to write new API endpoints.

USE CASE 2

Reduce backend workload by letting frontend teams query databases directly with JSON requests and built-in security rules.

USE CASE 3

Automatically generate API documentation based on the JSON request structure without manual endpoint documentation.

Tech stack

JavaORMSQLRelational databasesSearch enginesTime-series databases

Getting it running

Difficulty · easy Time to first run · 5min
License could not be detected automatically. Check the repository's LICENSE file before use.

In plain English

APIJSON is a Java library that lets front-end developers (browsers, mobile apps, or other clients) query and write data from a database without requiring any custom backend API code. Instead of a backend developer writing a separate endpoint for each data request, the client sends a JSON-based request directly describing what data it wants, and APIJSON handles the query, security checks, and response, all automatically. The project describes itself as a "no-code ORM" (an ORM is a tool that maps database tables to code objects). It supports a wide range of databases including relational databases, search engines, time-series databases, and others. Alongside the Java reference implementation, community ports exist for several other programming languages. The library also generates API documentation automatically, since the structure of requests and responses is defined by the JSON format itself. Access control and security rules are built in, so developers can define which users or roles are allowed to read or modify which tables. The intended use case is reducing the workload for backend developers by letting front-end teams fetch exactly the data they need without waiting for new endpoints to be written, reviewed, and deployed.

Copy-paste prompts

Prompt 1
Show me how to set up APIJSON in a Java project and write a JSON query to fetch user data from a database.
Prompt 2
How do I define access control rules in APIJSON so that only certain users can read or modify specific database tables?
Prompt 3
Give me an example of how a frontend app would use APIJSON to query related data from multiple tables in a single JSON request.
Prompt 4
How does APIJSON handle security and prevent unauthorized database access from client-side requests?
Open on GitHub → Explain another repo

Generated 2026-05-18 · Model: sonnet-4-6 · Verify against the repo before relying on details.